Generated script from SQL Compare inconsistent.

thiriththirith Posts: 4
edited November 22, 2010 6:43PM in SQL Compare Previous Versions
Hi All,

I am trying to generate an updated script for my production DB.

First, I generated the update script from comparison between script folder of Production DB and my development script folder.
But, I could not run it on my target DB (Production DB).

Second, The update script was generated from comparison between backup of production DB to my development DB.
The update script run successful on my target DB (Production DB).

I found that the update script from above step are difference.

My question is WHY?

Thanks,
Thirith.
Chanthirith CHIN
· Share on Twitter

Comments

  • David AtkinsonDavid Atkinson Posts: 1,458 Rose Gold 2
    That doesn't sound right. They should be the same. Would you be ale to diff both sync scripts and let us know where they differ?

    Please accept our apologies. We'd be keen to put this right.

    David Atkinson
    Product Manager
    Red Gate Software
    David Atkinson
    Product Manager
    Redgate Software
    · Share on Twitter
Sign In or Register to comment.