Running a Data Compare and sync for SQL Server tables. When running the Sync script the following error is displayed
'Incorrect syntax near ''.'
On reviewing the delete SQL statement that Toad has produced, I identified the following statement
[DESCRIBED_PREMISES_TXT] IS ''
the contents of the cell is blank ,not NULL
the syntax should be
[DESCRIBED_PREMISES_TXT] = ''
Correct the SQL statement prior to running the script
Waiting for fix in a future release of Toad for Data Analysts