Compares and synchronizes SQL database content.
Moderators: JonathanWatts, Chris Auckland, David Atkinson, Michelle Taylor, chengvoon.tong
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?
- Posts: 45
- Joined: Fri Jul 08, 2011 11:00 pm
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.
Red Gate Software
- 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