Stucked with CI and SQL Compare

Compares and synchronizes SQL Server databases, backups and scripts.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, eddie davis, Anu Deshpande, Michelle Taylor, alice.easey, james.billings, chengvoon.tong

Stucked with CI and SQL Compare

Postby fredendrix » Thu Apr 04, 2013 2: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 3:40 pm
Location: Quebec (Canada)

Postby Brian Donahue » Mon Apr 08, 2013 3: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: 6670
Joined: Mon Aug 23, 2004 10:48 am

Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 0 guests