Answered by:
SQL Azure Data Sync Tool for SQL Server

Question
-
When using SQL Azure Data Sync Tool for SQL Server and you sink your local database with a remote server (in my case sql azure) you have select you local database and the table then the tool creates the database on the remote server. Which works as expected. My question is let say you need to add another table to be sync after the initial setup. If you try to use the tool again it wants you to delete the remote database with would mean you would loose all your data. Am I missing something here.
Thanks,
BryanThursday, March 18, 2010 6:26 PM
Answers
-
Unfortunately this CTP of SQL Azure Data Sync does not support the ability to add multiple scopes from a SQL Server DB to a single SQL Azure DB (or what you are referring to as adding additional tables). This is something we are considering suppoorting for the next release and I should mention that mutiple scopes are supported within the Microsoft Sync Framework if you were willing to do some coding. The only other option would be to re-create your sync environment and add the other table to this group.
Liam
Sr. Program Manager, SQL Azure and Sync Framework - http://msdn.microsoft.com/sync/- Proposed as answer by Liam Cavanagh - MSFTMicrosoft employee Friday, March 19, 2010 8:38 PM
- Marked as answer by Sid Singh [MSFT]Microsoft employee Tuesday, March 23, 2010 9:46 PM
Friday, March 19, 2010 8:38 PM -
Hi Bryan,
You can manually provision via the API using the SQLAzureSyncScopeProvisioning API. The steps would be similar to this http://msdn.microsoft.com/en-us/library/dd918848(SQL.105).aspx.
You can have multiple scopes, but once a scope is defined (a combination of tables + filters), you can't modify it (you can't add an additional table to the scope).
I maybe wrong, but you re-create the sync as Liam stated above, it's basically removing the sync (and all its associated objects) and re-doing it again, this time with your added table.
hth,
JuneT
- Marked as answer by Sid Singh [MSFT]Microsoft employee Tuesday, March 23, 2010 9:46 PM
Saturday, March 20, 2010 2:57 PM
All replies
-
Unfortunately this CTP of SQL Azure Data Sync does not support the ability to add multiple scopes from a SQL Server DB to a single SQL Azure DB (or what you are referring to as adding additional tables). This is something we are considering suppoorting for the next release and I should mention that mutiple scopes are supported within the Microsoft Sync Framework if you were willing to do some coding. The only other option would be to re-create your sync environment and add the other table to this group.
Liam
Sr. Program Manager, SQL Azure and Sync Framework - http://msdn.microsoft.com/sync/- Proposed as answer by Liam Cavanagh - MSFTMicrosoft employee Friday, March 19, 2010 8:38 PM
- Marked as answer by Sid Singh [MSFT]Microsoft employee Tuesday, March 23, 2010 9:46 PM
Friday, March 19, 2010 8:38 PM -
Liam,
Thanks for your reply. Does the CTP kind of lock you into something that can not grow (in my case add new tables as they are required)? And you mentioned that the framework supports multiple scopes. Where can this information be found. And lastly you mentioned (re-create your sync environment and add the other table to this group.) What did you mean? Sorry for not following the comment.
Thanks,
Bryan
Friday, March 19, 2010 10:41 PM -
Hi Bryan,
You can manually provision via the API using the SQLAzureSyncScopeProvisioning API. The steps would be similar to this http://msdn.microsoft.com/en-us/library/dd918848(SQL.105).aspx.
You can have multiple scopes, but once a scope is defined (a combination of tables + filters), you can't modify it (you can't add an additional table to the scope).
I maybe wrong, but you re-create the sync as Liam stated above, it's basically removing the sync (and all its associated objects) and re-doing it again, this time with your added table.
hth,
JuneT
- Marked as answer by Sid Singh [MSFT]Microsoft employee Tuesday, March 23, 2010 9:46 PM
Saturday, March 20, 2010 2:57 PM -
June,
Thanks for the reply. So anytime we want to add a table we have to delete the database on the cloud and rerun the CTP tool to set up the syncing again. Thus loosing all the data stored on the cloud database?
Thanks,
Bryan
Saturday, March 20, 2010 6:32 PM -
That is correct Bryan, you would need to delete the db in SQL Azure and rerun the CTP tool. Our apologies for the inconvenience of this and please know that this is a feature we plan to add as soon as possible.
Liam
Sr. Program Manager, SQL Azure and Sync Framework - http://msdn.microsoft.com/sync/Saturday, March 20, 2010 8:33 PM -
Liam,
Any ETA on this request. I got to sat that this appears to be a real draw back for anyone wanting to start using the cloud. The reason I say this is because there is alway's changes that need to be made and new tables added.
Bryan
Thursday, March 25, 2010 10:53 PM -
Hi Bryan,
This is a capability we are planning to get into the next release of SQL Azure Data Sync. The current target for release is the last half of this calendar year.
Liam
Sr. Program Manager, SQL Azure and Sync Framework - http://msdn.microsoft.com/sync/Friday, March 26, 2010 3:39 PM -
Liam,
Thanks for the update.
Bryan
Monday, March 29, 2010 12:35 PM