Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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