SQL logic error near ")":syntax error

Mike_Vessey77Mike_Vessey77 Posts: 7 New member
in SQL Compare
when I attempt to run a sql compare between a redgate generated sql backup and our live database we get the following error

SQL logic error near ")":syntax error

any help would be appreciated
Tagged:
· Share on Twitter

Comments

  • Alex BAlex B Posts: 1,132 Diamond 4
    Hi @Mike_Vessey77,

    I've just been in touch via a support ticket to gather further information as my initial test of this backing up a simple SQL 2017 database with compression level 4 and encryption with a 256-bit key is working as a target in SQL Compare version 13.7.12.

    I will update here once we have progressed the investigation via the ticket!

    Kind regards,
    Alex
    Product Support Engineer | Redgate Software

    Have you visited our Help Center?
    · Share on Twitter
Sign In or Register to comment.