Re: SQL Server questions
Re: SQL Server questions
- Subject: Re: SQL Server questions
- From: "Simon J. Oliver" <email@hidden>
- Date: Mon, 19 Nov 2007 09:14:40 -0600
I have similar situation where I need to periodically extract a few
gigs of data out out umpteen MS SQL Server tables and put it into MySQL.
I tried various different migration tools and had the most success
with SQLYog ( http://www.webyog.com/en/ ). It's commercial software
($100, less if you qualify for discounts), and Windows only, but I was
able to run it fine under Parallels. (In fact, since I was starting
from a SQL Server backup file burned to DVD, I restored the database
to SQL Express 2005 (or whatever the 'new' MSDE is called) running
under Parallels, and then ran SQLYog to pull that data out (via an
ODBC connection to localhost) and move it over to the MYSQL box.
There is also a free MySQL migration tool that is part of the free
MySQL gui tools, but last time I looked that was also only part of the
Windows distribution, although I think other platforms were in the
works. That sort of worked, but it was sufficiently flaky for my
particular data set that I decided it was worth going with SQLYog.
Regards,
Simon
--
Simon J. Oliver
SBBER/AITC
University of Memphis, TN
On Nov 19, 2007, at 8:56 AM, Randy Wigginton wrote:
Does anyone have experience with connecting new world order WO to a
sql server database? There is a jdbc driver, so theoretically it
should "just work"... but it kills SQL Explorer and Eclipse every time
I try to look at it.
Does anyone have some suggestions on how to get data out of sql server
and into MySQL?
Sorry, but my starting point is sql server, and I need to find some
way of accessing it. And then getting away from it.
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden