Software

NOTE:
The Validation step verifies only that the database exists; it does not check the status
of the database. If the database is not online and accessible, the
create/backup/restore operations will fail.
Access check
To check for access to the backup directory, MxMigrate executes the following from
the source and target server:
Exec master..xp_cmdshell N'dir <backup_path or restore_path>
This step requires that xp_cmdshell execution be allowed during the migration.
To turn on xp_cmdshell on SQL 2005/2008, use the SQL Surface Area
Configuration tool or run the following script.
--enable xp_cmdshell for sql2k5
exec sp_configure 'show advance','1'
reconfigure with override
go
exec sp_configure 'xp_cmdshell','1'
reconfigure with override
go
To turn off xp_cmdshell on SQL 2005/2008, use the SQL Surface Area
Configuration tool or run this script.
--disable xp_cmdshell for sql2k5
exec sp_configure 'xp_cmdshell','0'
reconfigure with override
go
Validation process
In addition to validating access, the validation process can save the results of the
validation to a file and can create any missing databases on the target server.
HP PolyServe Migration Utility for SQL Server 4.1 user guide 19