Activity overview
Latest activity by nikhilshikarkhane
So how did you fix it ??? / comments
So how did you fix it ???
This is how to reproduce this issue:
1. create a table A with a column "OrderType" with a CHECK constraint so that this column can have values from the set { 'Cash', 'Card' }
2. Sync another database with this schema
3. Create a new table B with one column "OrderType" which is primary key.
4. Now drop CHECK constraint from Step 1.
5. Add foreign key on table A referring to table B.
6. Now sync the db in step 2 again.
Boom you will get this error. / comments
This is how to reproduce this issue:
1. create a table A with a column "OrderType" with a CHECK constraint so that this column can have values from the set { 'Cash', 'Card' }
2. Sync another databa...
Incorrect syntax near 'REBUILD'.
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...