I recently made the same switch using www.navicat.com I just connected to my SQL server and copied the tables and data to the mySQL server, quick and painless. I really like Navicat for managing mySQL.
Thanks! Christine Davis ColdFusion Lead Nations Technical Services Prairie Village, KS 913-748-8044 ext 4703 [EMAIL PROTECTED] -----Original Message----- From: Doug Brown [mailto:[EMAIL PROTECTED] Sent: Saturday, October 28, 2006 4:17 PM To: CF-Talk Subject: Re: Converting from SQL to mySql Thanks alot Jon!! I will check it out. Regards, Doug B. ----- Original Message ----- From: "Jon Clausen" <[EMAIL PROTECTED]> To: "CF-Talk" <[email protected]> Sent: Saturday, October 28, 2006 2:52 PM Subject: Re: Converting from SQL to mySql > Doug, > > I just migrated most of my databases from MSSQL to MySQL 5 a few > weeks ago. The Intelligent Converter Toolkit ( http://www.convert- > in.com/sqlkit.htm ) was a lifesaver and made it pretty painless > overall. It did a great job of converting the datatypes over and > transferring the data on some particularly involved tables. > > I had to change some queries, but overall it was a good move for me. > > Jon > > On Oct 28, 2006, at 1:01 PM, Doug Brown wrote: > >> I am wondering how difficult it might be to migrate over to mySql >> from SQL2000? Is this a daunting task? Any assistance would be much >> appreciated. I would especially love to hear from someone who has >> done this. >> >> >> >> Regards, >> >> >> Doug B. > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258453 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
