Thanks for the lead and tips, Mary Jo! Rick
> -----Original Message----- > From: Mary Jo Sminkey [mailto:[EMAIL PROTECTED] > Sent: Monday, February 04, 2008 10:56 PM > To: CF-Talk > Subject: Re: Translating MSSQL Scripts into MySQL Scripts > > >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:298174 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
