Stored Procedures Migartion, ODBC, .NET

[Indy De]

Hi

I am new to MySQL and have a few questions in line with stored procedures and ODBC.

1)I am migrating our database from MS SQL server to MySQL, I saw the way to do it would be to export each table in CSV format and then use the importing utility of MySQL DBMS. Is there any faster/better way than do each individual tables one at a time? How does the relationship between my tables get migrated?

2)Are all attribute data types of MS SQL Server supported by MySQL?

3)How do I port the current stored procedures from MS SQL server to mySQL. Is it a direct port?

4)How do I get ODBC drivers for connecting to the MySQL database from a Windows machine. The server could be sitting on a Linux or a Windows box ?

5)Are there any known issues running apps using .net with back-end being mySQL DBMS.

Will be eagerly looking forward to any help or thoughts that anyone can provide? Thanks in advance

Regards

Indy