How to: Specify Pre-Deployment or Post-Deployment Scripts
You might have one or more scripts that you want to run before or after the deployment of your database. Visual Studio Premium provides a single pre-deployment script and a single post-deployment script in the database project. If your environment is relatively simple, you can add your script statements to these script files. If you have a more complex environment and need to run multiple scripts or one script multiple times, you might find it easier to use SQLCMD mode in the pre-deployment or post-deployment script to include your own deployment scripts.
To modify the pre-deployment script
In Solution Explorer, expand your database project to display the Scripts folder.
Expand the Scripts folder so that the Pre-deployment subfolder appears.
Expand the Pre-deployment subfolder, and click the script.predeployment.sql file.
On the View menu, click Open.
The Transact-SQL editor opens, displaying the contents of the script.predeployment.sql file. For information about SQLCMD mode and how to include your own scripts as part of the pre-deployment script, see Editing SQLCMD Scripts in the Transact-SQL Editor. Included scripts are executed in the order in which you include them, so you can control the running order of your pre-deployment scripts by including them in a specific order.
Note
You can also double-click the script.predeployment.sql file.
When you have finished editing the script, open the File menu, and click Save script.predeployment.sql.
To modify the post-deployment script
In Solution Explorer, expand your database project to display the Scripts folder.
Expand the Scripts folder so that the Post-deployment subfolder appears.
Expand the Post-deployment subfolder, and click the script.postdeployment.sql file.
On the View menu, click Open.
The Transact-SQL editor opens, displaying the contents of the script.postdeployment.sql file. For information about SQLCMD mode and how to include your own scripts as part of the post-deployment script, see Editing SQLCMD Scripts in the Transact-SQL Editor. Included scripts are executed in the order in which you include them, so you can control the running order of your post-deployment scripts by including them in a specific order.
Note
You can also double-click the script.postdeployment.sql file.
When you have finished editing the script, open the File menu, and click Save script.postdeployment.sql.
See Also
Tasks
How to: Build a Database Project to Generate a Compiled Schema (.dbschema) File
Concepts
Creating and Modify Database Scripts
Build and Deploy Databases to an Isolated Development Environment
Build and Deploy Databases to a Staging or Production Environment