Stucked with CI and SQL Compare

Forum for users of SQL Compare schema synchronization utility

Stucked with CI and SQL Compare

Postby fredendrix » Thu Apr 04, 2013 1:28 pm


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!
Posts: 24
Joined: Tue Dec 18, 2012 2:40 pm
Location: Quebec (Canada)

Postby Brian Donahue » Mon Apr 08, 2013 2:45 pm

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
Posts: 6590
Joined: Mon Aug 23, 2004 9:48 am

Return to SQL Compare Previous Versions

Who is online

Users browsing this forum: No registered users and 1 guest