Josh wrote:
> We currently use a MS Access back end and need to migrate to a proper 
> SQL server. We need to leave options open for SQL Server (for customers 
> who want to use existing infrastructure) and something like MySQL or 
> PostgreSQL. But in the mean time, we need to be able to access an 
> MSAccess (Jet) database from Python.

mxODBC is probably the best way to talk to Jet in a way (DB API)
that makes it reasonably easy to port the data to another RDBMS.
Writing multi RDBMS applications is a whole chapter in itself,
if not a subject for a whole book.

Whether to use an ORM such as SQLObject on top of that is another
issue...
-- 
http://mail.python.org/mailman/listinfo/python-list

Reply via email to