Posts
Sort by recent activity
ANSI_WARNINGS Project Option
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 (an...
Detecting or overriding truncation errors
Of course SQL Compare warns of thoretical truncation when you alter data types or field lengths, but it doesn't check whether any data actually exists in the source database that will be truncated,...
SQL Compare doesn't seem to totally handle dependency
When I need to apply a huge number of schema changes to a target database, SQL Compare doesn't seem to follow a path which takes account of dependency.
I have a target (eg from MS Access) which has...
How do I prevent/track truncation errors on table synch
If I have a client (target) database with populated tables and I want to synchronise it with my development (source) master, there may be records which include data which exceeds the preferred size...