Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

SQL2K Merge Replication - is ADSL connection good enough?

Posted on 2004-07-30
3
Medium Priority
?
266 Views
Last Modified: 2012-08-13
I have got to get Merge Replication up and running on two servers. One is a web server hosted by a 3rd party on a very fast backbone connection. The other is in a local office on a 2meg ADSL connection (so 256kbits upload).

The database has around 50 tables - though there are 3 large ones with 500,000 - 1,000,000 records each. Most updates happen in the local office - with no more than 5,000 record updates / day. (rough data I know but should give an idea).

I ask because I got this working fine on a leased line (256 both ways) in the past - but am having several problems now and am on my second weekend attempt to get it to work. The first error this time has been:
"The subscription to publication 'myDb' is invalid"
This happened during the first push subscription from the local box to the webserver. Ive just restarted the push.

Generally speaking would the ADSL connection be up to the task? Is it recommended / reliable enough to use ADSL for Replication?
0
Comment
Question by:niico
  • 2
3 Comments
 
LVL 34

Accepted Solution

by:
arbert earned 400 total points
ID: 11682998
I would say, based on your 5000 record estimate, the speed should be fine.  I would imagine you might experience timeouts and problems on the original setup, but after you get the push done, I wouldn't expect too many problems.

Are these servers directly connected to the internet (gasp), or are you going through some kind of tunnel or VPN?
0
 

Author Comment

by:niico
ID: 11683667
thanks

they're not in a vpn - but a firewall blocks access to the sql servers unless from a safe IP. We are also planning to introduce a VPN in the future.

actually it ended up transferring fine - my problem oroginally was that I hadnt set an alias name for the server (was using an IP).

0
 
LVL 34

Expert Comment

by:arbert
ID: 11684814
Glad you got it working...Nice to see someone is not just putting their server directly on the net as well :)`
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.

927 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question