db-dump great tool
Hi, recently i discover a great tool for migrate databases from different database servers.
It's called db-dump and it has been very useful to my work, because i am a database maniac all my projects have to work without any error or warnings in oracle, mssql, mysql, postgresSQL and sqllite, i was losing lot's of time to populate all databases with the same thing, with this tool i just need to change the settings.py file and that's it, i can transport all my databases.
You can download it here: http://code.google.com/p/db-dump/ or http://www.djangosnippets.org/snippets/14/
And it's opensource.
how to use it:
db_dump.py [options] action [applist]:
action: dump load
Options:
-h, --help : Show this help message and exit
--settings=SETTINGS : Python path to settings module, e.g. "myproject.settings.main". If this isn't provided, the DJANGO_SETTINGS_MODULE environment variable will be used.
-d DATADIR, --dir=DATADIR : Output/Input directory.
-v, --verbose : Verbose mode
-s, --stdout : Output the data to stdout
-r, --remain : Remain the records of the tables, default will delete all the records. Only used for loading.
-e, --errorquit : If there are errors occured, then exit the program.
Before i finish we have to thank to the author, limodou
Best regards to all, and i hope that you like it.
