How can we help you today? How can we help you today?

Data compare script is showing Syntax error

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.
Boon
0

Comments

3 comments

Sort by
  • Dailylearner
    update on this, when I deploy script for each table individually, I am not getting this error.
    Dailylearner
    0
  • 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.
    sam.blackburn
    0
  • 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.
    Dailylearner
    0

Add comment

Please sign in to leave a comment.