Replicate Data Between SQL 2005

[Brian P. Hammer]

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

 

[Ekrem Önsoy]

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

 

[Brian P. Hammer]

Thank you Ekrem.

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