HP Clustered Gateway Device Management Software manual

Page 7

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, the SQL jobs, and the 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.Virtualize the SQL Server instance on the target server. (Using HP PolyServe Software for Microsoft SQL Server, create a Virtual SQL Server and add the SQL Server instance to it.)

14.Test applications against the Virtual SQL Server.

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

16.Restore databases to the target server using NonRecovery (Backup and Restore Databases window).

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

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

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

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

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

22.Test applications against the Virtual SQL Server.

HP PolyServe Migration Utility for SQL Server user guide

7

Image 7
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