Replicate Data Between SQL 2005

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Brian P. Hammer - 09 Dec 2007 01:25 GMT

All,

I am looking at updating our .Net application to allow off line clients. By
this, I mean clients using the .Net app while not connected to the internet
or our corporate network. The application currently uses SQL 2005 to house
data and some application configurations. I don't have an issue deploying
SQL to the mobile users but want to know my options to sync the data between
the databases. Once I have those options, I can manage conflicts from there.

So, what are my options to keep data on a server and client(s) and when the
client connects back to the network, merge them?

Thanks,
Brian

Reply to this Message

Ekrem Önsoy - 09 Dec 2007 09:28 GMT

Merge Replication of course.

You can find more info about Merge Replication from the following link:

Replicating Data Between a Server and Clients:
http://msdn2.microsoft.com/en-us/library/ms151787.aspx

Merge Replication Overview:
http://msdn2.microsoft.com/en-us/library/ms152746.aspx

Signature

Ekrem Önsoy

> All,
>
[quoted text clipped - 11 lines]
> Thanks,
> Brian

Reply to this Message

Brian P. Hammer - 10 Dec 2007 05:14 GMT

Thank you Ekrem.

> Merge Replication of course.
>
[quoted text clipped - 21 lines]
>> Thanks,
>> Brian

Reply to this Message

Replicate Data Between SQL 2005

Free Magazines