How to migrate data from sqlite3 to Heroku Postres?

Question

Heroku

I have a db.sqlite3 db that I want to migrate to a heroku db. According to the heroku documentation, I do this with the command:

heroku pg:push db.sqlite3 HEROKU_POSTGRESQL_MAGENTA --app sushi

After that, it asks me in the console for the password from the db.sqlite3 database, which is located on my PC. The question is, how can I find out this password and where did it come from, if I didn’t even set it?

Answer 1

The command pg:pushis not designed to import from Sqlite, but only from a locally running Postgresql, for which it asks for a username and password.
To migrate from Sqlite to Postgresql, you need to use other tools.