Previous Topic

Next Topic

Inhoudsopgave

Book Index

Perform Data Migration

Perform the steps below to perform an ANSI_NULLS table migration:

  1. Stop all web services that communicate with the database.

    If your organization uses web services made by other parties, stop these as well.

  2. Stop all windows services that communicate with the database. Depending on the contents of your Isah License Server, choose one of the following options:
  3. Make a backup of the database to migrate.
  4. If applicable, disable database triggers on the database to migrate.
  5. Stop the SQL Server Agent (in SSMS, right-click on SQL Server Agent and choose Stop).
  6. Remove replication for the database (only used in some customization).
  7. Start a command prompt as administrator in the directory that contains the migration tool and run the Migrate.bat program. The tool will show the required parameters and the location of the output. Information on the migration steps that are run, is available in Migration Steps.

    Please refer to Use of the Migration Tool for further information on Migrate.bat

  8. Check the output of the migration.
  9. If applicable, enable database triggers on the migrated database.
  10. If applicable, re-install replication.
  11. Make a backup of the database.
  12. Start the SQL Server Agent (in SSMS, right-click on SQL Server Agent and choose Start).
  13. Start all windows services that communicate with the database. Depending on the action you performed in step 2, choose one of the following options:
  14. Start all web services that communicate with the database.