HP Clustered Gateway Device Management Software manual

Page 9

17.Restore the transaction logs to the target server (Backup and Restore Logs window).

18.Migrate SSIS/DTS packages to the target server.

19.Re-sync SQL securities and logins on the target server (Post-Switch Steps window)

20.Shut down the source server.

21.Virtualize the SQL Server instance on the target server. (Using HP PolyServe Software for Microsoft SQL Server, create a Virtual SQL Server with the same IP and hostname as that of the source server and add the SQL Server instance to it.)

22.Test applications against the Virtual SQL Server.

Migrate to an existing matrix, using different 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 and the SQL Server instance has already been virtualized with HP PolyServe Software for Microsoft 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).

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

HP PolyServe Migration Utility for SQL Server user guide

9

Image 9
Contents MxMigrate Page Contents How MxMigrate works IntroductionPrerequisites Migrated dataMigration scenarios Migrate to a new matrix, using different hostnames/IPsPage Migrate to a new matrix, using the same hostnames/IPs Migrate to an existing matrix, using different hostnames/IPs 10Introduction Start MxMigrate Using MxMigrateSource Login window Page Target Login window HP PolyServe Migration Utility for SQL Server user guide Select Databases for Transfer window Options window Validation window Access check Using MxMigrate Backup and Restore Databases window Using MxMigrate Pre-Switch Steps window Backup and Restore Logs window Ssis SQL2005/2008 only window Post-Switch Steps windowFinished window
Related manuals
Manual 95 pages 29.82 Kb