Conclusion
To transfer your database from one server to another, you can back it up and restore it on the target server, you can copy it while it is detached, and then attach the copy to the target server, you can use SQL Server’s replication features, or you can use SSIS. Which method you choose depends on your application and your environment. You’ll find the most versatility through a combination of SQL Server Agent and SSIS.
Chapter 4 Quick Reference
| To | Do this |
|---|---|
| Create a database backup in SQL Server Management Studio | Right-click the database in Object Explorer, and select Tasks | Back Up. |
| Restore a database in SQL Server Management Studio | Right-click the Databases folder in Object Explorer, and select Restore Database. |
| Detach a database in SQL ... |
Get Microsoft® SQL Server™ 2005: Applied Techniques Step by Step now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
