Part 2 of my test results
- 'sharing' the migration scripts folder was a bad idea.
The second branch always try to destroy the scripts added by the first branch (sees it as a pended delete).
- I came back to my original setup and tested some more with SQL Compare. The only case I will see the migration scripts detect properly is when I use the 'B1' branch (my development branch) as the source of comparison. It never seems to work when trying to generate from the production branch.
A bit more of background:
We are working with a 'code promotion' type of branching strategy for our code, and our database needs to follow the same path as well. Most of the database changes are done from our 'DEV' branch. They eventually get merged (promoted) to our QA branch and finally to STABLE branch (production). The latter is where the version upgrade scripts for our system are usually generated from.
Hope this helps