• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: SQL Server questions
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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


References: 
 >SQL Server questions (From: Randy Wigginton <email@hidden>)

  • Prev by Date: SQL Server questions
  • Next by Date: Re: SQL Server questions
  • Previous by thread: SQL Server questions
  • Next by thread: Re: SQL Server questions
  • Index(es):
    • Date
    • Thread