Thread: Synchronization of records in multiple databases

Synchronization of records in multiple databases

From
norman
Date:
Hello,
I have a single database running an on-line application, we would like to take this and setup an intranet version to run at a exhibition/event where users will be able to add/modify records. In the mean time our 'live' system will still be running. So my question is whether it is possible to merge/sync the changed records back into the master database and also update the child-database with any changes?
What are the issues that I need to consider and can this be done with multiple of-line instances?
Thanks
Norman


Support the World Aids Awareness campaign this month with Yahoo! for Good

pgsql 7.3.2 updating FOREIGN KEYS after transaction

From
Tjibbe
Date:
Does pgsql 7.3.2 checking after the transaction of al the foreign keys are still oke?  And not direct after a insert or update within the transaction.
 
Tjibbe
 
 


Ontdek Windows Live, een nieuwe Windows ervaring. Een gratis upgrade. Download nu.