{ "info": { "author": "OCCRP", "author_email": "", "bugtrack_url": null, "classifiers": [], "description": "# dbcopy\n\nCopy 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\n\n## Installation\n\nPlease install `dbcopy` using the Python pip command:\n\n```bash\npip install -U dbcopy\n```\n\nDepending on the database backend, you may need to also install a connection adapter. Recommended adapters can be installed as extras with the package:\n\n```bash\npip install -U dbcopy[postgres,mssql]\n```\n\n## Usage\n\nYou must always specify a source database connection URI and a target database URI:\n\n```bash\ndbcopy --drop postgresql://localhost/demo sqlite:///demo.sqlite3\n```\n\nThere are additional parameters to skip individual tables or normalize tables and column names to the common snake_case form. For these options, please see:\n\n```bash\ndbcopy --help\n```\n\n", "description_content_type": "text/markdown", "docs_url": null, "download_url": "", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "https://github.com/pudo/dbcopy", "keywords": "", "license": "MIT", "maintainer": "", "maintainer_email": "", "name": "dbcopy", "package_url": "https://pypi.org/project/dbcopy/", "platform": null, "project_url": "https://pypi.org/project/dbcopy/", "project_urls": { "Homepage": "https://github.com/pudo/dbcopy" }, "release_url": "https://pypi.org/project/dbcopy/0.1.7/", "requires_dist": [ "sqlalchemy", "stringcase", "normality", "click", "tqdm", "pyodbc ; extra == 'mssql'", "PyMySQL ; extra == 'mysql'", "psycopg2-binary ; extra == 'postgres'", "psycopg2-binary ; extra == 'postgressql'" ], "requires_python": "", "summary": "Copy contents of a SQL database to another", "version": "0.1.7", "yanked": false, "yanked_reason": null }, "last_serial": 13685533, "releases": { "0.1.1": [ { "comment_text": "", "digests": { "md5": "ded52857f8a6faf63ac1560c7c54c7ad", "sha256": "05168949eb556d7f268cf208f73d59d043799a18f67f3a9dcb2b1ad195e978de" }, "downloads": -1, "filename": "dbcopy-0.1.1-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "ded52857f8a6faf63ac1560c7c54c7ad", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": null, "size": 5069, "upload_time": "2019-10-21T05:33:07", "upload_time_iso_8601": "2019-10-21T05:33:07.543627Z", "url": "https://files.pythonhosted.org/packages/57/7b/051489497cb68a1e96180422c4c228da735ce3031eca0905bc15081511bb/dbcopy-0.1.1-py2.py3-none-any.whl", "yanked": false, "yanked_reason": null }, { "comment_text": "", "digests": { "md5": "817f2220c288b85e7924967647949aa9", "sha256": "3d2ccee7425c219c61be65f2a7cb1323109f280af92923a92017d58aaee0b039" }, "downloads": -1, "filename": "dbcopy-0.1.1.tar.gz", "has_sig": false, "md5_digest": "817f2220c288b85e7924967647949aa9", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 3274, "upload_time": "2019-10-21T05:33:09", "upload_time_iso_8601": "2019-10-21T05:33:09.654903Z", "url": "https://files.pythonhosted.org/packages/ec/ee/851a1f09835a9c4cee9b86955e564df1474fcf50d4b0f5139fa95a7763bd/dbcopy-0.1.1.tar.gz", "yanked": false, "yanked_reason": null } ], "0.1.2": [ { "comment_text": "", "digests": { "md5": "59663baa6723b5d12f459a02167a109e", "sha256": "73921977a6f3ef900e4a169c95a0b3933c0a6313130504359b23e1cb253b0e7e" }, "downloads": -1, "filename": "dbcopy-0.1.2-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "59663baa6723b5d12f459a02167a109e", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": null, "size": 5548, "upload_time": "2019-10-21T05:44:00", "upload_time_iso_8601": "2019-10-21T05:44:00.646873Z", "url": "https://files.pythonhosted.org/packages/d2/f6/f55bd7ded5dda36d157eb56217f200c5bd984dde06aadc004a0b77d80d6b/dbcopy-0.1.2-py2.py3-none-any.whl", "yanked": false, "yanked_reason": null }, { "comment_text": "", "digests": { "md5": "f8bfb0c42aaf01ab31e493e51b349a74", "sha256": "527a35d91391081a06e58b77e0d106a5ede426ee5fddb60d3c11dd40aaf915af" }, "downloads": -1, "filename": "dbcopy-0.1.2.tar.gz", "has_sig": false, "md5_digest": "f8bfb0c42aaf01ab31e493e51b349a74", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 3763, "upload_time": "2019-10-21T05:44:01", "upload_time_iso_8601": "2019-10-21T05:44:01.892168Z", "url": "https://files.pythonhosted.org/packages/8d/f9/a29f87ba1d4234fc74055ad98e8ef7e8e664e4adff518213512879bcbbd2/dbcopy-0.1.2.tar.gz", "yanked": false, "yanked_reason": null } ], "0.1.3": [ { "comment_text": "", "digests": { "md5": "906b6d7e9b881a753c4f547872e4a8ee", "sha256": "c60db61d8fb5ec1521843995a6e85429832f20a5f36f9ef7bf711e064384cb01" }, "downloads": -1, "filename": "dbcopy-0.1.3-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "906b6d7e9b881a753c4f547872e4a8ee", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": null, "size": 5849, "upload_time": "2019-10-22T04:49:56", "upload_time_iso_8601": "2019-10-22T04:49:56.563665Z", "url": "https://files.pythonhosted.org/packages/69/41/419f1ee3ee21df69b4cd985aa8142e851f26cf5b9059948fa740e0586005/dbcopy-0.1.3-py2.py3-none-any.whl", "yanked": false, "yanked_reason": null }, { "comment_text": "", "digests": { "md5": "d3cdc25005020655fb5ef510f166d2d8", "sha256": "438f0b1a15b34a9b0be461822386a9a399678dd43454b670f8499f917e28dda8" }, "downloads": -1, "filename": "dbcopy-0.1.3.tar.gz", "has_sig": false, "md5_digest": "d3cdc25005020655fb5ef510f166d2d8", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 4070, "upload_time": "2019-10-22T04:49:58", "upload_time_iso_8601": "2019-10-22T04:49:58.175168Z", "url": "https://files.pythonhosted.org/packages/3c/02/17edc3f220a788419252f092013fb106fa22564b9d8d714e5b1e076e77b5/dbcopy-0.1.3.tar.gz", "yanked": false, "yanked_reason": null } ], "0.1.4": [ { "comment_text": "", "digests": { "md5": "bd076518aebaefb106141b0c40a665af", "sha256": "17ac93f246ce9ceb495d02c8dcbb65142e1a168dcae08acc1907a908d305f3b4" }, "downloads": -1, "filename": "dbcopy-0.1.4-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "bd076518aebaefb106141b0c40a665af", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": null, "size": 5883, "upload_time": "2019-10-22T12:49:45", "upload_time_iso_8601": "2019-10-22T12:49:45.690788Z", "url": "https://files.pythonhosted.org/packages/a0/de/96e2b5c56a194dd7016d90fba55faeb9bde9575feb192607db9e5c91a7ff/dbcopy-0.1.4-py2.py3-none-any.whl", "yanked": false, "yanked_reason": null }, { "comment_text": "", "digests": { "md5": "f62e76524c1a875326cc78cea5bdcada", "sha256": "b3b7aac5dbd65e362c2e013b572d86946f33af9bc1300e98d305c64cdd4708a9" }, "downloads": -1, "filename": "dbcopy-0.1.4.tar.gz", "has_sig": false, "md5_digest": "f62e76524c1a875326cc78cea5bdcada", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 4106, "upload_time": "2019-10-22T12:49:46", "upload_time_iso_8601": "2019-10-22T12:49:46.970108Z", "url": "https://files.pythonhosted.org/packages/d0/e5/46e060ade65a2426bb2046d6d23e9b8541ea2359cbb6c3686877c6b07244/dbcopy-0.1.4.tar.gz", "yanked": false, "yanked_reason": null } ], "0.1.5": [ { "comment_text": "", "digests": { "md5": "7416418bfc6cb8c5eb118258a9038e61", "sha256": "f5a16e74aa6004e36fd67fd5841bd1bcb566e71b65f66468ed64baf6cce72b85" }, "downloads": -1, "filename": "dbcopy-0.1.5-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "7416418bfc6cb8c5eb118258a9038e61", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": null, "size": 5963, "upload_time": "2019-10-23T08:12:30", "upload_time_iso_8601": "2019-10-23T08:12:30.518858Z", "url": "https://files.pythonhosted.org/packages/b2/24/4422bc1edc58d396029fd0f27a8e3c13536560acdf8db4229d943e00f32b/dbcopy-0.1.5-py2.py3-none-any.whl", "yanked": false, "yanked_reason": null }, { "comment_text": "", "digests": { "md5": "d7467e174fdfda4e48825a7fb1402826", "sha256": "2d37baa7b5f734ddd4e6657116eca61f0297f4a02cad8ffd0c1050c2db8ae0d3" }, "downloads": -1, "filename": "dbcopy-0.1.5.tar.gz", "has_sig": false, "md5_digest": "d7467e174fdfda4e48825a7fb1402826", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 4170, "upload_time": "2019-10-23T08:12:31", "upload_time_iso_8601": "2019-10-23T08:12:31.351717Z", "url": "https://files.pythonhosted.org/packages/c9/8f/64544bbf1c56fd7df225257f9f2ab6a89a7a4dc441af3ff9803a9e1d5772/dbcopy-0.1.5.tar.gz", "yanked": false, "yanked_reason": null } ], "0.1.6": [ { "comment_text": "", "digests": { "md5": "5465c76d2da49226ff8f80d72a0d3159", "sha256": "9a3ab89f02deb786cd499b0f47f308cc56967b8e4b0b138f149b7bb7f5d39f8f" }, "downloads": -1, "filename": "dbcopy-0.1.6-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "5465c76d2da49226ff8f80d72a0d3159", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": null, "size": 6059, "upload_time": "2020-01-10T07:58:49", "upload_time_iso_8601": "2020-01-10T07:58:49.503872Z", "url": "https://files.pythonhosted.org/packages/71/f7/12fb8bcdfc6b88c0744527c4476e84bfd47c0cf496e4328f061fea934704/dbcopy-0.1.6-py2.py3-none-any.whl", "yanked": false, "yanked_reason": null }, { "comment_text": "", "digests": { "md5": "95a2a675e2b2104bb0d43842e8c6f58e", "sha256": "fc3c18ea5ea7deaa5b90c923a49915ac44011d5715938e5e8129ffd5e4cbc2f8" }, "downloads": -1, "filename": "dbcopy-0.1.6.tar.gz", "has_sig": false, "md5_digest": "95a2a675e2b2104bb0d43842e8c6f58e", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 4272, "upload_time": "2020-01-10T07:58:50", "upload_time_iso_8601": "2020-01-10T07:58:50.720295Z", "url": "https://files.pythonhosted.org/packages/9a/44/acbe34e4dde64ac577e2bdfa49e245f40f91d381e9dbc6c2c7295027325a/dbcopy-0.1.6.tar.gz", "yanked": false, "yanked_reason": null } ], "0.1.7": [ { "comment_text": "", "digests": { "md5": "ad988e444974e435dfdf0f07f4aa0656", "sha256": "bf67246686f6988ddd2930d8225d33893f64e4059b50d3fbf8a790eb9347f3e0" }, "downloads": -1, "filename": "dbcopy-0.1.7-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "ad988e444974e435dfdf0f07f4aa0656", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": null, "size": 6079, "upload_time": "2022-05-02T08:19:48", "upload_time_iso_8601": "2022-05-02T08:19:48.759419Z", "url": "https://files.pythonhosted.org/packages/d4/a4/7f1531c64134d2fe28ee01819f5fb67b988ac740491aa967cf0b9110c8fc/dbcopy-0.1.7-py2.py3-none-any.whl", "yanked": false, "yanked_reason": null }, { "comment_text": "", "digests": { "md5": "b598c0588aff9ca54b499e986bb3d90b", "sha256": "39a59c1130125d030aeeb623abc5402f4297f37ed384a6ff7be17bae19b8cc7b" }, "downloads": -1, "filename": "dbcopy-0.1.7.tar.gz", "has_sig": false, "md5_digest": "b598c0588aff9ca54b499e986bb3d90b", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 5157, "upload_time": "2022-05-02T08:19:49", "upload_time_iso_8601": "2022-05-02T08:19:49.940188Z", "url": "https://files.pythonhosted.org/packages/85/72/723b8630cd9fefd21737de0e983cc2eff2f922408e3c9166194f5a240f57/dbcopy-0.1.7.tar.gz", "yanked": false, "yanked_reason": null } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "ad988e444974e435dfdf0f07f4aa0656", "sha256": "bf67246686f6988ddd2930d8225d33893f64e4059b50d3fbf8a790eb9347f3e0" }, "downloads": -1, "filename": "dbcopy-0.1.7-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "ad988e444974e435dfdf0f07f4aa0656", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": null, "size": 6079, "upload_time": "2022-05-02T08:19:48", "upload_time_iso_8601": "2022-05-02T08:19:48.759419Z", "url": "https://files.pythonhosted.org/packages/d4/a4/7f1531c64134d2fe28ee01819f5fb67b988ac740491aa967cf0b9110c8fc/dbcopy-0.1.7-py2.py3-none-any.whl", "yanked": false, "yanked_reason": null }, { "comment_text": "", "digests": { "md5": "b598c0588aff9ca54b499e986bb3d90b", "sha256": "39a59c1130125d030aeeb623abc5402f4297f37ed384a6ff7be17bae19b8cc7b" }, "downloads": -1, "filename": "dbcopy-0.1.7.tar.gz", "has_sig": false, "md5_digest": "b598c0588aff9ca54b499e986bb3d90b", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 5157, "upload_time": "2022-05-02T08:19:49", "upload_time_iso_8601": "2022-05-02T08:19:49.940188Z", "url": "https://files.pythonhosted.org/packages/85/72/723b8630cd9fefd21737de0e983cc2eff2f922408e3c9166194f5a240f57/dbcopy-0.1.7.tar.gz", "yanked": false, "yanked_reason": null } ], "vulnerabilities": [] }