What are the challenges you face when working across database platforms? Take the survey

Incorrect syntax near 'REBUILD'.

edited November 16, 2010 8:55AM in SQL Compare Previous Versions
I am synchronizing source scripts to dest db ( 9.00.3068.00) using Sql compare ( version).

When i compare and sync using the GUI Sql Compare. It works fine. But when i use sqlcompare.exe with a argument file then it gives me following error :-

Registering data sources
Creating mappings
Applying Command Line Items
Creating SQL
Synchronizing databases (from DB1 to DB2)
Error: Synchronization of 'Scripts.Release' and
'servernameremoved.dbnameremoved' failed: Incorrect syntax near
'REBUILD'. Incorrect syntax near the keyword 'with'. If this statement is a
common table expression or an xmlnamespaces clause, the previous statement must
be terminated with a semicolon.

Anyone faced the same problem ?


  • Options
    Anu DAnu D Posts: 876 Silver 3
    Many thanks for your post.

    Looks like my colleague Chris is already working with you on this issue so we will post the final resolution to this issue once the original call is closed.

    Kindly let us know if you have any other issues or questions regarding the product,I'll like to help.
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: support@red-gate.com
Sign In or Register to comment.