Tools to migrate from SQLite to PostgreSQL I need to continuously migrate from SQLite to PostgreSQL. By continuously, I mean that I will reimport the SQLite database into PostgreSQL every day. It would be nice if I could make changes to the tables in SQLite as I please without having to manually make any changes to the PostgreSQL database. I will run the migration from Python, but it could be any external tool, which can be controlled from command line. The tool needs to be available for Linux, and it would be nice if it also ran on Windows.
Have you looked into using ETL tools? They are external and I believe pentaho runs on both windows and linux and its free. 
pentaho's site