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

Using MxMigrate 23

Start Log Restore. Begin restoring the log to the target server.

NOTE: This step utilizes regular log backup, which could invalidate your

existing SQL 2000 backup strategy/schedule. On SQL 2005, the

COPY_ONLY flag is used to ensure that your backup strategy is

intact. See SQL Book Online for details.

DTS (for SQL 2000 Only) Window

The DTS window can be used to transfer SQL 2000 DTS packages from

the source server to the target server. DTS transfer is available only when

both the source and the target are running SQL 2000 and the DTS

packages are stored in the MSDB database on the source server.

NOTE: The DTS transfer operation does not validate or transfer any

external objects used by the DTS packages. You are responsible for

ensuring that all external object dependencies are transferred.

Select All. This is a shortcut for selecting all DTS packages.

Start. Begin scripting and transferring the DTS definition from the source

server to the target server.