We have a database solution in our company that has three SQL Server with each separate database, in each example some jobs and reproductions Now for now we are manually maintaining build and update scripts and can execute them with bat files. Our deployment package includes scripts for all items including jobs and replication.
We want to automate our process to create and test deployment packages after each svn commit-constant integration. Apart from this, we have branches for every release, according to a database version released, different customers have different releases / versions installed. We need to create a deployment package for any branch.
Can we use SQL Server Data Tools 2012 for our requirements? I have only seen the tutorial for a single database and I do not know how to use it in a more complicated environment.
Alternatively, we can use the data tool to maintain the schema script And you can write manual scripts for job / replication. But can we use the construction process to combine it into a package?
You should be able to use this for each instance through SSDT, published one Create profiles and set up your CI jobs accordingly.
In all the examples, standardizing your database names (especially if they are all for the same product) will help.
Comments
Post a Comment