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
NB I couldn’t find a wishlist on the support forums.
For several years I have wanted a project option to set ANSI_WARNINGS OFF when I am happy to ignore data truncation warnings. I know I can (and do):
• Copy the script to the clipboard
• Paste it into SSMS
• Edit two lines
• Execute it
• Go back to SQL Compare
• Close the deploy dialog
But this is a bit of a performance, particularly if I am using repeated deployment attempts fixing each error in turn that prevents the synch in order to identify all the issues other than those related to data truncation.
- Posts: 7
- Joined: Thu Mar 01, 2007 12:42 pm
- Location: London
Return to SQL Compare 10
Who is online
Users browsing this forum: No registered users and 0 guests