AVAYA DOCUMENTATION CENTER
Find answers to your technical questions and learn how to use our products
Avaya Context Store Snap-in Reference
Pre-migration checklist
Use the following checklist for the tasks that you must complete before migrating to Microsoft SQL Server for External Data Mart (EDM):
|
No.
|
Task
|
Notes
|
 |
|---|---|---|---|
|
1
|
Take a backup of the database.
|
The backup steps are different for different databases.
|
|
|
2
|
Clean the data.
|
This step speeds up the migration process.
Note:
This step is optional.
|
|
|
3
|
Remote desktop to the Windows server running the MS SQL server.
|
||
|
4
|
Create a new Microsoft SQL Server database using Microsoft SQL Server Management Studio.
|
See, Creating a new database in this chapter.
|
|
|
5
|
Copy and extract the script and its configuration file to a new folder on the server running the MS SQL Server.
|
See Downloading the migration script in this chapter.
|
|
|
6
|
Edit the config.properties file in a text editor.
|
See Editing the configuration file for the migration in this chapter.
Note:
This procedure describes a worked example using Notepad. You can use any text editor.
|