I went to Mysql's site to download the migration toolkit. There were lots of warnings about it being deprecated and to use the new Workbench software. The workbench software doesn't seem to have a migration toolkit built into it. Plus, the links I could find were only windows versions.
On Jan 27, 2010, at 3:10 PM, Larry C. Lyons wrote: > > Actually the access export worked very easy, using the ODBC driver > provided by MySQL. > I already had MySQL on my machine here. > I went to the Access db and selected the tables I wanted to put into MySQL. > next I right clicked on the table and selected export then ODBC > Databases() in the dropdown. > Then created the ODBC datasource in the next dialog box. > then selected mysql database name in the Export dialog. > I then logged into the MySQL ODBC connector and gave my login > credentials and db info, > clicked OK and the entire 50,000 record table was imported into MySQL. > > No expensive programs needed. > > On Tue, Jan 26, 2010 at 5:35 PM, Zaphod Beeblebrox > <[email protected]> wrote: >> >> found a sweet solution. >> >> It's a ruby gem, yaml_db. >> >> 1.) Had to create a blank rails project. >> 2.) Edit database.yml to point to the source db >> 3.) run rake db:dump >> 4.) edit database.yml to point to the new db >> 5.) run rake db:load >> >> Voila! done. One of the cool things is that it converts it to a database >> agnostic format so it's easy to transfer to/from any type of db supported by >> ActiveRecord. >> >> >> On Jan 23, 2010, at 5:57 PM, Larry C. Lyons wrote: >> >>> >>> use teh ODBC driver for MSSQL. that has worked so far. >>> >>> On Sat, Jan 23, 2010 at 3:05 PM, denstar <[email protected]> wrote: >>>> >>>> I was pretty impressed last time I used it, which was a while ago. >>>> >>>> Here's to hoping that it does ODBC as well! :) >>>> >>>> :DeN >>>> >>>> -- >>>> When I look upon seamen, men of science and philosophers, man is the >>>> wisest of all beings; when I look upon priests and prophets nothing is >>>> as contemptible as man. >>>> Diogenes >>>> >>>> On Sat, Jan 23, 2010 at 12:24 PM, Larry C. Lyons wrote: >>>>> >>>>> Denster you beat me to it. I just did a huge conversion recently from >>>>> M$SQL Server to MySQL using the My SQL Migration toolkit. Fast simple >>>>> and smooth. Next challenge M$ Access to MySQL. >>>> >>>> >>> >>> >> >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-community/message.cfm/messageid:311240 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.5
