Git, Linked Tables, and Branching/Merging

A SQL Server Management Studio add-in to source control your database in Subversion or Team Foundation Server.

Git, Linked Tables, and Branching/Merging

Postby JackAce » Fri Jul 11, 2014 9:37 pm

We've migrated most of our SVN repos to Git and developers are working mostly with feature branches that get merged into a develop branch (using the GitFlow branch development structure).

We have several linked/lookup tables that we version control using SQL Source Control.

When merging our updates to these records we often hit merge conflicts since SQL Source Control always puts updated/inserted rows on top and then puts them back in their proper order on the next commit.

This will not work well with developers who most often work out of a feature branch and then merge changes back into a common branch.

Is Red Gate addressing this issue? Is there a current work-around for this? It seems like if we *always* forced the records to be in numeric order then a lot of this headache would be avoided.
Posts: 47
Joined: Fri Jul 08, 2011 10:00 pm

Postby Brian Donahue » Mon Jul 14, 2014 3:37 pm

There is a very lively discussion going on about this on Red Gate's uservoice site: ... r-to-merge

This site will make it easier to interact with the people who actually have an influence over SQL Source Control.

I believe there is also a workaround posted that involves using SQL Data Compare to regenerate the SQL data scripts, which it seems to do in a consistent order unlike Source Control.

Hope this helps.
Brian Donahue
Posts: 6590
Joined: Mon Aug 23, 2004 9:48 am

Return to SQL Source Control 3

Who is online

Users browsing this forum: Yahoo [Bot] and 0 guests