Database Deployment
To deploy the CSK you will need to create a database with all of the necessary objects (tables, stored procedures, and so on) for your production website. In addition, you may want to copy the records and data stored in your development database to the server. In this section we will examine how to achieve this by using Data Transformation Services (DTS), using Backup / Restore features of SQL Server, and using just SQL script.
DTS Deployment
In this DTS walkthrough, we will create a new database on our production server for the CSK and move all objects and data from our development database. To begin, start the SQL Server Enterprise Manager. Right-click the development database, select All Tasks, and select Export Data. This should bring up the DTS Import/Export Wizard.
In the Choose a Data Source step of the DTS wizard, your development database should already be selected, so click Next. In Choose a destination, enter the connection parameters to connect to the production...
