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:298157 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4