Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2003

    Unanswered: Replication between offices

    Hi. I work for a building company and they have about 20 sales offices spread throughout the city. We have the main server in the corp office with SQL Server 2000 and then each sales office will have will have a computer with MSDE 2000 on it. We are trying to replicate from the sales office up to the main server and then replicate that data out to all of the sales offices. Also occasionally the sales offices will be disconnected because of someone running over the line or some other reason so the offices will be connected but not all of the time. Merge Replication using a pull subscription seems the best way to go about it. But if anyone has any suggestions on another way to do this or hints that would be greatly appreciated.

  2. #2
    Join Date
    Aug 2002
    May refer to this link for more information.
    --Satya SKJ
    Microsoft SQL Server MVP

Posting Permissions

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