Replication - will this work?

I have a system with two SQL 2K servers. The two servers are connected by
dial up 56K lines which will be used to update the system. The requirement
is that the first server S1 database match the second server S2 database on
a daily basis. S1 will be heavily updated but S2 will mostly have few
changes.
I was thinking replication via the SQL server would be the best way to
implement this but was wondering if it was possible.
One of my concerns is that since the two servers are not connected all the
time will they update correctly when they are connected.
I am also concerned about how the system will handle records that are
updated on both system and then merged.
Also can the replication occur while the server is receiving new data?
Any comments, suggestion, or links would be appreciated.
Regards,
John
John,
Merge replication should do what you need, it is designed for occasionally
disconnected sites. Check it in Books Online whether this is what you need.
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
"John J. Hughes II" <no@.invalid.com> wrote in message
news:ueBIwtHvEHA.1296@.TK2MSFTNGP10.phx.gbl...
> I have a system with two SQL 2K servers. The two servers are connected by
> dial up 56K lines which will be used to update the system. The
requirement
> is that the first server S1 database match the second server S2 database
on
> a daily basis. S1 will be heavily updated but S2 will mostly have few
> changes.
> I was thinking replication via the SQL server would be the best way to
> implement this but was wondering if it was possible.
> One of my concerns is that since the two servers are not connected all the
> time will they update correctly when they are connected.
> I am also concerned about how the system will handle records that are
> updated on both system and then merged.
> Also can the replication occur while the server is receiving new data?
> Any comments, suggestion, or links would be appreciated.
> Regards,
> John
>
|||Hi John,
From your descriptions, I understood that you would like to make
replication between two SQL Servers in Internet via modem. Have I
understood you? Correct me if I was wrong.
Based on my scope, first of all, you must select a way to setup replication
via Internet. Ways for users to connect to replicated data over the
Internet using Microsoft SQL Server 2000 include:
- Using Virtual Private Networks (VPNs), such as those based on the
Microsoft Windows NT? Server version 4.0 operating system, the Microsoft
Windows? 2000 Server operating system, or a third party provider.
- Integrating replication with Microsoft Proxy Server.
- Using TCP/IP and File Transfer Protocol (FTP) to transfer the initial
snapshot of data over the Internet.
See Topic "Web-Based Applications" in Books Online for more detailed
information about this and I would perfer using VPN. See the following
documents for how to create VPN on the different OS
How To Install and Configure a Virtual Private Network Server in Windows
Server 2003
http://support.microsoft.com/default...b;en-us;323441
Configure a Win2K VPN
http://msdn.microsoft.com/library/de...us/dnw2kmag00/
html/VPN.asp
How to Install Virtual Private Networking in Windows Me/98
http://support.microsoft.com/default...b;en-us;288779
Secondly, it was not necessary for you to connect to the Internet all the
time. You could schedule the synchronization at the same time per day with
a job, however, you will have to dial-up yourself that time before setup
the replication.
Thank you for your patience and corperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
|||The system will not be interfacing with the Internet at all. System 1 will
connect to system 2 using a 56K lease line or ISDN line. The only problem
is the connection is not permanent and must be initiated before update.
Regards,
John
""Michael Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in message
news:q0rLa$LvEHA.3696@.cpmsftngxa10.phx.gbl...
> Hi John,
> From your descriptions, I understood that you would like to make
> replication between two SQL Servers in Internet via modem. Have I
> understood you? Correct me if I was wrong.
> Based on my scope, first of all, you must select a way to setup
> replication
> via Internet. Ways for users to connect to replicated data over the
> Internet using Microsoft SQL Server 2000 include:
> - Using Virtual Private Networks (VPNs), such as those based on the
> Microsoft Windows NT? Server version 4.0 operating system, the Microsoft
> Windows? 2000 Server operating system, or a third party provider.
> - Integrating replication with Microsoft Proxy Server.
> - Using TCP/IP and File Transfer Protocol (FTP) to transfer the initial
> snapshot of data over the Internet.
> See Topic "Web-Based Applications" in Books Online for more detailed
> information about this and I would perfer using VPN. See the following
> documents for how to create VPN on the different OS
> How To Install and Configure a Virtual Private Network Server in Windows
> Server 2003
> http://support.microsoft.com/default...b;en-us;323441
> Configure a Win2K VPN
> http://msdn.microsoft.com/library/de...us/dnw2kmag00/
> html/VPN.asp
> How to Install Virtual Private Networking in Windows Me/98
> http://support.microsoft.com/default...b;en-us;288779
> Secondly, it was not necessary for you to connect to the Internet all the
> time. You could schedule the synchronization at the same time per day with
> a job, however, you will have to dial-up yourself that time before setup
> the replication.
> Thank you for your patience and corperation. If you have any questions or
> concerns, don't hesitate to let me know. We are here to be of assistance!
>
> Sincerely yours,
> Michael Cheng
> Online Partner Support Specialist
> Partner Support Group
> Microsoft Global Technical Support Center
> Get Secure! - http://www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>
>
|||Hi John,
Sorry for my misunderstanding.
If so, as MVP Dejan Sarka and I have said, it's OK for replication doing so
when the connection are not permanent. For example, you have scheduled the
run the SQL Agent at 6:00 PM everyday, you will have to dial-up before 6:00
PM everyday and make sure it was connect before SQL Agent doing this.
(Unfortuantely, based on my scope, I am afraid SQL Server do not have the
funcaitonality to dial-up automatically)
Thank you for your patience and corperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
|||Thanks for the response.
Regards,
John