Synchronization issues
Posted: Wed 12 Dec 2012 10:06
The synchronization feature doesn't seem to work very well, unless i'm just missing something. I've just downloaded the trial dbForge Studio for SqlServer v3.0.136.
What I want to do is sync a local database with remote database (pull down the schema and data).
I'm seeing the error Error: Incorrect syntax near 'AS'. The local sql server is 2008 r2 (dev) and remote is sql server 2008 r2 std.
The views do not exist locally and dbForge would not create them, just the error as above. I had to manually create them. It also will not create sprocs on local machine that do not exist, but exist on remote machine.
What I want to do is sync a local database with remote database (pull down the schema and data).
I'm seeing the error Error: Incorrect syntax near 'AS'. The local sql server is 2008 r2 (dev) and remote is sql server 2008 r2 std.
The views do not exist locally and dbForge would not create them, just the error as above. I had to manually create them. It also will not create sprocs on local machine that do not exist, but exist on remote machine.