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

Using MxMigrate 19

Start Validation. Click Start Validation to start the validation process.

This process can be run as many times as desired.

Create DB. If a database is missing on the target server, use this option to

create the database shell on that server using the same database size and

ANSI options as the source server. (No data is transferred.) Scroll down

the validation report, select the missing database, and then click Create

DB.

You can specify the location for each of the database files on the New

Database window.

Name. The logical file name for the database.

File Group. The file group to which the database file belongs.

File Path. The physical path to the database file.

To specify an absolute path for the database file, type the path and click

Set.

Click Create Database on Target to start the database creation on the

target server.

Click Close to close the dialog with making any changes.

NOTE: The minimum size for a SQL Server 2005 database is 2 MB. If you

are creating a database shell for a SQL Server 2000 database that

will be migrated to SQL Server 2005, the operation will fail if the

SQL Server 2000 database is less than 2 MB.