locked
ADO.Net Sync Services With Server Database That Is Not Open to the Public? RRS feed

  • Question

  • Hi,

    We've been using Merge Replication for about a year, but because of conflict problems we are now considering ADO.Net Synchronization Services. We will be using SQL Compact 3.5 databases for our smart client applications. For our server database, we wish to keep it behind a firewall where it will not accept any public requests. With Merge Replication we could do that since we had our web server as a go-between. (Merge Replication had an ISAPI dll that the smart client could connect to and the ISAPI would in turn communicate with the database server.) Is there anything similar in ADO.Net Synchronization Services? We cannot have server database open to the public.

    Thanks,
    Darren
    • Moved by Max Wang_1983 Friday, April 22, 2011 4:49 PM forum consolidation (From:SyncFx - Microsoft Sync Framework Database Providers [ReadOnly])
    Monday, September 22, 2008 6:52 PM

All replies

  • Would your SQL server be allowed to talk to Web Service through a firewall?  If do then ADO.NET for Synchronization Service can be possibly used to replace Merge Replication.

     

    Thanks.

    Monday, September 22, 2008 8:27 PM
    Answerer
  • The database server and web server are both on the same domain and they can both freely talk to each other. It's just that the database server is closed to the outside world, while the web server is open to it. So the SQL server should be able to talk to a web service that sits on our web server just fine.

    Is the web service something that we have to build from scratch to suit our database schema, or is something that can be built easily using some type of wizard? We would need to sync every table in our schema and it would have to be bi-directional. If creating this web service won't a huge project in itself, then that may be an option. If you could point me in the right direction with how exactly to do this, that would be great.

    Thanks for your reply!
    Darren
    Monday, September 22, 2008 9:08 PM
  • This is the only link that I have in hand, http://msdn.microsoft.com/en-us/library/bb882690.aspx.  Would you like to give a try?

     

    Thanks.

    Wednesday, September 24, 2008 9:00 PM
    Answerer