Postgresql – Tools to migrate from SQLite to PostgreSQL

The WAL file records all changes to the database since the last checkpoint.

(Automatic) checkpoints cannot run when the database is locked, so ensure that there is no other connection with an active transaction.

The documentation says:

By default, the auxiliary write ahead log and shared memory files used for transaction control are automatically deleted when the latest connection to the database closes.

So ensure that all database connections are closed at some time.

(If you have disabled deleting WAL files with SQLITE_FCNTL_PERSIST_WAL, you have to set PRAGMA journal_size_limit to a nonnegative value to truncate the WAL file to zero bytes in that situation.)

You can use ssh to securely forward the MySQL port remotely. For example, if you execute:

ssh -L 3307:localhost:3306 <ssh-user>@<remote-server>

You will be able to connect to the local port 3307 as if MySQL was running there. All connection information will be tunneled though ssh, so it will be sent securely. That way you can connect using Workbench using localhost:3307

I cannot say if Workbench would be the best tool for the migration, though. Here you have some pointers and tools: http://database-scalability.blogspot.com.es/2014/04/porting-from-oracle-to-mysql.html