Wednesday, January 19, 2011 1:47 AM
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.
- Moved by Sethu SrinivasanMicrosoft Employee Saturday, October 27, 2012 7:34 PM SSDT - Deployment (From:SQL Server Application and Multi-Server Management)
Wednesday, January 19, 2011 11:09 PM
Is this what you were looking for?
Sunday, January 23, 2011 5:05 PMThanks for the reply. But this is not what I was looking for.
Monday, October 29, 2012 5:47 PMOwner
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/)