HP PolyServe Software User Manual

Page 8

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.

Start MxMigrate.

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

Validate and connect to the target (physical) SQL Server instance (Target Login
window).

Select the databases to be migrated (Select Databases for Transfer window).

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

Validate your entries (Validation window).

Create any missing databases on the target server (Validation > New Database
window).

Back up the source databases (Backup and Restore Databases window).

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.

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.

Back up the source transaction logs (Backup and Restore Logs window).

Introduction