Replicate Data Between SQL 2005

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
Sun Dec 09 01:28:54 PST 2007

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

--
Ekrem Önsoy



"Brian P. Hammer" <Nospam> wrote in message
news:eqztjJgOIHA.4948@TK2MSFTNGP02.phx.gbl...
> 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
>
>
>

Brian
Sun Dec 09 21:14:19 PST 2007

Thank you Ekrem.


"Ekrem Önsoy" <ekrem@btegitim.com> wrote in message
news:9C21E52D-0CCB-43FF-803D-CE3175769F5E@microsoft.com...
> 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
>
> --
> Ekrem Önsoy
>
>
>
> "Brian P. Hammer" <Nospam> wrote in message
> news:eqztjJgOIHA.4948@TK2MSFTNGP02.phx.gbl...
>> 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
>>
>>
>>
>