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

Introduction 10
Copyright © 1999-2007 PolyServe, Inc. All rights reserved.
7. Create any missing databases on the target server (Validation > New
Database window).
8. Back up the source databases (Backup and Restore Databases
window).
9. Restore databases to the target server, using the Recovery feature
(Backup and Restore Databases window).
10. Apply the SQL securities and logins, SQL jobs, and 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. Back up the source databases (Backup and Restore Databases
window).
14. Restore databases to the target server using NonRecovery (Backup
and Restore Databases window).
15. 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).
16. Back up the source transaction logs (Backup and Restore Logs
window).
17. Restore transaction logs to the target server (Backup and Restore Logs
window).
18. Test applications against the Virtual SQL Server.