Using Mysql and Maxdb if data is on Access

[Former Member]

Hi,

We are currently using Access and are thinking of changing. Now we would like to use Mysql and Maxdb. Only problem is that all our customer addresses and other information are on Access.

Can you help us with this?

Thank you.

[Former Member]

As I read on the first post, you are needing to get customer data to your other database. You could try using some software that will help you in managing the transfer.

I can recommend the use of data integration software such as Datastage or Talend Open Studio (open source). Tell us how it went.

Edited by: wgkalbente on Nov 27, 2009 4:30 PM

[lbreddemann]

> We are currently using Access and are thinking of changing. Now we would like to use Mysql and Maxdb. Only problem is that all our customer addresses and other information are on Access.

> Can you help us with this?

The right approach to this really depends on what you do now and what you want to change in the future.

A common approach for moving away from ACCESS to a real DBMS is to keep the ACCESS frontend but to use linked tables to the database server for the data storage.

If you're just talking about 20-40 tables, then take the effort and manually change the data model/types, implement it to the MaxDB database and move the data over via "update queries" in ACCESS.

If your data design is larger you may want to check whether you can automate the transition with the help of tools.

But in general those migration tools don't work that problemless so you likely will end up again with manual fixing...

What's certainly a good idea is to clean up your data model and the data before you migrate!

ACCESS databases tend to have a lot more crap data in them then real DBMS - so make sure that you got rid of it beforehand.

regards,

Lars

[former_member192710]

>

> We are currently using Access and are thinking of changing. Now we would like to use Mysql and Maxdb. Only problem is that all our customer addresses and other information are on Access.

> Can you help us with this?

You might want to make use of a tool like [sql-workbench|http://www.sql-workbench.net/] and JDBC to copy data between the two actual platforms on an SQL level, given the two platforms do support this kind of operation. I know there is one or the other JDBC driver available for MS Access, but I never really bothered using it. Looking back at the days however when we moved off MS SQL Server 97 to MaxDB 7.5, most of the work was done automagically using a tool like this but the "tweaking" required afterwards wasn't all that trivial. Worked out, though, as it's not something you do each day.

Good luck,

K.

[markus_doehr2]

> We are currently using Access and are thinking of changing. Now we would like to use Mysql and Maxdb. Only problem is that all our customer addresses and other information are on Access.

> Can you help us with this?

What kind of "help" do you expect? We can't write migration programs for you

Markus