Activity overview
Latest activity by RMD
Jonathan,
Excellent. I read through the documentation you guys have up, and was hoping it would work this way. / comments
Jonathan,
Excellent. I read through the documentation you guys have up, and was hoping it would work this way.
Jonathan,
This all makes sense, and it's basically what I assumed the answer was.
As we've settled on using TFS/Release Management for CI/CD, and as the solution of branching/merging when deploying to each environment leaves a bad taste in my mouth, I think I'd like to try Migrations v2.
Would the model I'm trying to go for work well with v2 Migrations?
Basically, I would set up sqlcompare to execute as part of the deployment process. For the command line, I would point it at the location of the source folder for the build in question. Since that source is a snapshot of the code *and* the DB for the current build, and since you no longer rely on "schema version" to figure out what migration scripts to run, I should be able to then complete the comparison and update the target deployment.
My worry is that I believe the way that Release Management works is that the build output moves from environment to environment. I.e.:
1.) Get source by label for build XXXX.
2.) Build output.
3.) Take build output and deploy it to environment X.
4.) When approved, take build output and deploy to environment Y.
etc.
So I would need to make sure that by source controlled DB schema was part of my build output. I would then just make sure I always performed the comparison against that directory structure, presumably, in my build drop location.
Sound right? Or does the fact that a temp DB is used to generate a complete deployment script - migrations and all - mitigate the need to worry about this? / comments
Jonathan,
This all makes sense, and it's basically what I assumed the answer was.
As we've settled on using TFS/Release Management for CI/CD, and as the solution of branching/merging when deploying...
Jonathan,
We are deploying both code and the database with each build, and yes, we're using TFS 2012. (Although we are moving to 2013 shortly.)
Right now we use TFS Deployer - which basically executes a powershell script when the build quality is set to some predetermined value on the build. When we move to TFS 2013, we'll be using the Release Management project to do the same thing for every build.
As it stands right now, we only deploy to a dedicated test/qa environment using TFS Deployer. Our team is fairly small (~5 people), so doing a bit of coordination to ensure that somebody doesn't check in a breaking DB change in between the time I've kicked off a build and told it to deploy isn't a huge deal.
But we are expanding, and we are moving to a more formal dev/qa/prod automated release system. This means it is fairly likely we will have different versions deployed to each environment, and without the ability to tie a DB release to a code release, we're dead in the water.
Your Migrations v2 stuff seems to solve this problem by no longer relying on extended properties in the DB to store your own "schema version" info... but from what I hear, we're still 6+ months away from v2 migrations being available generally. / comments
Jonathan,
We are deploying both code and the database with each build, and yes, we're using TFS 2012. (Although we are moving to 2013 shortly.)
Right now we use TFS Deployer - which basically execu...
Using SQL Compare and TFS for Continuous Delivery
I am using the SQL Automation Pack to do continuous delivery.
To make sure the source I'm obtaining matches the build that is actually being deployed, I'd like to pass something like /revision1:[BU...
Static Data Filtering
Is there any way to include a subset of data in a table when linking static data via SSC?
I have a configuration table which includes some required and some optional data. It would be great if I co...
So you're adding the entire database to source control, and then setting up filters so that you're only checking in/out the stuff that matches your schema (or whatever)?
Is there a way to not have to add the entire database? This 3rd party database has tens of thousands of objects. / comments
So you're adding the entire database to source control, and then setting up filters so that you're only checking in/out the stuff that matches your schema (or whatever)?
Is there a way to not have ...
Partially Source Controlled
I have several projects that are add-ons to a 3rd party application. This 3rd party application has a very large database, and many customers want my add-ons to have their schema/data in the same d...
The Azure compatible releases expire in a couple of days. Any word on an update? / comments
The Azure compatible releases expire in a couple of days. Any word on an update?
I'll send the log file. I might be able to create a demo app, but not until after the holiday weekend.
Thanks. / comments
I'll send the log file. I might be able to create a demo app, but not until after the holiday weekend.
Thanks.
Whoops. You're correct. I meant to post this in the ANTS Performance Profiler forum. Can somebody move it for me, or should I just repost.
SOrry. / comments
Whoops. You're correct. I meant to post this in the ANTS Performance Profiler forum. Can somebody move it for me, or should I just repost.
SOrry.