Run the DTS for migrating the Microsoft Access databases 

Important!

The �Upgrade from Access to SQL Server� procedure is essential to run the messaging software. If you do not perform this procedure, you will not be able to run the messaging software.

Upgrade from Access to SQL Server

To migrate the old Access databases to SQL 7.0, do the following:

  1. Ensure that all of the old message (pre 4.0) databases are in the location, C:\Program Files\Avaya\MessageCare\database. If this directory does not exist (if the messaging software is installed on another drive), create this directory and copy the databases to the new location.

  2. From the Start button, select Programs->Microsoft SQL Server 7.0->Enterprise Manager.

  3. Run the DTS to migrate the MsgCareAdmin.mdb database by doing the following:

    1. Right-click Data Transformation Services.

    2. Select All tasks and then select Open Package.

    3. From the MessageCare directory, select SQLTools->Install-> MigrateAdmin.dts.

    4. Select the Package menu, and then click Execute.

  4. Repeat Step 3 to migrate the MessageCare.mdb database using the MigrateMessages.dts file.

  5. Repeat Step 3 to migrate the ArchiveMessageCare.mdb database using the MigrateArchive.dts file.

  6. Run the index scripts to improve database access. Refer to the Apply the indexes.

  7. Verify that the databases are properly migrated by running a few searches and reports using the Current and Archive databases.

  8. From the Start button, select Programs->Microsoft SQL Server 7.0->Enterprise Manager.

  9. From your server, go to Databases->MCmessages->Tables. Right-click on Tables, and then select Design Table.

  10. Change the Length of Subject Column Name from 128 to 512.

  11. Save changes to the table.

  12. Repeat Steps 8�11 for the Outbound and Workbench tables located in the MCmessage->Tables path.

Apply the indexes

  1. From the Tools menu in SQL 7.0 Enterprise Manager, select the SQL Server Query Analyzer.

  2. In the Query window, click the second icon from the top left (Load SQL Script).

  3. In the Open Query File dialog box, go to the directory where the messaging software is installed.

  4. Under MessageCare/SQLTools/Install, select the file MessageCareIndexes.SQL, and then press the Enter key to open it.

  5. Press the F5 key or select the Execute button.

   


Copyright © 2001
Avaya Inc.
All rights reserved.
Modified: March 19, 2001