Hi, > I am sure conversion questions are asked a lot, I need to move what is a MS > SQL Server database to a MySQL database, both table stuctures, data, and a > web application with a very large number of queries. > > I am looking for any advice on this undertaking, things to be mindful of and > such, and if anyone knows a good site that explains more on this topic, > links would also be very appreciated. > > My ultimate goal is to port it successfully so none of the queries crash > later on.
Well, there are differences in datatypes, defaults and more like that stuff, so it might be a bit more work. To get a head-start, an automated migration tool might help, of course. Make sure to check out the Schema Migrator tool in Database Workbench ( www.upscene.com ) - it might help you a lot. With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server. Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]