Re: converting access db to mysql

"chicha" <mario_at_blindsight.org> wrote in message news:chcfuv$n00$1_at_bagan.srce.hr...
> Hey people,
>
> I have to convert MS Access 2000 database into mysql database, the whole
> thing being part of this project I'm doing for one of my faculty
> classes. My professor somehow presumed I knew db's and gave me long list
> of things to do with that particular database, first thing being that
> particular conversion. Truth is that I don't know a first thing about
> db's, let alone using mysql... I downloaded mysql form www.mysql.com and
> still searching for MS Access 2000 (it doesn't work with 2003 I have,
> or I don't know how to make it work).
>
> Any kind of help will be welcomed and highly appreciated!!!
>
> Thanks,
>
> Mario

OK, now that we have a clearer picture of what you're up against maybe we can break it down into steps:

1. Open the DB up with MS Access.
2. Unload the data into portable format files.
3. Extract the data definitions (at least tables and indexes) into some form for migration.
4. Create an empty target DB.
5. Define tables, indexes, and whatever necessary infrastructure to contain the same data.
6. Load the data from the protable format files.

These tasks are not equally easy. You can probably do some of them by the seat of your pants, just using the general PC skills and savvy you've picked up elsewhere. For some of them, you probably need help.

As far as step 1 goes. I'd really advise you to get someone with the right version of MS Access to open the DB. The last thing you need to be doing at this stage is messing around with version skew or incompatible software. What about the professor? Can he open the DB with his version of Access?

We'll help you with the remaining steps once you can open the DB. Received on Sun Sep 05 2004 - 01:34:12 CEST