semvec/pypi-packages huggingface dataset:
sqlacrossover 0.3.2
SQLAlchemy-based cross-database migration tool
License: Apache-2
Keywords: sqlalchemy,database migration,data migration

sqlacrossover
=============

Cross-database migration tool based on SQLAlchemy

Features:

* Copy data and schema between SQLAlchemy-supported databases
* Table ordering - taking the foreign keys dependencies in consideration
* Data processing in batches
* Wrap the process in transaction to get consistent results
* Dump schema and data to SQL file

Installation
------------

.. code-block:: bash

    pip install sqlacrossover[MySQL,PostgreSQL]

Example
-------

.. code-block:: bash

    sqlacrossover 'mysql+pymysql:///sourcedatabase?charset=utf8' postgresql:///targetdatabase

TODO
----

* Write documentation

* Implement options:

  * ``--no-data``
  * ``--tables``
  * ``--exclude-tables``
  * ``--truncate-non-empty``
  * ``--skip-non-empty``

* Implement efficient driver-depenedent insert methods

  * PostgreSQL ``COPY FROM`` / ``COPY TO``
  * MySQL ``LOAD DATA LOCAL INFILE``

* Write tests, configure travis.ci

Contibuting
-----------

Pull requests implementing new features, adding tests, docs and fixing bugs are welcome.

Feel free to open an issue with any feedback or ideas, also.