3.6.0 Migration Utility for SQL Server Operations Guide (5697-7090, December 2007)

Introduction 9

13. Back up the source databases (Backup and Restore Databases

window).

14. Restore databases to the target server using NonRecovery (Backup

and Restore Databases window).

15. Put the source database in ReadOnly mode. Users will now be

accessing the target server for data, not the source server (Pre-Switch

Steps window).

16. Shut down the source server.

17. Virtualize the SQL Server instance on the target server. (Using MxDB

for SQL Server, create a Virtual SQL Server and add the SQL Server

instance to it.)

18. Test applications against the Virtual SQL Server.

Migrate to an Existing Matrix, Using Different

Hostnames/IPs

In this scenario, Matrix Server, MxDB for SQL Server, and the SQL Server

instance are installed on the target node and the SQL Server instance has

already been virtualized with MxDB for SQL Server.

At the end of the procedure, the target Virtual SQL Server and the source

SQL Server instance will have unique host names and IPs and can be

running side-by-side.

1. Start MxMigrate.

2. Validate and connect to the source SQL Server instance (Source Login

window.)

3. Validate and connect to the target (physical) SQL Server instance

(Target Login window).

4. Select the databases to be migrated (Select Databases for Transfer

window).

5. Specify the location for the backup files (Options window).

6. Validate your entries (Validation window).