>- see footer for list info -< Yup - I did it on 200 Access dbs to MySQL 4, using CF code, about 2 years ago. It was/wasn't fun! But we were taking these 200 into about five MySQL databases, plus one 'controller' database.
I'm not sure that I could do it again, though I do still have the code somewhere..... Terry ----- Original Message ----- > *From:* "Stephen Moretti" <[EMAIL PROTECTED]> > *To:* "Coldfusion Development" <[email protected]> > *Date:* Tue, 24 Oct 2006 16:45:08 +0100 > > >- see footer for list info -< > On 24/10/06, Rich Wild <[EMAIL PROTECTED]> wrote: > > > > Hello, it is me, Mr Wild. > > > > Today I should like to know from you gentlemen if anyone has had any > > experience of converting an access database to mySQL. > > > Yep - multiple times.... > > Anyone used anything like DBTools to copy the data over? Any > > pointers/hints/recipes/music reviews? > > > Use the MySQL Migration Toolkit.... I used to mess about with Links > from > Access to MySQL via ODBC to literally drag and drop stuff into MySQL > from > within Access, but the migration toolkit just does what it says on the > tin. > > > Anyone brave/foolhardy enough to use CF to do the transfer? > > > only once or twice - never again... splitting sql statements up into > many > cfquerys ~shudder~ > _______________________________________________ > > For details on ALL mailing lists and for joining or leaving lists, go > to http://list.cfdeveloper.co.uk/mailman/listinfo > > -- > CFDeveloper Sponsors:- > >- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -< > >- Lists hosted by www.Gradwell.com -< > >- CFdeveloper is run by Russ Michaels, feel free to volunteer your > help -< > > _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
