none
How to synch SQL database and SQL CE Database? Without IIS?

    Question

  • Hi,

    I am doing my first synchronization. I have a mobile device (MD) with wireless connection to a server. The MD uses some tables, changes some data and nothing more. There will be only one MD and one server. I watched a video how to use Merge replication. But this replication goes trough IIS and I am thinking for a faster way to do it.

    1. Is there any other method?
    2. What is the difference between Merge replication and SqlCeReplication assembly?
    3. Can I use SqlCeReplication class to directly synch my data without going trough IIS and HOW?
    4. What about Sync Services for ADO.NET?

    In other words I am asking which technology is suitable in my situation.
    Wednesday, February 25, 2009 1:48 PM

Answers

  • 1:  If your device is always connected, and you are using .NET Compact Framework on the device, it would be possible to use a direct connection with SqlClient.

    2: SqlCeReplication assembly is the SQL Compact Merge replication client component.

    3: No, SqlCeReplicaion always calls the SQL Compact Server Agent (sscesa35.dll), which is an ISAPI DLL, which must be installed on IIS.

    4: Sync Services for Devices would also require an IIS (or something similar).

    Hope this helps.
    Erik Ejlskov Jensen, MCTS: WM App, MCITP: SQL 2008 Dev - http://erikej.blogspot.com Please mark as answer, if this was it.
    • Marked as answer by mynkow Wednesday, February 25, 2009 5:32 PM
    Wednesday, February 25, 2009 2:25 PM

All replies

  • 1:  If your device is always connected, and you are using .NET Compact Framework on the device, it would be possible to use a direct connection with SqlClient.

    2: SqlCeReplication assembly is the SQL Compact Merge replication client component.

    3: No, SqlCeReplicaion always calls the SQL Compact Server Agent (sscesa35.dll), which is an ISAPI DLL, which must be installed on IIS.

    4: Sync Services for Devices would also require an IIS (or something similar).

    Hope this helps.
    Erik Ejlskov Jensen, MCTS: WM App, MCITP: SQL 2008 Dev - http://erikej.blogspot.com Please mark as answer, if this was it.
    • Marked as answer by mynkow Wednesday, February 25, 2009 5:32 PM
    Wednesday, February 25, 2009 2:25 PM
  • 10x for the reply.

    I just saw that when I am configuring publication on the server I can choose to download the replication files via FTP.
    Is it a good solution to use FTP instead HTTP for merge replication?
    Wednesday, February 25, 2009 2:51 PM
  • You cann use ftp with SQL Compact, only http.
    Erik Ejlskov Jensen, MCTS: WM App, MCITP: SQL 2008 Dev - http://erikej.blogspot.com Please mark as answer, if this was it.
    Wednesday, February 25, 2009 4:01 PM