Null fields and Zero-Length strings when comparing schemas (4236953)

When synchronizing databases, after comparing two databases via the Compare | Data Compare menu option, differences appear between the records because the insert adds zero-length strings instead of nulls.

WORKAROUND:
To make data in both tables equal, run the Data Synchronization Wizard again, select 'Open script in Toad Editor' and then using 'Find and Replace' replace all '' values with NULL values and run the edited script.

STATUS:
Waiting for fix in a future release of Toad for SQL Server