"offline" synchronization

  • Hi,

    We have setup a merge synchronization between several computers. We use Microsoft SQL Server 7.0 and WIN2000. There is one server who communicates with the clients. Now the question: Is it possible to perform an offline(!) synchronisation between a client and the server? For example: on the client, we perform the synchronisation that results in a file. We put the file on a CD and on the server, we synchronize also, but instead of directly communicate with the client we use the file. This must be possible in the other way also (from server to client). Does anyone has tried this before or does anyone has the same problem?

    Thanks in advance.

  • Dont think it will work directly. Probably better off rolling your own replication code if you need this.

    Andy

    http://www.sqlservercentral.com/columnists/awarren/

  • Thanks for answering my question.

    My own replication code ?!? How do I start on something like that? I suppose that example code of this matter does not exist?

  • It can range from mildly difficult to a ton of work depending on much conflict resolution you want to do. No code sample handy. You can either keep a running list of changes to be applied or you can just track which rows have been changed and how.

    Andy

    http://www.sqlservercentral.com/columnists/awarren/

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply