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

Introduction 8

Migrate to a New Matrix, Using the Same

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 Virtual SQL Server will use the same host name and IP as the source

SQL Server instance. Therefore, the source SQL Server instance must be

shut down before virtualizing the target SQL Server instance.

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

10. Apply the SQL securities and logins, SQL jobs, and linked/remote

server configurations found on the source server to the target server

(Pre-Switch Steps window).

11. Apply any third-party applications, tools, and libraries to the target

server so that it will match the configuration of the source server.

12. Test applications against the target server in stand-alone mode.