Why not run a local copy of SQL Server Express, run the scripts yourself to import the DB's, than use the migration tool to convert it all over?
!k -----Original Message----- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Monday, February 04, 2008 7:19 PM To: CF-Talk Subject: RE: OT: Translating MSSQL Scripts into MySQL Scripts Hi, Chris...and thanks for the suggestion. However, the toolkit is apparently for migrating data from one database to another and I don't have direct access to the data vendor's database. I only have the MSSQL scripts for creating a database of the tables they use and tab delimited text files of the data. 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. Rick > -----Original Message----- > From: Chris Montgomery [mailto:[EMAIL PROTECTED] > Sent: Monday, February 04, 2008 6:28 PM > To: CF-Talk > Subject: Re: OT: Translating MSSQL Scripts into MySQL Scripts > > Rick Faircloth said the following on 2/4/2008 12:53 PM: > > Can anyone recommend a program that will translate > > MSSQL scripts into MySQL scripts? I found some on > > Google. couldn't find a way to do it on mysql.com. > > > > Before I try a program to do this, I thought I'd > > get some recommendations from those of you with > > experience at this. > > > > I can create the database/tables manually, but > > I sure would like to save some time! > > Rick, > > Have you tried using the MySQL Migration Toolkit from MySQL's site? > (http://www.mysql.com/products/tools/migration-toolkit/) > I have used it to convert a couple of MS Access databases to MySQL but > haven't tried it yet on MS SQL Server. The tutorial is at > http://www.mysql.com/products/tools/migration-toolkit/tutorials/migrate-sql- server.html > > -- > Best regards, > > Chris Montgomery ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:298237 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4