Re: [GENERAL] Synchronize tables question....

2007-02-22 Thread Michael Raven
Jerry LeVan wrote: > > > Is there an elegant way I can merge/update the two tables so that > they will contain the same information ( with no duplicates or > omissions)? > Well comparing algorithm is quite complex and depend on data. You can use third patry software like http://www.sqlmana

Re: [GENERAL] Synchronize tables question....

2007-02-19 Thread Jerry LeVan
On Feb 19, 2007, at 9:05 AM, Richard Huxton wrote: Don't forget to CC: the list Jerry LeVan wrote: Is there an elegant way I can merge/update the two tables so that they will contain the same information ( with no duplicates or omissions)? It sounds like you'll want some form of replicati

Re: [GENERAL] Synchronize tables question....

2007-02-19 Thread Richard Huxton
Don't forget to CC: the list Jerry LeVan wrote: Is there an elegant way I can merge/update the two tables so that they will contain the same information ( with no duplicates or omissions)? It sounds like you'll want some form of replication, but whether single-master or multi-master no-one