DMigrate is a simple tool which lets you migrate Django databases easily. With DMigrate:
- You don't have to use any SQL.
- You don't need to learn any command for changing database structure.
- You can do whatever transformations you like.
- You can do the migration as many times as you like, until you get it right, without fear of data loss.
There's one drawback: DMigrate is not as efficient as other migration tools, which means that it's probably suitable only for small to medium sites.
The idea is simple: DMigrate writes for you a script which takes all the data from the current database and copies it to a newly created database. You then edit the script to make any transformations you like on your data, and then run the script. If you're not satisfied with the result, you re-edit the script, and run it again. When you are satisfied, make your website use your newly created database. That's all!
DMigrate can also be used to migrate your data from one database engine to another.
For examples of using DMigrate, look here.