SQL Server Performance

Transaction replication over VPN

Discussion in 'SQL Server 2005 Replication' started by SQLWorld, May 27, 2009.

  1. SQLWorld New Member

    Hi,
    I want to know what are the parameters I need to concentrate while configuring Transaction replication over VPN? What is the performanace if there is huge data to be transfered to the subscription. I am planning for PULL subscription. Distributor is configured to be local to Publisher.
  2. ghemant Moderator

    Hi,
    I would suggest you to go through the articles http://msdn.microsoft.com/en-us/library/ms151172(SQL.90).aspx ,
    http://msdn.microsoft.com/en-us/library/ms152569(SQL.90).aspx and http://www.sql-server-performance.com/articles/dba/replication_across_internet_p1.aspx
    I have configured merge replication over internet across different domain, we had 4 mbps link and database was over 10gigs and it was running smooth.
  3. SQLWorld New Member

    Thanks for the reply. With a speed of 100 mbs will it be able pull minimum 100 mbs od data per day. Any other consideration like security, scheduling time etc?
  4. moh_hassan20 New Member

    what technology of VPN?
  5. ghemant Moderator

    [quote user="SQLWorld"]
    Thanks for the reply. With a speed of 100 mbs will it be able pull minimum 100 mbs od data per day. Any other consideration like security, scheduling time etc?
    [/quote]
    could you please elaborate, I am not getting you!

Share This Page