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, let alone help you find those records. So:

A pre-synch report of data that would be truncated would be a super enhancement.

If you don't care about the truncation (or hope it doesn't matter!) and need the synch to work 'by brute force', why isn't 'ANSI Warnings OFF' or 'Allow data truncation' a project option. I'm not aware of any way of doing this except editing the script.

Steve

s_solt 15 years ago

Comments

1 comment

Hi Steve,

This feature has been requested a few times now, our internal reference number is SDC-1011. Hopefully we can implement this at some point.

Brian Donahue 15 years ago

0