Copy contents of a SQL database to another
Project description
dbcopy
Copy tables from a source database to a destination database, with both databases using different SQL engines. This can be used, for example, to copy the contents from a MySQL or MSSQL database to Postgres. While less civilized, the opposite operation might also work :-P
Installation
Please install dbcopy
using the Python pip command:
pip install -U dbcopy
Depending on the database backend, you may need to also install a connection adapter. Recommended adapters can be installed as extras with the package:
pip install -U dbcopy[postgres,mssql]
Usage
You must always specify a source database connection URI and a target database URI:
dbcopy --drop postgresql://localhost/demo sqlite:///demo.sqlite3
There are additional parameters to skip individual tables or normalize tables and column names to the common snake_case form. For these options, please see:
dbcopy --help
Project details
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Hashes for dbcopy-0.1.6-py2.py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 9a3ab89f02deb786cd499b0f47f308cc56967b8e4b0b138f149b7bb7f5d39f8f |
|
MD5 | 5465c76d2da49226ff8f80d72a0d3159 |
|
BLAKE2b-256 | 71f712fb8bcdfc6b88c0744527c4476e84bfd47c0cf496e4328f061fea934704 |