locked
Is this possible - Existing Sql Azure syncing to Local SQL Server so I can backup? RRS feed

  • Question

  • I have an existing SQL Azure database.  I was wondering if I could creating a syncing relatiohship with a local database so I can run daily backups.  Does that make sense, and if so, how would I go about doing this?

     

    Thanks.

    Monday, August 9, 2010 10:03 PM

Answers

  • We are planning on extending Sql Azure Data Sync to include the scenario you mentioned. Its just not available right now. Writing the sync provider code (which is not much atmost 20 lines of code) yourself is the only option now.


    Maheshwar Jayaraman - http://blogs.msdn.com/mahjayar
    • Marked as answer by woodrowX Wednesday, August 11, 2010 5:05 PM
    Wednesday, August 11, 2010 4:45 PM

All replies

  • Sure. Use Sql Azure Data Sync - http://www.microsoft.com/windowsazure/developers/sqlazure/datasync/

     


    Maheshwar Jayaraman - http://blogs.msdn.com/mahjayar
    • Marked as answer by mjayaram Monday, August 9, 2010 10:31 PM
    • Unmarked as answer by woodrowX Monday, August 9, 2010 11:51 PM
    Monday, August 9, 2010 10:31 PM
  • Thank you for your answer.  However, when I go to run the wizard it seems that it wants to create a sync based on my NOT YET having SQL Azure setup and running.  I need to create a sync with an existing and running SQL Azure database to a new (or even old copy ) of a local database.  How do I accomplish this?

     

    Thanks.

    Monday, August 9, 2010 11:04 PM
  • So because there are no responses, I assume that you can NOT sync an existing SQL Azure database to a local SQL Server?  How does everyone else backup their data?
    Tuesday, August 10, 2010 4:13 PM
  • So you want to start off from an existing Sql Azure and sync down to an Sql server? If yes, then you are right that the UI doesnt allow it. You could however manually write the code to pull the description from Sql Azure, provision a local database and then set up two sync providers to synchronize among them.
    Maheshwar Jayaraman - http://blogs.msdn.com/mahjayar
    Tuesday, August 10, 2010 8:31 PM
  • Okay, thanks.  I guess I was just looking for an easy way to backup my SQL Azure Database and I had read that Sync + SQL Server Backup was the way to go.  I'm not so sure that this is a viable option for easy maintenance (especially because I am too unfamiliar with Sync and Sql Azure).   
    Tuesday, August 10, 2010 8:35 PM
  • We are planning on extending Sql Azure Data Sync to include the scenario you mentioned. Its just not available right now. Writing the sync provider code (which is not much atmost 20 lines of code) yourself is the only option now.


    Maheshwar Jayaraman - http://blogs.msdn.com/mahjayar
    • Marked as answer by woodrowX Wednesday, August 11, 2010 5:05 PM
    Wednesday, August 11, 2010 4:45 PM
  • Thank you, Maheshwar.  You make it seem like it wouldn't be too difficult; maybe I'll give it a shot.
    Wednesday, August 11, 2010 5:06 PM