Managed Develop & Stage environments with a shared database model

Hi All,

We have a simple setup in the way we work which is as follows.

We have two environments, develop and stage, all our work is done on develop until we are ready to start a release/test. We branch from "develop" to "release/release-1.0" (git).

In SQL Source control both the develop and stage databases are linked to a source control folder (the same one locally). During testing we will fix any bugs on the stage database and commit them to "release/release-1.0". Once a release has been signed off we are ready to move any bug fixes from the ""release/release-1.0" branch back to "develop" the process falls down. We merge those changes from "release/release-1.0" to "develop" which is fine, but getting them applied to the develop database, seems well clunky. We have to generate a script (using compare) to perform the upgrade and then manually apply it, is this the best way? or are we doing source control for databases incorrectly?

Thanks

Best Answers

Sign In or Register to comment.