Timely_Jellyfish_2077Aug 2, 2023

Best way to convert sqlite database to postgresql database?

https://programming.dev/post/1187645

Best way to convert sqlite database to postgresql database? - programming.dev

I have been trying to import this [https://send.whateveritworks.org/download/eafb8f99d35d4dfb/#tVhOjVyQqjVpRTjEk1SbGw] sqlite database into mysql or postgresql database. But had been failing. Can anyone help me with this?

Show threadDouble_AAug 2, 2023

Maybe this? pgloader.readthedocs.io/en/latest/…/sqlite.html

Also what have you tried, and how did it fail?

SQLite to Postgres — pgloader 3.6.9 documentation

Show threadTimely_Jellyfish_2077Aug 2, 2023
I have tried it. Getting this error: The value NIL is not of type STRING when binding STRING
Show threadpfannkuchen
You might need to handle NULL values by explicit type casting
Aug 2, 2023 at 8:32amWeb