Transferring data from sqlite3 db to heroku postgres db | Django | Page 1

autumn umbra Jul 11, 2024, 9:21 PM

#

Hello I have a django project with a sqlite3 database and the project is hosted on heroku. I wanted to tranfer my data in he sqlite3 to the heroku postgres database. I was wondering how I can do this.

dark hill Jul 11, 2024, 9:23 PM

#

I would look at dumpdata and loaddata https://docs.djangoproject.com/en/5.0/ref/django-admin/#dumpdata or if you need something more controllable, django-import-export

misty charm Jul 12, 2024, 11:32 AM

#

Can dumpdata / loaddata be used for a backup mechanism in production , or is it just a development tool ?

dark hill Jul 12, 2024, 11:34 AM

#

I would consider it more dev/one off transfers etc

#

Most databases support their own actual backup mechanisms

#Transferring data from sqlite3 db to heroku postgres db