[CLUG-tech] db / app migration

Roland Giesler roland at giesler.za.net
Thu Feb 16 12:58:07 SAST 2006


Brendon Gleeson wrote:
> I want to move all the data from our current MySQL db to Postgres.
> I am busy developing a new app with RubyOnRails. The new
> database table structures are quite different because of all
> the "normalising(?)" ive done..
> anyways, is their any sort of tool I can use to help me
> restructure the old data or something? (other than complex
> SQL queries)

Have look at Aqua Datastudio and Druid.  Both are stable, unlike a number of
commercial trials that I played with. I'm not sure if Aqua is available for
all platforms though.  Druid is good and has powerful tools included.

HTH 

Roland




More information about the Clug-tech mailing list