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 Link to comment https://forums.phpfreaks.com/topic/83043-mssql-to-mysql/ 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. Link to comment https://forums.phpfreaks.com/topic/83043-mssql-to-mysql/#findComment-422479 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. Link to comment https://forums.phpfreaks.com/topic/83043-mssql-to-mysql/#findComment-423788 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.