[AccessD] Access to MySQL conversion

John,

You might also have a look at Navicat for MySQL -
http://www.navicat.com/en/products/navicat_mysql/mysql_overview.html

I personally use the Premium Version of Navicat to manage remote databases,
develop complex queries, create views, triggers, UDFs and so on. I use MySQL
as the backend for dynamic websites I build here in Australia - the hosts
are in California. While phpMyAdmin is useful and free, it doesn't compare
to the Navicat product which of course costs ($199 for the MySQL version).

While this may sound like an advertisement for Navicat (it isn't) I simply
can't do without Navicat (I use the Premium Edition which covers most of the
major DBs). At the very least I recommend that you have a look at the
product - it has a 30 day free trial.

As an experiment I imported a few tables from an Access database, across the
WAN and it worked well. I didn't choose anything too complex deliberately,
but from what I saw it has all of the features you might need for a
migration from Access to MySQL plus the ongoing benefit of DB Management. I
do all my DB development work directly in Navicat.

I also use Access as a front-end to MySQL for complex site maintenance
activities - using ODBC for that.

Hope that helps.

Rgeards,

Michael

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Tuesday, 20 September 2011 2:53 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Access to MySQL conversion

This was interesting

http://25yearsofprogramming.com/blog/2010/20100718.htm

Option #2 use Access to push structure and data.  I will definitely be
giving this a try.  I may be able to do programmatically what he was doing
manually which would make it pretty easy.

John W. Colby
www.ColbyConsulting.com

On 9/18/2011 11:50 PM, Michael wrote:
> John,
>
> Have a look at http://forums.mysql.com/list.php?65
>
> This deals with Access/MySQL migrations as well as many other related 
> matters.
>
> Michael
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
> Sent: Monday, 19 September 2011 12:59 PM
> To: Access Developers discussion and problem solving
> Subject: [AccessD] Access to MySQL conversion
>
> Has anybody found a package to do this?  I am finding some things but 
> they look suspicious.
>
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com