Versions Compared

Version Old Version 5 New Version 6
Changes made by

Eric Schullek (Unlicensed)

Eric Schullek (Unlicensed)

Saved on

Key

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

...

  • 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

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?", and 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 source database.

  4. Click Next to verify the connection and continue.

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.

Expand
titleConfigure Connection to Staging Server

Configure Connection to Staging

  1. If the blank database you intend you 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

Image RemovedImage 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.

...