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
|