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_A

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

Aug 2, 2023 at 8:21amWeb
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 threadTimely_Jellyfish_2077Aug 2, 2023

DB-CONNECTION-ERROR: Failed to connect to pgsql at “localhost” (port 5432) as user “postgres”: The value NIL is not of type STRING when binding STRING An unhandled error condition has been signalled: Failed to connect to pgsql at “localhost” (port 5432) as user “postgres”: The value NIL is not of type STRING when binding STRING

What I am doing here?

Failed to connect to pgsql at “localhost” (port 5432) as user “postgres”: The value NIL is not of type STRING when binding STRING

Show threadDouble_AAug 2, 2023
You need to provide a password in the connection string. pgloader.readthedocs.io/en/latest/pgloader.html?h…
Command Line — pgloader 3.6.9 documentation

Show threadTimely_Jellyfish_2077Aug 2, 2023
Thanks man. It worked
Show threadpfannkuchenAug 2, 2023
You might need to handle NULL values by explicit type casting