Compares and synchronizes SQL Server databases, backups and scripts.
Moderators: JonathanWatts, Chris Auckland, David Atkinson, Anu Deshpande, Michelle Taylor, alice.easey, james.billings, chengvoon.tong
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 v188.8.131.526) 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)
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.
- Posts: 6668
- Joined: Mon Aug 23, 2004 10:48 am
Return to SQL Compare 10
Who is online
Users browsing this forum: No registered users and 2 guests