Data compare script is showing Syntax error

Dailylearner

Hi

I am using SQL Data compare 13 between two big databases. After comparison while deploying on to target database, it is always throwing error 

Incorrect Syntax near '='
Incorrect Syntax near '='
Incorrect Syntax near '='
Incorrect Syntax near '='
Incorrect Syntax near '='
Incorrect Syntax near '='
Incorrect Syntax near '='

Delete from tablename where column = 'XXXXX'.

This is what I am getting.

Not sure where it is going on, can some please provide your inputs regarding this error.

Thank you.

Dailylearner

update on this, when I deploy script for each table individually, I am not getting this error.

sam.blackburn

If you paste the deployment script into SSMS, do you see any red squiggles under the text?  I'd expect such syntax errors to be highlighted so you would see which part of the script is invalid.

Dailylearner

Thanks for your reply Sam. unfortunately script generated is too big for me to copy and paste. I have tried comparing those table failed individually and deployed it, and it is working.