2

Here is the story, I am using RedGate SqlCompare to generate update scripts for my Dev env, each package contains only changes from current Dev version to Latest in source control. Here is an example:

  1. I create a table (package-0.1) -> Deploy to DevDB
  2. I add Columns (package-0.2) -> Deploy to DevDB
  3. I renamed some Column (package-0.3) -> Deploy to DevDB

But once I want to promote it to QA it causes me problem because it promotes only latest package-0.3 that contains only part of the changes (renaming of the column)

So I am looking for a way to deploy all the packages prior to current on Promotion if it is possible.

By now I solved that by creating custom package that contains all the change scripts, but is it possible to solve that with Octopus?

Thanks Ihor

Ihor Bats
  • 169
  • 1
  • 12

1 Answers1

4

each package contains only changes from current Dev version to Latest

The way you do it is going to be painful for you as SQL Compare takes a state based approach. What you want to apply is the migrations based approach. You can see Alex's post on the difference between two approaches.

SQL Source Control 5 will come with a better migrations approach which will work with SQL Compare command line tool and DLM Automation tools. However, beta is closed right now unfortunately but I suggest you to contact the team through the e-mail address provided there.

The other option you have is ReadyRoll which has the pure migrations based approach. You can see this post on its octopus deploy integration.

tugberk
  • 57,477
  • 67
  • 243
  • 335