Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2002
    Posts
    8

    Unanswered: Replication Problem

    We have same database at our Head office and at factory. we use merge replication over internet to synchronize both databases.

    The problem is that the internet connection is not good and keep on breaking. Is there some other way to replicate database.

  2. #2
    Join Date
    Oct 2002
    Posts
    1

    Re: Replication Problem

    Originally posted by saleem
    We have same database at our Head office and at factory. we use merge replication over internet to synchronize both databases.

    The problem is that the internet connection is not good and keep on breaking. Is there some other way to replicate database.
    Have a look at Agent profiles, for the merge agent. Perhaps change the profile to a "Slow Link Agent Profile."

    Tim

  3. #3
    Join Date
    Jun 2002
    Location
    Belgium
    Posts
    43

    Re: Replication Problem

    Dear colleague

    You can solve (partially) the problem by augmenting the timeout factor in the merge-agent.
    Simply open SQL manager, and look into the database you need, under the folder replication manager, and go to the Agents folder. Open the Merge agents subfolder and look for the one which replicates the table(s) you need.

    Right click on the merge agent of your choice and select properties.
    Go to the Tab Steps and select the step Run Agent. click on Edit and you'll see the merge instruction appear. At the end of this instruction you can insert a timeout factor: -QueryTimeOut 120 (120 seconds).
    Save the edited entry and try it out. Try also several timeout factors ( in seconds) for optimal performance.

    I hope this helps you!
    Greetings,
    Vincent

    Originally posted by saleem
    We have same database at our Head office and at factory. we use merge replication over internet to synchronize both databases.

    The problem is that the internet connection is not good and keep on breaking. Is there some other way to replicate database.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •