Hp PolyServe Software User Manual Page 1

HP StorageWorksHP PolyServe Migration Utility for SQLServer 4.1 user guidePart Number: T5392-96072First edition: September 2010

11. Apply any third-party applications, tools, and libraries to the target server sothat it will match the configuration of the source server.12. Test

2 Using MxMigrateInstall MxMigrateMxMigrate should be installed on either a node in the Matrix Server cluster or anothersystem that has network connec

Source Login windowThe Source Login window asks for the SQL login information needed to connect tothe source SQL Server instance.Using MxMigrate12

SQL Server Instance. Enter a valid SQL 2000, 2005, or 2008 instance such asMySQLSource or MySQLSource\Instance1.NOTE:If you are unsure of the instance

Then complete the Source Login window:Authentication Method. Select the desired authentication method to connect to theSQL Server instance. See SQL Se

SQL Server Instance. Enter a valid SQL instance such as MySQLTarget orMySQLTarget\Instance1. This SQL Server instance must not be the same as the sour

Select Databases for Transfer windowSelect the database(s) that you want to transfer to the target server. The window listsonly user databases and “mo

NOTE:Migration of a model database is supported only from SQL Server 2005 to SQLServer 2005, provided that the Service Pack level on the source is equ

Number of Parallel backups. Enter the number of threads that the system shouldspawn to perform the backup in parallel. This option is useful when ther

NOTE:The Validation step verifies only that the database exists; it does not check the statusof the database. If the database is not online and access

Legal and notice information© Copyright 2007, 2010 Hewlett-Packard Development Company, L.P.Confidential computer software. Valid license from HP requ

Click Save Info to save the results of the validation to a file.Click Start Validation to start the validation process. This process can be run as man

If a database is missing on the target server, use the Create DB option to create thedatabase shell on that server using the same database size and AN

Click Start Backup to start backing up the source SQL Server database to a sharedfolder.When the backup is complete, click Start Restore to begin rest

Pre-Switch Steps windowThe pre-switch steps include creating linked servers on the target server, transferringSQL logins and SQL jobs from the source

Create SQL jobs on Target server. This option transfers SQL jobs from the sourceserver to the target server. This box is checked by default.Set Source

SSIS (SQL2005/2008 only) windowThis window can be used to transfer SSIS packages. Check the individual packagesthat you want to transfer, or click Sel

Finished windowThis window appears when the migration is complete. It shows the migration statuslog, which you can save to a file for future reference

The MxMigrate utility also maintains a debug log called MxMigrate.log that canbe used for debugging purposes. The log is in the same directory as theM

Contents1 Introduction ... 4Overview ...

1 IntroductionOverviewThe HP PolyServe Migration Utility for SQL Server (MxMigrate) is a wizard-basedutility designed to move SQL Server databases int

Migrated dataMxMigrate migrates the following:• User data• SQL logins• Linked/remote servers• SQL jobs• SSIS packagesMxMigrate does not migrate or han

• Matrix Server must be installed and running on all nodes in the cluster.• HP PolyServe Software for Microsoft SQL Server must be installed on all cl

2. Validate and connect to the source SQL Server instance (Source Login window.)3. Validate and connect to the target (physical) SQL Server instance (

Migrate to a new matrix, using the same hostnames/IPsIn this scenario, Matrix Server, HP PolyServe Software for Microsoft SQL Server, andthe SQL Serve

17. Restore the transaction logs to the target server (Backup and Restore Logswindow).18. Migrate SSIS/DTS packages to the target server.19. Re-sync S