How to Migrate Data from SQLite to PostgreSQL in Django

[@SpRaT92]

you're a lifesaver! thank you so much!

[@CodeWithClinton]

@@SpRaT92 You are welcome.

[@TDD_SA]

Thanks man, that was very simple and straightforward..I hope to see videos like this in future 🔮

[@CodeWithClinton]

Sure, more videos to come. Thank you.

[@adrianwafula8667]

This is a good video, although my data.json didnt load i learnt smth! suscribed for sure

[@CodeWithClinton]

Thank you, what error did you face?

[@samitpaudel7886]

Thanks works perfectly fine!

[@CodeWithClinton]

You're welcome.

[@mystoryuganda]

Thank you for sharing, am learning something from your channel

[@CodeWithClinton]

You are welcome.

[@gencaypolat8901]

Thank you man!

[@CodeWithClinton]

You are welcome.

[@infohub3709]

Thanks for sharing bro. But please, I encountered this (UnicodeDecodeError: 'utf-8' codec can't decode byte 0xff in position 0: invalid start byte) error when I ran the code "python manage.py loaddata data.json". Anyway around this please?

[@CodeWithClinton]

Make sure you are working on 'utf-8'

[@infohub3709]

@@CodeWithClinton that's the problem. Working in UTF-8 gave me the error. But changing to UTF-16 solved the problem for me.

[@CodeWithClinton]

@@infohub3709 Wow, 'utf-16' caused me some errors. 😅😅. Thank God your code is working.

[@robinsonbrz]

@@infohub3709 I had the same problem, even using UTF-8 importing and exporting. I solve the problem opening the data.json on notepad and saving the file as UTF8. That way loaddata worked just fine. All the tutorial worked perfect. thanks to @Code With Clinton .

[@frameff9073]

Thank you

[@CodeWithClinton]

You're welcome. 😀

[@JoseAntonio-sn6sf]

how to migrate from postgresql to sqlite3?

[@CodeWithClinton]

It should be same process.