Rob, Snag, > MySQL will accept nearly all of the same standard syntax as SQL Server, > but if the database is running under SQL Server then you have no choice > but to use a SQL Server database driver to access it. Copy all the data > over to a MySQL database and you can then use MySQL in the same way.
FWIW, there *will* definitely be syntactical differences in SQL between the two databases. MySQL and MSSQL support a different portion of the SQL standard, and each has proprietary extensions to SQL that are very different. For example: MySQL does not support UPDATE table1 ... FROM table2 last I checked; MSSQL does not support LIMIT and OFFSET; MSSQL has Views and Procedures; etc. An excellent resource for these differences (though a bit out of date, esp. regarding both InnoDB and Postgresql) is O'Reilly's "SQL in a Nutshell". This is *not* an introductory book and has some other problems, but does do a good job of comparing MySQL, MSSQL, PostgreSQL, and Oracle on a command-by-commmand basis. -- Josh Berkus Aglio Database Solutions San Francisco -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
