Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.python > #16418 > unrolled thread

Converting MS Access DB to Postgres or MySQL for ORM support with SQLalchemy

Back to article view | Back to comp.lang.python

Contents

  Converting MS Access DB to Postgres or MySQL for ORM support with SQLalchemy Alec Taylor <alec.taylor6@gmail.com> - 2011-11-30 15:49 +1100
    Re: Converting MS Access DB to Postgres or MySQL for ORM support with SQLalchemy Miki Tebeka <miki.tebeka@gmail.com> - 2011-11-30 06:55 -0800
    Re: Converting MS Access DB to Postgres or MySQL for ORM support with SQLalchemy Miki Tebeka <miki.tebeka@gmail.com> - 2011-11-30 06:55 -0800

#16418 — Converting MS Access DB to Postgres or MySQL for ORM support with SQLalchemy

Good afternoon,

I was recently shown that my client runs MS Access everywhere, rather
than a "real" database. There are many features they would be missing
that something like a django frontend would provide.

So I would like to move them to Postgres or MySQL (since MS Access
support was been dropped after 0.4).

But I would also like to move there schema &etc to ORM, for easy
editing with SQLalchemy (or similar).

What approach would you recommend?

Thanks for all suggestions,

Alec Taylor

[toc] | [next] | [standalone]

#16434

You can read data using win32com (ADODB?) and then write it to the desired database using the right package (psycopg2 ...).

See example for reading data at http://mail.python.org/pipermail/python-win32/2006-March/004420.html

[toc] | [prev] | [next] | [standalone]

#16435

You can read data using win32com (ADODB?) and then write it to the desired database using the right package (psycopg2 ...).

See example for reading data at http://mail.python.org/pipermail/python-win32/2006-March/004420.html

[toc] | [prev] | [standalone]

Back to top | Article view | comp.lang.python

csiph-web