Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Table of Contents

The New Migration Wizard walks you through the process of configuring all of the required settings for a new migration project.To open the wizard, either:

Opening

  • Select Create a New Migration from the startup window and click OK.

  • Open the File menu and select New Migration....

New Migration Wizard

Upon opening the wizard, you will be greeted by the welcome screen. Click Next to move to the first configuration page.

Source SQL Server
Expand
titleConfigure Connection to Source SQL Server
Expand
title

Configure Connections to Source

  1. In the Server field, enter the name of the SQL server hosting the source database.

  2. Under "How should Cloud Migrator authenticate with the server?"

,
  1. and select either Windows Authentication or SQL Server Authentication.

  2. If you selected SQL Server Authentication above, enter the User Name and Password of a SQL account with DBO access to the intended source database.

  3. Click Next to verify the connection and continue.

Select DMS Database

Expand
titleSelect DMS Database

Select Source DMS

  1. In the drop-down list under "Which database contains the library you want to migrate?", select the source Work database.

  2. In the drop-down list under "What is the database's schema version?", select 9.1 if the schema version is greater than 8.5 (this includes 10.x); otherwise, select 8.5.

  3. In the field under "What is the name of the ODBC connection used by the source DMS?", update the default value if the library/ODBC connection name does not match the the name of the underlying database.

  4. Click Next to continue.

Staging Server
Expand
titleConfigure Connection to Staging Server
Expand
title

Configure Connection to Staging

  1. If the blank database you intend

you
  1. to use for staging data is hosted by the same SQL server as the source database, check Use the same server as the source; otherwise, enter the name of the SQL server hosting the staging database.

  2. If you are not using the same connection information as the source database, under "How should Cloud Migrator authenticate with the server?", select either Windows Authentication or SQL Server Authentication.

  3. If you selected SQL Server Authentication above, enter the User Name and Password of a SQL account with DBO access to the intended staging database.

  4. Click Next to verify the connection and proceed to the next screen.

...

Expand
titleSelect Staging Database

Select Staging DB

  1. Under "Which database will store the staging data?", open the drop-down menu and select the name of the blank database to which the source data will be copied.

  2. Click Next to continue.

...

Expand
titleMigration Project Details

Migration Details

  1. Under "By what name do you want to refer to the migration?", enter a name for the migration's settings file.

  2. If you do not want to save the MIGRATION file to the default location (<User Forlder>\Documents\My Migrations), under "Where do you want to save the migration?", click Change..., select a new target folder, and click OK.

  3. Click Next to continue to the Completing the Wizard screen, and then click Finish to close the wizard.