Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Azure Data Sync Expand / Collapse
Author
Message
Posted Friday, February 25, 2011 1:51 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 2:02 PM
Points: 119, Visits: 1,152
I am using the SQL Azure Data Sync at https://datasync.sqlazurelabs.com to sync a table between 2 Azure databases on different servers. The initial sync is working fine but I need to re-create due to the addition of a new column.

I have deleted the sync group, tracking tabkle, triggers and sync stored procedures in the hub database. When I create a new sync group I am getting an error Invalid column name 'newCol'. This is a sync to a new empty database so I guess the problem is some left over metadata somewhere in the hub (or master) database?

Any ideas how to solve this issue or how to re-create a sync when adding new columns?

Thanks
Post #1069450
Posted Friday, February 25, 2011 5:34 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Monday, April 14, 2014 9:07 AM
Points: 865, Visits: 1,094
Depending on how you've gutted the old solution: Could be trying to insert into NewCol that doesn't exist as yet (hasn't been initialised).

Carlton.
Post #1069527
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse