Hello all, I have an MS SQL server dump/sql script that i want to use in a new MySQL database. Obviously the syntax isn't the same but is there a way to convert that entire script to iso/mysql syntax? I have over 50 tables and doing this manually is not very inviting....

Help anyone?????

you have a script generated from SQL Server? that's actually not all that easy to do

conversion to mysql syntax in a text editor using search/replace is straightforward but might be tedious

i'm not aware of any tools that work on the DDL itself (although that doesn't mean there aren't any)

what did you find by googling "convert ms sql server to mysql"?

why not try one of the migration tools.. such as the MySQL Migration toolkit? available from the MySQL site