MySQL Forums
Forum List  »  Microsoft SQL Server

Stored Procedures Migartion, ODBC, .NET
Posted by: Indy De
Date: December 29, 2004 12:37PM


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



Options: ReplyQuote

Written By
Stored Procedures Migartion, ODBC, .NET
December 29, 2004 12:37PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.