Cloning SQLlite db into PostgreSQL

[Alan Etkin]

I've modified an original script by Mariano to migrate data from sqlite to pg. This tool can be very useful when users want to deploy a db with postgres but have been usign the default SQLite connection for development.

Migrating data from a sqlite is becoming a common issue https://groups.google.com/forum/?fromgroups=#!topic/web2py/B3eLkJaQvEg

The reason to choose using this over using the csv import/export builtin features is that it preserves id numbers (currently, import_from_csv does not preserve ids for postgres, AFAIK). It needs more tests and perhaps using bulk insert instead of individual record insertion, but it worked with a small example db and should also work in general.

I attached the module in case anybody wants to try it. See the module docstring for instructions.

[Karthick GRK]

Though the migrate method  executed successfully I can only see empty postgres database.