3.6.0 Migration Utility for SQL Server Operations Guide (5697-7090, December 2007)

Introduction 5

• Microsoft SQL 2005 client redistributables (XMO)

Following are additional requirements:

• Matrix Server must be installed and running on all nodes in the

cluster.

• MxDB for SQL Server must be installed on all cluster nodes that might

host the SQL Server instance.

• The Microsoft SQL Server instance must be installed as described in

the MxDB for SQL Server documentation.

• If you are not using agents, the source and target servers must have

access to the backup directory (share).

• The PolyServe Management Console must be installed on the

computer running MxMigrate.

Migration Scenarios

The following scenarios are supported for migrating a stand-alone,

non-virtualized SQL Server instance into a PolyServe matrix, making the

instance highly available.

The scenarios assume that Matrix Server, MxDB for SQL Server, and the

SQL Server instance are installed on the target node. In the “New Matrix”

scenarios, the SQL Server instance is virtualized on the target node

during the migration procedure. In the “Existing Matrix” scenario, the

SQL Server instance is virtualized on the target node before starting the

migration procedure.

A SQL 2000 instance can be migrated to either SQL 2000 or SQL 2005. A

SQL 2005 instance can be migrated only to SQL 2005.

The supported migration scenarios are:

• Migrate to a new matrix. The SQL Server instance on the source node

and the Virtual SQL Server on the target node will use different

hostnames and IP addresses.