1

Modify Pre-Deployment Script

• Add Server Logins to the pre-deployment script so that users can be appropriately mapped to logins.
• Add Keys & Certificates to the pre-deployment script.
• Add Linked Servers to the pre-deployment script.
• Add Custom Errors to the pre-deployment script.

2

Modify Post-Deployment Script

• Add Permissions to the post-deployment script so that schema objects have the appropriate grant, deny, and revoke permissions after creation.
• Add Signatures to the post-deployment script.
• Add stock data that you want to associate with your database project as a post-deployment script by adding insert statements for this data.

The generated scripts are appropriately modified.