CLI tool for exporting tables or queries from any SQL database to a SQLite file
Project description
db-to-sqlite
CLI tool for exporting tables or queries from any SQL database to a SQLite file.
Usage: db-to-sqlite [OPTIONS] PATH
Load data from any database into SQLite.
https://github.com/simonw/db-to-sqlite
Options:
--version Show the version and exit.
--connection TEXT SQLAlchemy connection string [required]
--all Detect and copy all tables
--table TEXT Name of table to save the results (and copy)
--skip TEXT When using --all skip these tables
--sql TEXT Optional SQL query to run
--pk TEXT Optional column to use as a primary key
--help Show this message and exit.
For example, to save the content of the blog_entry
table from a PostgreSQL database to a local file called blog.db
you could do this:
db-to-sqlite blog.db \
--connection="postgresql://localhost/myblog" \
--table=blog_entry
You can also save the data from all of your tables, effectively creating a SQLite copy of your entire database. Any foreign key relationships will be detected and added to the SQLite database. For example:
db-to-sqlite blog.db \
--connection="postgresql://localhost/myblog" \
--all
When running --all
you can specify tables to skip using --skip
:
db-to-sqlite blog.db \
--connection="postgresql://localhost/myblog" \
--all \
--skip=django_migrations
If you want to save the results of a custom SQL query, do this:
db-to-sqlite output.db \
--connection="postgresql://localhost/myblog" \
--table=query_results \
--sql="select id, title, created from blog_entry" \
--pk=id
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distributions
No source distribution files available for this release.See tutorial on generating distribution archives.
Built Distribution
Close
Hashes for db_to_sqlite-0.6-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | d1b87e750c0a5b8a3d94f4149f051ac2b089d7f7cd79c40f298248e941a5abeb |
|
MD5 | 77f24b18e202ab42b43c4e5fbfe11352 |
|
BLAKE2b-256 | 130630224168652b9feee82da476c3a611db930145246968496128c1afd72c54 |