acc2psql

acc2psql

Convert Microsoft Access *.accdb or *.mdb into *.sql PostgreSQL format

I believe in MS Access regarding its fast prototyping of relational database. You probably are not going to use MS Access in production environment due to its file based and single user restriction. But in a prototyping phase, MS Acces is one tool that is hard to beat!

Quick and easily prototype your database using MS Access, once satisfied, use this tool to convert said database into PostgreSQL DDL. You can either save it to *.sql file, dump it to console or directly execute it to PostgreSQL instance

If you use Django, you can then run python manage.py inspectdb to turn generated tables into Django models and .. voila, you can skip manually coding tedious Django models yourselves!

pip install acc2sql
python -m acc2sql --src someawesomedatabase.accdb --dump
python -m acc2sql --src someawesomedatabase.accdb --out saveto.sql
python -m acc2sql --src someawesomedatabase.accdb --host localhost --username user --password password --db db

#if you use django
python manage.py inspectdb

This package is still in early development, I may add more database source / target along the way. You can also use this to any tool necessary: for example, I am thinking to use this as PyCharm Extension.. that will be awesome!

Eko - Founder and CEO

Remote Worker Indonesia / LinkedIn / Facebook / Instagram / Twitter

Youtube: Everybody can code!

Spotify: Everybody can code!

[e-mail]