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 _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
