Synchronizing distant databases

["Mathieu Parent" <mathieu_parent@hotmail.com>]

Hi everyone,

I'm currently working on a little project for a business.  I would need to 
synchronize a few tables (maybe even only a few fields in those tables) from 
2 distant databases.  One database will be at a web host, and the other one 
will be local.  For the databases, I was planning on using either postgreSQL 
or mySQL, or maybe a mix of both.  (Personally I'd rather use postgreSQL, 
but most web host only advertise mySQL)

We taught we could mirror the entire database every so often.  But that 
would be a big waste of ressources since only certain fields of a few 
records would need to be updated.

Does anyone have experience synchronizing databases (or parts of databases)?


Jd

_________________________________________________________________
Keep up with high-tech trends here at "Hook'd on Technology." 
http://special.msn.com/msnbc/hookedontech.armx