Order of table syncronization

mohaaronmohaaron Posts: 46
edited October 6, 2010 4:04PM in SQL Data Compare Previous Versions
Can someone tell me how data compare decides what order the tables are synced in in the generated script?

I ask because I am now having a problem with the generated script inserting rows of one table that are dependent on another table. This causes the sync to fail every time now. The only thing I can do is copy the script into query analyzer and manually cut/paste the inserts into the correct order.
· Share on Twitter

Comments

  • David AtkinsonDavid Atkinson Posts: 1,462 Rose Gold 2
    Hi,

    This sounds like a bug . It shouldn't be ordering the statements as you described. Is there any chance that you could provide us with the necessary to reproduce it in-house so we can fix it for the next release? Which version of SQL Data Compare are you using (the version number can be found in the About dialog)?

    Thanks and best regards,

    David Atkinson
    Red Gate Software
    David Atkinson
    Product Manager
    Redgate Software
    · Share on Twitter
  • mohaaronmohaaron Posts: 46
    The version that I have is 5.2.0.40.

    What do you need me to provide to help you solve this. I could give you the script that is generated, would that help? Did you want the script along with the schema?
    · Share on Twitter
  • David AtkinsonDavid Atkinson Posts: 1,462 Rose Gold 2
    Thank you for emailing us your schema details.

    If we manage to reproduce this in-house there is a good chance we can fix this for the next release.

    Best regards,

    David Atkinson
    Red Gate Software
    David Atkinson
    Product Manager
    Redgate Software
    · Share on Twitter
  • Chris SpencerChris Spencer Posts: 301
    Just a note to say that we've reproduced this issue in-house and have logged it in our bug tracking system as a candidate for the next release

    Many Thanks
    Chris Spencer
    Test Engineer
    Red Gate
    · Share on Twitter
  • mohaaronmohaaron Posts: 46
    Thank you. That is good news. It will be great to have this fixed.

    Regards,

    Aaron
    · Share on Twitter
  • senkumarsenkumar Posts: 1
    We using datacompare 8.0 & still having issue with the script that datacompare generates. It doesn't put the statements in the right order... any solution for this\did this bug get fixed?


    -Senthil.
    · Share on Twitter
Sign In or Register to comment.