Yes,,,there are many differences...and to find out about them, go to the microsoft technet web site and search in SQL Server section.

Example, there is NO "date" column type. There is "smdatetime", "datetime", etc.

For ENUM, you need to use BIT (and use 1/0, true/false settings).

BTW: If you are writting a script to work with SQL Server, you really should learn Transact SQL (TSQL) and also how to write stored procedures.

Good luck.
========================================
Buh Bye!

Cheers,
Me