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

Introduction 6

• Migrate to a new matrix. The SQL Server instance on the source node

and the Virtual SQL Server on the target node will use the same

hostname and IP address.

• Migrate to an existing matrix. The SQL Server instance on the source

node and the Virtual SQL Server on the target node will use different

hostnames and IP addresses.

Migrate to a New 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. The SQL Server instance has not

yet been virtualized with MxDB for SQL Server.

After the target SQL Server instance is virtualized during the procedure,

the source SQL Server and the target Virtual SQL Server will have unique

host names and IPs and can be running side-by-side.

Complete the following steps:

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).

7. Create any missing databases on the target server (Validation > New

Database window).

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

window).

9. Restore databases to the target server, using the Recovery feature.

(Backup and Restore Databases window).