[ale] Microsoft Access Database - PHP on Linux

[John Wells]

Jonathon,

I'm in the midst of porting a Sql Server to postgresql, and it's going
smoothly so far.  The Postgres guys have a pretty cool admin utility
(pgadmin.postgresql.org), and it has a Database Migration plugin you can
download.

It'll do automated ports of Sql Server or Access databases.  I've hit a
few snags, but so far it's going really well.  I ported 22 tables and data
in about 15 minutes last night.

Be advised that pgadmin II is Windows only currently.  pgadmin III will be
cross-platform.  I use win4lin to run it.

Let me know if I can help out in any way.

John
404.432.1151

Jonathan Glass said:
> Anyone have any experience getting access (no pun) to Microsoft Access
> databases from Linux/Apache/PHP?  I looked at unixODBC, but it requires
> another product from easysoft, and basically a dedicated machine to
> "server" the ODBC connection.  I'm trying REALLY hard to avoid
> installing a M$ Server, so any thoughts are appreciated.
>
> Anyone ever moved the backend of a complicated Access DB to something
> like Postgre or MySQL?  Since the DB is simple tables, and all the work
> is in the reports and forms, I THINK I should be able to move the actual
> data into Postgres or MySQL, and setup the ODBC links on the win2k
> clients to point to the appropriate server/database combo.
> Unfortunately, that entails installing and configuring ODBC drivers on
> 25 machines...
>
> Any thoughts/comments/gotchas are greatly appreciated.
>
> Thanks
> --
> Jonathan Glass
> Systems Support Specialist II
> Institute for Bioengineering & Bioscience
> Georgia Institute of Technology
> 404.385.0127
>
> _______________________________________________
> Ale mailing list
> Ale at ale.org
> http://www.ale.org/mailman/listinfo/ale



_______________________________________________
Ale mailing list
Ale at ale.org
http://www.ale.org/mailman/listinfo/ale