HP Clustered Gateway Device Management Software manual

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