migratedata 0.1

migratedata project allows you to write a simple XML file to define how to copy data from one database to another, and perform very simple transformations on the way.
Currently, it is immediately able to help you migrate a PostNuke web site to a WordPress one, but to perform any other transformations you will need to create your own XML spec file (which is reasonably simple).
Migrating from PostNuke to WordPress
Download the migratedata tarball from the Download page, and unzip it somewhere.
Copy the file database_details_sample.xml and name it database_details.xml.
Edit the database_details.xml file to contain the hosts, usernames, passwords and database names of your databases.
If you have remote access to the MySQL databases for both your source and your target databases, the process is relatively simple. Open a terminal and cd into the directory containing migratedata.py, and run this command:
./migratedata.py database_details.xml postnuke0.75_to_wordpress2.2.xml
If you dont have remote access to the target database, run this command instead:
./migratedata.py --dump-insert database_details.xml postnuke0.75_to_wordpress2.2.xml > insert.sql
and execute the insert.sql script on the database server of your target database (probably through your hosting providers web interface).
If you cant run queries remotely against your source database either, do this:
./migratedata.py --dump-select database_details.xml postnuke0.75_to_wordpress2.2.xml > select.sql
This will create the file select.sql which you need to run on your source database (probably through your hosting providers web interface). The output of running this query will be some more SQL, which you will need to copy and run on your target database, again probably through your new hosting providers web interface.
Enhancements:
- PostNuke to WordPress migration support was implemented.