Mssql - Mysql

Hi!

As a newbie I'm wondering if there is a difference between mySql and msSql.

Will mySql -code and -tables work in a msSql database?

Thank you!

Hi !

Well...thats depends. The code ported from mysql ill work if you only used the ANSI SQL compliant features. if you use any specific keywords or features of MySQL you will get a compilation / syntax error because SQL Server won′t know of these keyewords (like LIMIT). The relational data itself it compatible with SQL Server as you find an appropiate matching data type at SQL Server. Data Types differ in the different system, so while importing data in SQL Server you will have to decide how to convert (or match) the data(-types).

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de