Stucked with CI and SQL Compare

fredendrixfredendrix Posts: 32
edited April 8, 2013 10:45AM in SQL Compare Previous Versions
Hi!

It seems that I’m stucked in a situation that some have probably seen before, but i don’t know exactly how to resolve :

Using SQL Source Control, we’ve committed some changes, including a DROP of a tables (without migration script!). So the TeamCity build grab the change, but SQL Compare (via Gate's SQL Continuous Integration v1.0.0.536) block the publication because of « High severity warning ». The upgrade script failed and i don’t know what to do.

Thanks for help!
· Share on Twitter

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    Hello and thanks for your post. If the context of this is within the "TeamCity" plugin for SQL Compare, then the answer is that it currently tries to prevent data loss by flagging any operations that will drop data (dropping a table or column, for instance) and stopping the update if any of these warnings are raised.

    This version does not allow you to override the behavior at present, but it will be addressed in the future.

    In the meantime, best advice is to perform this particular update by hand.
    · Share on Twitter
Sign In or Register to comment.