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
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.
The
My cfddlutils tag does the same thing, but in one line, so there. :)P
--
The price of inaction is far greater than the cost of making a mistake.
Meister Eckhart
On Tue, Jan 26, 2010 at 3:35 PM, Zaphod Beeblebrox wrote:
>
> found a sweet solution.
>
> It's a ruby gem, yaml_db.
>
> 1.) Had to cr
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
use teh ODBC driver for MSSQL. that has worked so far.
On Sat, Jan 23, 2010 at 3:05 PM, denstar 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 philosop
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.
Diogene
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.
On Sat, Jan 23, 2010 at 1:30 PM, denstar wrote:
>
> On Fri, Jan 22, 2010 at 9:25 PM, Zaphod Beeblebrox wrote:
On Fri, Jan 22, 2010 at 9:25 PM, Zaphod Beeblebrox wrote:
>
> trying to move a bunch of tables from mssql to mysql. Anyone know of a
> converter that easy and preferable cheap or free?
The MySQL data migration toolkit fsck'n ROCKS!
It'll do it bad-assly. Haven't played with the latest version
ESF Database Migration Toolkit
http://www.easyfrom.net/
a single user license is $219.
On Fri, Jan 22, 2010 at 8:25 PM, Zaphod Beeblebrox <
zaph0d.b33bl3b...@gmail.com> wrote:
>
> trying to move a bunch of tables from mssql to mysql. Anyone know of a
> converter that easy and preferable che
When I did this I just saved the mssql database to a sql file and ran that
in the query window of mysql-front.
-Original Message-
From: Maureen [mailto:mamamaur...@gmail.com]
Sent: Saturday, January 23, 2010 1:42 AM
To: cf-community
Subject: Re: mssql to mysql recommendations
I use
I use SQLYog. I have the enterprise version, for which a 30 day free
trial is available.
And read this first:
http://dev.mysql.com/tech-resources/articles/migrating-from-microsoft.html
On Fri, Jan 22, 2010 at 8:25 PM, Zaphod Beeblebrox
wrote:
>
> trying to move a bunch of tables from mssql to
trying to move a bunch of tables from mssql to mysql. Anyone know of a
converter that easy and preferable cheap or free?
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusio
12 matches
Mail list logo