Re: MIgrating MS access database to MySQL

[Sebastien Caisse]

First, indeed it is opensource.

- Make sure you have the proper rights on the relationship tables (rtfm) so the MT can read the information from it.
- Special attention needs to be paid for queries for conversion into views, though this should be pretty simple, all depends on the complexity of the query really... There might be headaches if the programmer was overzealous with the VBA support in queries which can be a plague...

There is no trigger support in Access.

If you're planning on keeping the interface, you should know that the ODBC driver sometimes has issues using the .update function, reporting that the record is locked when it's not. This is a known problem and several workarounds are proposed in the online docs.

[Edit] Oh yeah the the nullable state of a column is badly reported to ODBC/JDBC, so for the most part columns are ported as NOT NULL (except obviosuly when indexed PRIMARY KEY or UNIQUE). There is another instance where it's propagated properly but I haven't investigated it yet.



Edited 1 time(s). Last edit at 12/08/2005 07:29AM by Sebastien Caisse.