Re: I have issue. I want to migrate database from sqlite3 to postgresql. With a table have 10M records. I need a solution for issue. Maybe help me?

cant be done directly from sqlite to postgres as there are differences between them ...

safer to generate an intermediate file like a CSV or Excel file from the sqlite database ..
create the new postgres database with proper column types ..

make a python script to loop through each row in CSV or Excel file and populate each row in new postgres database

On Wed, Mar 25, 2020 at 6:43 PM Thắng IT <lanhdaobt@gmail.com> wrote:

solution

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/067ffc03-bb03-4a52-8921-21e818a5b41f%40googlegroups.com.

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAHV4E-fWUFVzsTC7VjWZoRq%2B_-NWyop1sa_RA%2BJuGia_mfP5GA%40mail.gmail.com.