Should you exemplificate me how to use pre- and post-deployment script?

There are some statements you may want to run before or after database is deployed. Those may be setting users, permissions, server settings, etc.

.When you build, the database deployment script generated in your output directory (i.e. ..\\Database6\Database6\Sql\NewDB or ..\\Database6\Database6\Sql\UpdateDB ) is prepended by the content of the Pre-Deployment Script and Post-Deployment script is attached at the end. If you want to see an example of it, put

PRINT 'PRE_DEPLOYMENT'

or any valid SQL statement in Pre-Deployment Script and see the resulting build script or do deployment. Repeat the same for Post-Deployment.

Pre- and Post Deployment script functionality will be enhanced before final ship date, so this script structure is not finalized yet.

Dmitriy_Nikonov_MSFT at 2007-9-10 >