migratedata

migratedata project allows you to write a simple XML file to define how to copy data from one database to another.
Download

migratedata Ranking & Summary

Advertisement

  • Rating:
  • License:
  • GPL
  • Price:
  • FREE
  • Publisher Name:
  • Andy Balaam
  • Publisher web site:

migratedata Tags


migratedata Description

migratedata project allows you to write a simple XML file to define how to copy data from one database to another. 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 WordPressDownload 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.xmlIf you don't 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.sqland execute the insert.sql script on the database server of your target database (probably through your hosting provider's web interface).If you can't 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 provider's 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 provider's web interface.What's New in This Release:· PostNuke to WordPress migration support was implemented.


migratedata Related Software