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

Introduction 4

Migrated Data

MxMigrate migrates the following:

•User data

•SQL logins

• Linked/remote servers

•SQL jobs

• DTS packages (SQL 2000 to SQL 2000 migration only)

MxMigrate does not migrate or handle the following:

• System databases (for example, master, msdb, tempdb)

• SSIS settings and packages

•Replications

• Log shipping

• Fulltext (SQL 2000)

• Database mirroring

• External dependencies

• Reporting Services

• Notification Services

•Service Broker

MxMigrate does not handle auto-close or offline databases. The databases

to be migrated must be online.

Prerequisites

The following Microsoft Software must be installed on the computer

running MxMigrate:

• Microsoft Windows XP or 2003 (R2, SP1, SP2), either 32-bit or 64-bit

• Windows Installer 3.x

•.NET Framework 2.0

• Microsoft XML provider (MsXml6)

• Microsoft SQL Native Client provider (MsNCli)