SQLite to PostgreSQL converter implements quite simple merging algorithm. If both source and destination tables have primary key or an unique index, the program inserts into PostgreSQL or Heroku database only those records whose key/index value does not exist in the destination table. Otherwise, the application appends contents of the entire SQLite table. If structures of SQLite and PostgreSQL are not equal, the program transforms each record of the source table so that it conforms to the destination table structure.
Have any questions? Contact us