Post reply

Subscriber has existing data

  • May 18, 2010 at 5:05 am

    #94904

    Hi guys,

    Objective

    Push records from Web database server to back office database server.

    Constraint

    Both databases have existing records that I want to keep, only need to see web records locally.

    Schema's are not identical - web server does not have need for as many tables as local server - but these tables are not replicated.

    I have set up transactional (publisher -> subscriber) in test and all was ok, unfortunately when applied to live I lost all my live data (on replicated articles).

    Fortunately was able to restore, so now I have removed the subscription.

    Previously had bidirectional merge replication but as data increased line speed was insufficient. Perhaps there is some remaining old replication settings making things go amiss.

    Thanks for any input.

    Dave

  • May 18, 2010 at 4:10 pm

    #1169140

    What do you mean as the data increased the line communication become insufficient? As the database grew, or as the amount of data you were trying to push across at one grew? I would suggest setting up Merge replication again and telling it during the setup wizard that the subscriber has existing data so it does not initialize the database. For your communication needs you can change the settings in the merge agent of how many commands to send at once.

    Joie Andrew
    "Since 1982"

  • May 19, 2010 at 1:39 am

    #1169262

    Thanks but the bi-directional merge is no longer a business requirement.

    Have eventually discovered that by clicking "default article properties", the option "keep the existing table unchanged" is the option I need.

    Feel rather silly for not finding this earlier...

Viewing 3 posts - 1 through 2 (of 2 total)

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