[AccessD] Access to MySQL conversion

jwcolby jwcolby at colbyconsulting.com
Tue Sep 20 06:51:08 CDT 2011


AFAICT this is $250 for the "non-commercial" version which I could qualify for if I used it for one 
of my non-profits.

John W. Colby
www.ColbyConsulting.com

On 9/19/2011 6:38 PM, Michael wrote:
> 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
>



More information about the AccessD mailing list