From: DavidC on
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