Skip to main content

A package to convert MS Access (.mdb, .accdb) into a SQL file (Optionally with It's data)

Project description

Version License paypal

AccessMySQLConverter

AccessMySQLConverter aims to provide a tool which converts MS Access database files (.mdb, .accdb) into a SQL file (compatible with PostgreSQL, MariaDB and MySQL) that can be run, generating It's structure (tables, ERM...) and It's data

Installation

To install it you must have Python 3.x installed and run in the command prompt

pip install --no-cache-dir --upgrade accessmysqlconverter

Run it

For executing the program run in the command prompt the following instruction

python -m accessmysqlconverter.application

Application Image

The tool is limited by the driver so after converting an Access Database you should look for:

  • Nullability of columns and Default values
  • Check ERM for missing 1:1, 1:N or N:N
  • Collation, character set
  • Foreign Keys ON DELETE actions

License

See LICENSE for more information

Donations

paypal

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

accessmysqlconverter-2.0.0.tar.gz (35.3 kB view details)

Uploaded Source

Built Distribution

accessmysqlconverter-2.0.0-py3-none-any.whl (37.6 kB view details)

Uploaded Python 3

File details

Details for the file accessmysqlconverter-2.0.0.tar.gz.

File metadata

  • Download URL: accessmysqlconverter-2.0.0.tar.gz
  • Upload date:
  • Size: 35.3 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/3.3.0 pkginfo/1.6.1 requests/2.25.1 setuptools/51.1.1 requests-toolbelt/0.9.1 tqdm/4.55.1 CPython/3.9.1

File hashes

Hashes for accessmysqlconverter-2.0.0.tar.gz
Algorithm Hash digest
SHA256 64d873752905a97e92ec821ccd0704d02eec613b5dedbb20cd0a171535d0dbc4
MD5 29972adcc2c3311f4b1f2cb324b05ea6
BLAKE2b-256 27a6274d59353098b03fb7f8bbd6dcd18b58fd85598352042f72715c10cf8493

See more details on using hashes here.

File details

Details for the file accessmysqlconverter-2.0.0-py3-none-any.whl.

File metadata

  • Download URL: accessmysqlconverter-2.0.0-py3-none-any.whl
  • Upload date:
  • Size: 37.6 kB
  • Tags: Python 3
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/3.3.0 pkginfo/1.6.1 requests/2.25.1 setuptools/51.1.1 requests-toolbelt/0.9.1 tqdm/4.55.1 CPython/3.9.1

File hashes

Hashes for accessmysqlconverter-2.0.0-py3-none-any.whl
Algorithm Hash digest
SHA256 d9a282bee8425227ea047f2ff3df3f3c55a68dd22076f754141b0604b7eea0c5
MD5 205d1d5290f6e1366d7c4d6d104da318
BLAKE2b-256 45128d27af351a7e9026d572031ff6905f691aedb22ec0485b318c5200cb1242

See more details on using hashes here.

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page