[Answer]-Moving data between SQLite and PostgreSQL using Django extensions "dumpscript"

1👍

Got it! you need to put the generated script in a folder “scripts” and just run (mezz4)tom@tom-Satellite-A105:~/reschool/careers5$ python manage.py runscript blogpostexp
I had a few syntax errors relating to tzinfo= I deleted those and the content was imported! There were other issues about missing categories, but they did not stop the import. I suppose if I had generated off the app instead of the model I could have gotten that also but probably with other issues..

All in all this seems like the most straightforward way to move SQLLITE to postgres in Django if there is any issue with the regular dumpdata loaddata methods.

Leave a comment