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

JackAceJackAce Posts: 75
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?


  • 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 Castro
    Product Support
    Red Gate Software
Sign In or Register to comment.