[dba-SQLServer] Upgrade to MySql

Jim Lawrence accessd at shaw.ca
Sun Aug 8 15:29:40 CDT 2010


Hi Rocky:

To say the least your work is cut out for you. A creditable job will/may
cost the client a large whack of hours times your current prevailing rate.
If they are OK with that assumption you can move to the next step.

There are some commercial products that can assist with BE upgrade:
http://www.navicat.com/en/products/navicat_mysql/mysql_overview.html
http://www.navicat.com/en/buynow/store.html

...and dramatically reduce time and effort but...

Jim
 

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Rocky
Smolin
Sent: Sunday, August 08, 2010 8:26 AM
To: dba-SQLServer at databaseadvisors.com
Subject: [dba-SQLServer] Upgrade to MySql


  Dear List:

  I have a client with a rather large application who is considering
upgrading  the back end to MySql.  

  Objects:
  ~100 forms
  ~150 queries
  ~75 reports

  Lots of code modules with many lines and lots of CBF.

  The app uses bound forms and lots of DAO. 

  BE is an mdb.  FE & BE are both A2K3. 

  Question is, of course, what is involved in converting this front end to
work with a MySQL back end?

  MTIA,

  Rocky Smolin
  Beach Access Software
  858-259-4334
  www.e-z-mrp.com ;
  www.bchacc.com ;

_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com




More information about the dba-SQLServer mailing list