[CLUG-tech] db / app migration
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.
More information about the Clug-tech