[ale] database conversion

[kaboom at gatech.edu (Chris Ricker)]

On Tue, 8 Feb 2005, James P. Kinney III wrote:

> I am looking at a project that will involve migration of a MySql
> database to PostgreSQL. The original db has numerous design errors that
> are beginning to cause problems. The move to PostgreSQL will add the
> transaction capabilities that would have prevented the current problem
> causing the project (seqential transaction ID's would have been a great
> start!)

you can get transactions in mysql w/o migrating to PostgreSQL - check 
the InnoDB stuff....
 
> As this will need to be a parallel pair of db's for a while to run final
> tests, I'm looking at pitfalls and processes others have used to migrate
> from one 24x7 db to another seamlessly. I'm also looking for pointers on
> getting identical data simultaneously into two seperate db's without
> having to rewrite the entire app first.=20

sqlrelay <http://sqlrelay.sourceforge.net/> might be usable for the 
write mirroring across 2 different dbs? I think the author may even be on 
this list

later,
chris