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

Introduction 7
Copyright © 1999-2007 PolyServe, Inc. All rights reserved.
10. Apply the SQL securities and logins, the SQL jobs, and the
linked/remote server configurations found on the source server to the
target server (Pre-Switch Steps window).
11. Apply any third-party applications, tools, and libraries to the target
server so that it will match the configuration of the source server.
12. Test applications against the target server in stand-alone mode.
13. Virtualize the SQL Server instance on the target server. (Using MxDB
for SQL Server, create a Virtual SQL Server and add the SQL Server
instance to it.)
14. Test applications against the Virtual SQL Server.
15. Back up the source databases (Backup and Restore Databases
window).
16. Restore databases to the target server using NonRecovery (Backup
and Restore Databases window).
17. Put the source database in ReadOnly mode. Users will now be
accessing the target server for data, not the source server (Pre-Switch
Steps window).
18. Back up the source transaction logs (Backup and Restore Logs
window).
19. Restore the transaction logs to the target server (Backup and Restore
Logs window).
20. Re-sync SQL securities and logins on the target server (Post-Switch
Steps window).
21. Test applications against the Virtual SQL Server.