Incorrect syntax near 'REBUILD'.
nikhilshikarkhane
Posts: 4
I am synchronizing source scripts to dest db ( 9.00.3068.00) using Sql compare ( 8.50.12.18 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
Comparing
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 ?
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
Comparing
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 ?
Comments
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.
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com