How can we help you today? How can we help you today?

Stucked with CI and SQL Compare

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!
fredendrix
0

Comments

1 comment

Sort by
  • Brian Donahue
    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.
    Brian Donahue
    0

Add comment

Please sign in to leave a comment.