Rainer Giedat wrote:
Hi Stuart,
On Wed, Nov 01, 2006 at 04:59:21PM -0500, stuartv wrote:
This project is all part of my devious plan to gradually
convert to an all (or at least mostly) OpenBSD environment
here at work (psst... don't tell my boss). If this pans out,
I think replacing our SQL server with MySQL on an OpenBSD box
will be the next big conquest. :)
I would not do that if i were you. It does not matter if you
use MySQL or PostgreSQL or any other. Changeing the backend
for MSAccess is a pain in the a**, especially if you have
frontends written in VisualBasic (dudes checking for -1 instead
of false...). You will become at least problems
with compatibility of the data types.
/dev/rainer
But that is exactly what we _did_ do at work. We moved from MS Access
to PostgreSQL seamlessly by using psqlodbc. That let us put our data in
a real database, eliminated all of the data corruption problems we were
having with Access, and let our users continue to use the forms and
whatnot that they were used to while we coded up a web front end (using
php, to throw a comment out there to another thread running on misc@).
The boolean problem mentioned above is a checkbox in the ODBC driver
configs--not a very big PITA compared to supporting Access!
The only downside to the whole process was trying to debug something by
tailing Postgres's logs when someone was doing a query in Access. One
lookup generates a couple of thousand lines of logs!
Jeff
