Deploying the same changes to multiple copies of the same databases
Ant
Posts: 17 Bronze 1
Hi,
We're looking at deploying the same changes to our multiple copies of our customer databases and are currently using SQL Compare in TeamCity (CI) (Compares against an empty database and a database with the current version) and Octopus (Deployment), We are using Tenants in Octopus for each of the databases.
Is there a way to take a deployment script created by the SQL Compare in the TeamCity (One for a clean deploy and one for an upgrade.) and apply that to the multiple databases, with Octopus. We need to do this so we don't have the overhead of running SQL Compare against each database each time. It's not causing an issue now, while we are in development, but when we have 100's of databases being maintained than this will become an issue.
regards,
Anthony
We're looking at deploying the same changes to our multiple copies of our customer databases and are currently using SQL Compare in TeamCity (CI) (Compares against an empty database and a database with the current version) and Octopus (Deployment), We are using Tenants in Octopus for each of the databases.
Is there a way to take a deployment script created by the SQL Compare in the TeamCity (One for a clean deploy and one for an upgrade.) and apply that to the multiple databases, with Octopus. We need to do this so we don't have the overhead of running SQL Compare against each database each time. It's not causing an issue now, while we are in development, but when we have 100's of databases being maintained than this will become an issue.
regards,
Anthony
