Architectural Discussion RRS feed

  • Question

  • I am planning to host one internet application. Is it suitable to use Data Sync offline mode with SQL Azure. I opted for SQL Azure because of Data Sync and CDN, it will handle conflict according. I have few questions

    1) Is it secure to use Data Sync for internet application?

    2)Application performance?

    3)Consider one criteria,Here for this application i need to make connection oriented because we can't schedule. One which client m/c you people sync


    Please provide answer for these problem.

    Wednesday, July 21, 2010 7:45 AM

All replies

  • plz help me on this. Its very urgent.
    Monday, July 26, 2010 10:45 AM
  • Hi anuphosur,

    Just to clarify, are you talking about using 'SQL Azure Data Sync'?


    Tuesday, July 27, 2010 3:38 AM
  • yes i am talking about SQL Azure Data Sync.Whether SQL Azure data sync is suitable for internet application? coz if we do it then it will consume lot of network bandwidth.
    Tuesday, July 27, 2010 7:30 AM
  • Hi Anuprhosur,

    To answer a few of your questions.  CTP (Community Technology Previews) of Microsoft software are not to be used in production systems.  The main reason is that there could be untested issues that we are not able to fix for production systems.

    As for some of your other questions,

    1) The communication of data changes between SQL Server and SQL Azure over the internet are encrypted. 

    2) The performance of synchronization was pretty good, however we have made a number of major performance optimizations that will be coming in Sync Framework 2.1 that will improve this a lot more.  Sync Framework 2.1 is scheduled to be released later this year.

    3) Are you asking about manually launching sync?  If so, perhaps you could use this stored procedure?




    Sr. Program Manager, SQL Azure and Sync Framework - http://msdn.microsoft.com/sync/
    Tuesday, July 27, 2010 9:23 PM