lional Posted December 24, 2007 Share Posted December 24, 2007 Is there anyway to export the table structure and data from mssql and import in into mysql 5. The mssql database has stored procedures Thanks Lional Quote Link to comment Share on other sites More sharing options...
BenInBlack Posted December 24, 2007 Share Posted December 24, 2007 move the structure and data is relatively painless, you have to take the schema and adjust for MySql datatypes, so it can be done. but you have hit on one area where MSSql shines and MySql need to catch up (and I mean a lot) and that is Stored Procedures. you might look into replacing the stored procedures with triggers. Quote Link to comment Share on other sites More sharing options...
Barand Posted December 27, 2007 Share Posted December 27, 2007 Last time I looked MySQL had Stored Procedures, although you need MySQLi library to take full advantage. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.