[clug-talk] Migrating an office database

Nick Wiltshire nick at dyna-tech.ca
Fri Sep 16 13:08:39 PDT 2005


On Saturday 17 September 2005 3:51 am, Robert Lewko wrote:
> On September 16, 2005 12:38 pm, Nick Wiltshire wrote:
> > Hey all,
> >
> >
> > I just got off the phone with a client who was wisely running an access
> > database from an actively used PC in the office. It crashed. Hard.
> >
> > I delivered a new machine to them yesterday so it turns out they have an
> > extra box laying around and I'd like to reccomend to them that they run
> > their backoffice in Linux [yay this post is on topic]
> >
> > The issue is, how do I allow their windows boxes to connect to a database
> > on the Linux server? Do I use ODBC? Is there any gotchas?
> >
> > Nick
>
> It depends which database, but both MySql and PostgreSQL have ODBC modules.
> Each Windoze client will have to have the ODBC manager set to talk to the
> DB on the linux box.
>

I prefer postgres, but if it's as easy as ODBC it shouldn't be an issue, other 
than migrating the access db...



More information about the clug-talk mailing list