Most likely you'd need to do some datatype mapping changes to the script...
Everyone I know who's had to do this has typically used something like sqlyog (search google) and used the ODBC import cabability to transfer data from MSSQL -> MySQL.. On Thu, 18 Sep 2003, Tormod Halvorsen wrote: > Hi all! > > (My apologies if this has been beaten to death allready, but I *did* > search the archives without much luck.) > > I'm moving from MS SQL to MySQL. Before jumping from the old server, I > scripted out the definitions for tables and their fields, thinking I > might just run them into MySQL. Guess I need to edit the script some, > because it keeps giving me a "Syntax error" message. > > Anyone know of a good source for info on how to make MS SQL scripts work > on MySQL? I also have a copy of the database exported in MS Access > format to hold the data - don't suppose it's any easier that way, uh? > > Thanks! > > peace, > Tormod in Stockholm > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
