db-to-sqlite
db-to-sqlite copied to clipboard
simonw
CLI tool for exporting tables or queries from any SQL database to a SQLite file
Like this: $ db-to-sqlite mysql://localhost/blah blah.db \ --sql "select id, name from categories" --output="cats" \ --sql "select id, name from authors" --output="authors"
Is it possible to export multiple postgres schemas? Ideally I would like to provide a comma separate list of schemas... ```bash db-to-sqlite --all --progress --postgres-schema schema1,schema2,schema3 CONNECTION PATH ``` Or...
In my original DB, all datetime fields are in UTC. It should be possible (using a flag perhaps?) to convert the datetimes to be without timezone in sqlite3? Right now...
@simonw documentation update to include examples for MS SQL There may be a better way to show it and explain how it should be done, but I'm at a loss....
I am trying to export a few schemas from my postgres database to SQLite as below: `/home/admin/.local/bin/db-to-sqlite "postgresql://postgres:[email protected]:5432/configuration" cplabor.db --all --postgres-schema dbd_cp_labor` This particular schema has views , materialized views...
I'm running a SQLite database in memory, with URL `sqlite://`. While the SQLite database is still open, invoking the following code: ```bash db-to-sqlite sqlite:// database_copy.db --all --no-index-fks ``` ... produces...
The database I'm working with has several columns set as number in Oracle. This utility creates the fields as integer in sqlite. It works if I remove the two fields...
Added option for selecting tables to copy by a (regex) pattern. Closes #40.
Besides just `--all` to select all tables, `--table` to select specific table, or `--sql` to run a custom SQL query, it would be nice to be able to select table...
After converting a db from Postgres (15) to Sqlite, I noticed that the Postgres JSONB columns were turned into Sqlite TEXT columns. Wouldn't it make more sense to turn them...
