Migrate to a new matrix, using the same hostnames/IPs
In this scenario, Matrix Server, HP PolyServe Software for Microsoft SQL Server, and the SQL Server instance are installed on the target node. The SQL Server instance has not yet been virtualized with HP PolyServe Software for Microsoft 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
11.Apply any
12.Test applications against the target server in
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
16.Back up the source transaction logs (Backup and Restore Logs window).
8Introduction
