locked
Data sync from a remote webserver Between two SQL Database RRS feed

  • Question

  • I m a newbie and I have few question about Microsoft Sync Framework

    I have read few articles and examples, every where i m getting discussion about syncing data between SQL Compact Database and Sql Server Database. My Question are ;

    1. Can we sync Database between two or more Sql Server 2008 Databases.

    2. Can we sync Two Sql server 2008 Database Between Local Server and Remote Web Server. If yes than Please let me know How complicated will it be to develop.

    For example : There is a database on local server in a office which will be manipulated by a Windows Application. And a Database in a Shared Web Server which will be manipulated by Company Website. If a customer places a order through Company website it should be update in local Database. Could Sql Server Replication Services Help or Microsoft Sync Framework or any other type of solution.

    Please tell me the best and simple solution for such kind of senerio.

    Thanks in Advance.

     

     

     

    Tuesday, June 21, 2011 8:04 PM

Answers

All replies

  • 1. It depends on the provider that you're going to use. If you use SqlSyncProvider, you can sync between Sql Express, Sql Server and Sql Azure. see this tutorial: http://msdn.microsoft.com/en-us/library/ff928700(v=SQL.110).aspx, it should work with Sql Server to Sql Server sync since SqlExpress, SqlServer and Sql Azure uses the same SqlSyncProvider

    2. Yes. two ways you can achieve this. you can do a 2-tier setup where you can have an sync application either running locally or on the remote database server. the above link should be able to do that. however, this means opening up database ports between the two servers. The better way would be to do an n-tier setup where using WCF. check out this sample: http://code.msdn.microsoft.com/Database-SyncSQL-Server-e97d1208

    you can also use Replication if you want, have a look at this link comparing Sync Framework with Merge Replication: http://blogs.msdn.com/b/sqlservercompact/archive/2009/11/09/merge-replication-vs-sync-services-for-compact.aspx

     

    • Marked as answer by Rahul_Kr Sunday, July 3, 2011 4:59 AM
    Wednesday, June 22, 2011 12:44 AM
  • Thanks JuneT,

    The Shared web server we are going to use has Sql Server Standard installed, for development i m using Sql Developer Edition

    1. Is it possible to Sync Between Sql Standard Database and Sql Developer Database using Microsoft Sync Framework.

    2. Is it possible to Sync between One Sql Standard Database and other Sql Standard Database using Microsoft Sync Framework.

     

    Thanks in Advance.

    Wednesday, June 22, 2011 5:16 AM
  • yes to both questions. the providers doesnt make a distinction between the  product editions.
    Wednesday, June 22, 2011 5:22 AM