Re: [GENERAL] Database design: Data synchronization

2008-06-19 Thread Decibel!
On Jun 18, 2008, at 7:07 AM, David wrote: - Many foreign keys weren't enforced - Some fields needed special treatment (eg: should be unique, or behave like a foreign key ref, even if db schema doesn't specify it. In other cases they need to be updated during the migration). - Most auto-incremen

[GENERAL] Database design: Data synchronization

2008-06-18 Thread David
Hi list. 2 cases I'm interested in: 1) Migrating data from one database to another 2) Distributing data over many databases, and later merging In what ways can you design tables to easier facilitate the above cases? I am aware of multi-master replication software, as described here: http://en