Post reply

Remote Merge Replication!!

  • January 18, 2007 at 5:50 am

    #193855

    hi Dear,

    I have implemented merge replication between two servers but since the data size is large and two servers connect using dial up, so transfer speed is too slow, it came to my mind to:

    1. define SERVER1 as publisher to create replication data (on snapshot default path- I mean ..\unc\SQL2005_TEMP_.._MYPUBLICATION folder that publisher creates to store replicated data in it)

    2. zip the created files in step 1 and send to SERVER2 via other devices

    3. Make subscriber of SERVER2 to merge data from local folder!! without connecting to SERVER1! maybe by creating a publisher on SERVER2 (is that possible?)

    Any idea would be appreciated

  • January 18, 2007 at 6:04 pm

    #684174

    You can restore the publisher db onto subscriber or you can copy the required tables to subscriber first when you create subscriber specify that the subscriber has schema and data option (depricated) so that you don't need to run the snapshot...

    http://www.microsoft.com/technet/prodtechnol/sql/2005/mergrepl.mspx

     

    MohammedU
    Microsoft SQL Server MVP

  • January 23, 2007 at 2:31 am

    #684862

    Thank you Mohammad for your fast reply

    I'm a bit novice in such fields; could you guide me step by step?

     

  • January 24, 2007 at 6:15 pm

    #685395

    I don't have step by step guide to give you but the following article is for sql 2000...you follow the instructions in SSMS instead of EM and check "Figure 29" in the article where you to check the radio button "No, subscriber the schema and data..."

    A Step-by-step Guide

    http://www.databasejournal.com/features/mssql/article.php/1458491

     

    MohammedU
    Microsoft SQL Server MVP

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply