Zabach, Elke wrote:
Kerv wrote:


Dear SAP DB community,

I have 3 locations (L1, L2, L3) with no permanent data link (I use dial up communication if I need to communicate with them). My application run in all these locations and at every night I must syncronize the databases from L2 and L3 with L1 in these way:
-some data is maintained(inserted, updated and deleted) ONLY at L1 and this modifications must be delivered to L2 and L3 (e.g partners, articles, prices)
-the rest of the data can be operated at every locations (e.g. invoices) but must be consolidated to L1.


What is the best way to do this with SAP DB?



Use triggers for those tables which have to be synchronized, fill
in some sync-tables which during synchronization are read
and the data in them used for building insert/update/delete-statements
for the other locations.

Elke
SAP Labs Berlin

Thanks Elke.


So, I need to code My own replication "utility".

Regards,
        Kerv


_______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general

Reply via email to