Moving the Database
After the application code is deployed to the target machines, a copy of the database needs to be moved for the application to function properly. You can copy data between SQL Servers in several ways. You can back up the source database and restore it on the new server, use the Copy Database Wizard, use the Data Transformation Services (DTS) Import/Export Wizard, use the Bulk Copy Program (BCP), or use the INSERT command along with a distributed query to select data from another source. For our scenario, two methods make sense: the backup and restore method and the DTS Import/Export Wizard.
Backing Up and Restoring Databases
Three general steps are involved in copying a database via the backup and restore method:
- Backing ...
Get Building e-Commerce Sites with the .NET Framework 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.
