none
SQL Azure Data Sync Tool for SQL Server RRS feed

  • 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,
    Bryan
    Thursday, 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/
    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

    Saturday, March 20, 2010 2:57 PM
    Moderator

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/
    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

    Saturday, March 20, 2010 2:57 PM
    Moderator
  • 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