Merge two magnetico databases - Forked from
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
Jeremy Kescher 4682413aef
Merge remote-tracking branch 'origin/kescher/fix-typo'
5 months ago
LICENSE Add LICENSE 2 years ago Support merging from postgresql into sqlite 5 months ago Fix typo in 5 months ago
requirements-pg.txt use pgcopy 6 months ago
requirements.txt add requirements 2 years ago

Merge magnetico databases

Very simple script to merge databases created by magnetico >=0.8

It supports merging SQLite database into SQLite or PostgreSQL, or merging PostgreSQL into SQLite.


  --fast  Try to go faster, by deleting indices and constraints while
          importing. PostgreSQL only. This can be really slower if your
          databases overlapped a lot.

  --help  Show this message and exit.

The MERGED_DB will be merged into MAIN_DB.

It requires python >= 3.6 and click

If you need to import into or load from PostgreSQL, you need to have psycopg2. Having pgcopy is faster when a lot of rows are in the files table.

Have fun.