[ale] database conversion

[James P. Kinney III]

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!)

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. 
-- 
James P. Kinney III          \Changing the mobile computing world/
CEO & Director of Engineering \          one Linux user         /
Local Net Solutions,LLC        \           at a time.          /
770-493-8244                    \.___________________________./
http://www.localnetsolutions.com

GPG ID: 829C6CA7 James P. Kinney III (M.S. Physics)
<jkinney at localnetsolutions.com>
Fingerprint = 3C9E 6366 54FC A3FE BA4D 0659 6190 ADC3 829C 6CA7
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: This is a digitally signed message part