>I'm looking for something that will translate/run the scripts >for MySQL so I can set up the tables. Once I've done that I can >import the data from the text files.
You probably will want to check out the tools at dbconvert.com. You basically can buy a tool for whatever conversion you need. I routinely use their Access-to-MySQL tools to do migrations for customers. Not sure they will be able to do direct conversion from SQL scripts to MySQL scripts...but they can definitely take a MSSQL database and convert it to a MySQL script, and I find their tools are generally more accurate than the migration tools provided by mysql.com (which always seem to miss some crucial part of the schema.) Whether the registration cost is worth it or not for a one-time conversion, hard to say. I've found a need for it over and over though. Almost every other tools I've used has failed me in some way, either missing items, not getting case right (certainly important with MySQL many times), not creating databases in the proper order to do the necessary foreign keys, etc. I always seem to come back to these. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298171 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
