Why do inserted/updated records get moved to the top?

Compares and synchronizes SQL database content.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, Michelle Taylor, chengvoon.tong

Why do inserted/updated records get moved to the top?

Postby JackAce » Wed Mar 05, 2014 10:04 pm

I'm sure this has been asked before, but the search function on phpBB is quite horrible.

When you add or update records, the underlying script puts those records at the top of the generated file in their own SET IDENTITY_INSERT section.

My issue with this is that it makes diffing the file difficult and it makes the svn/git blame history inaccurate when used in conjunction with SQL Source Control.

Is there a reason for this that I am not understanding?
JackAce
 
Posts: 45
Joined: Fri Jul 08, 2011 11:00 pm

Postby Manfred.Castro » Thu Mar 06, 2014 6:03 pm

Hi JackAce,

The order of the data script is pretty much random. The tool was not designed to create scripts that could be read by a diff tool.

There is an existing feature request under the internal reference number of SDC-1134 to make the scripts order more consistent so they can be handled better by diff tools.

I will add your details to the existing request.

Manfred
Manfred Castro
Product Support
Red Gate Software
Manfred.Castro
 
Posts: 209
Joined: Mon Apr 23, 2012 2:49 pm


Return to SQL Data Compare 10

Who is online

Users browsing this forum: No registered users and 0 guests