dbTalk Databases Forums  

Replicate Data Between SQL 2005

microsoft.public.sqlserver.clients microsoft.public.sqlserver.clients


Discuss Replicate Data Between SQL 2005 in the microsoft.public.sqlserver.clients forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Brian P. Hammer
 
Posts: n/a

Default Replicate Data Between SQL 2005 - 12-08-2007 , 07:25 PM






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 With Quote
  #2  
Old   
Ekrem Önsoy
 
Posts: n/a

Default Re: Replicate Data Between SQL 2005 - 12-09-2007 , 03:28 AM






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

Quote:
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 With Quote
  #3  
Old   
Brian P. Hammer
 
Posts: n/a

Default Re: Replicate Data Between SQL 2005 - 12-09-2007 , 11:14 PM



Thank you Ekrem.


"Ekrem Önsoy" <ekrem (AT) btegitim (DOT) com> wrote

Quote:
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 (AT) TK2MSFTNGP02 (DOT) 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







Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.