Versions Compared

Version Old Version 1 New Version Current
Changes made by

Bhakti Honmute (Unlicensed)

Eric Schullek

Saved on

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.

Expand
titleConfigure Connection to Source SQL Server

...

expand Connection SQL Server
title

Configure

Connections to Source

Image RemovedImage Added

  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
Image Removed

Select Source DMS

Image Added

  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.

Expand
titleConfigure Connection to Staging Server

...

Server
Expand
title

Configure Connection to Staging

Image RemovedImage Added

  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.

Select Staging Database

Expand
titleSelect Staging Database
Image Removed

Select Staging DB

Image Added

  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
Image Removed

Migration Details

Image Added

  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.