Database migration // help

[l2u]

Hello,

I want to migrate my old database structure to a new one.

The structure of the database has quite few changes like new column names, additional columns, etc. and beside that I added some other stuff like nested sets which means I should write some values with records copied to new database structure. The code is written in php.

Is there any good tool to make my life easier when dealing with this stuff?

Doing it by hand would be a pain.

Thanks for help

[r937]

Is there any good tool to make my life easier when dealing with this stuff?

i've never seen one, although i don't doubt that they exist, and they probably have very hefty price tags

Doing it by hand would be a pain.

no it wouldn't

all you have to do is write the correct INSERT statements using the SELECT option