[AccessD] INFO: Why You Should and Should Not Migrate to MySQL

Jim Lawrence (AccessD) accessd at shaw.ca
Mon Jul 12 14:08:09 CDT 2004


Hi Marty:

Good information. I especially like you statemet "It is not plug and play.
More like plug and pray."...it about sums it up.

Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of MartyConnelly
Sent: Sunday, July 11, 2004 3:35 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] INFO: Why You Should and Should Not Migrate to MySQL


Just came across this article that gives both points of view

Migrating from Microsoft SQL Server and Access to MySQL

http://dev.mysql.com/tech-resources/articles/migrating-from-microsoft.html

 It also describe briefly some conversion methods and helpful programs

Note that a lot of problems will be resolved by MySQL 5.0 where stored
procedures, triggers and views have been introduced, although the stored
procedure
syntax will vary in some degree from Microsoft's T-SQL language. However
MySQL 5.0 is still in alpha which was released in Febuary. You will have
problems with the various dialects of SQL like T-SQL from Microsoft or
PL-SQL from Oracle. It is not plug and play. More like plug and pray.

MySQL Server has many extensions to the SQL standard (so does everyone
else), but does have a startup switch to use only ANSI SQL:2003
compliant code.

 MySQL does have a heavier duty database MAXDB from SAP which uses an
Oracle like SQL syntax, there are perhaps problems with the ODBC bridge to
MAXDB. I have connected to it using Access, but nothing heavy duty.
Also, there is no OLEDB bridge yet to MySQL, for use with .Net, the
people I have heard
who know how to write this (they are thin on the ground) want cash to
write it. Open Source is fine, but not if you have to take off three
months to write and test this.
Probably MYSQL or SAP will pay for it.

--
Marty Connelly
Victoria, B.C.
Canada



--
_______________________________________________
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