Automate deployment of DB objects across environments

Question

Hi,

I work in an environment where we have deployments everyday and the code for DB object changes need to be deployed on Test, UAT, Pre-Prod and Prod environments and it takes ____ lot of time to copy .sql files from TFS Database
folder and deploy each individual file. Could somebody provide inputs to automate deployment process.

Thanks

Answer 1

Is this what you were looking for?

 

http://www.codeproject.com/KB/install/WSE3Deployment.aspx

Answer 2

Thanks for the reply. But this is not what I was looking for.

Answer 3

To automate deployment, either one of these options would be appropriate:

- SQLPackage.exe: http://msdn.microsoft.com/en-us/library/hh550080(VS.103).aspx

- MSBuild (no robust documentanio at this time, but Gert's post is a good starting point: http://sqlproj.com/index.php/2012/03/headless-msbuild-support-for-ssdt-sqlproj-projects/)