Red Gate forums :: View topic - Why do inserted/updated records get moved to the top?
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Data Compare 10
SQL Data Compare 10 forum

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

Search in SQL Data Compare 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
JackAce



Joined: 08 Jul 2011
Posts: 45

PostPosted: Wed Mar 05, 2014 10:04 pm    Post subject: Why do inserted/updated records get moved to the top? Reply with quote

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?
Back to top
View user's profile Send private message
Manfred.Castro



Joined: 23 Apr 2012
Posts: 209

PostPosted: Thu Mar 06, 2014 6:03 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group