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