The MySQL migration tool is freaking AWESOME!
Didn't know about the federated tables or whatever, that's pretty freaking
cool too.
On 5/25/06, Robert Everland III [EMAIL PROTECTED] wrote:
We are getting some servers from the state here that will have MySQL on
them, we will need to consolidate
We are getting some servers from the state here that will have MySQL on them,
we will need to consolidate all of the data on a nightly basis to our Oracle
server. Does anyone know of a tool that will help with this?
Bob
~|
MySQL has federated tables, and Oracle is a supported destination. In
a nutshell, you can add tables to your MySQL database that are backed
by your Oracle tables, rather than a local data file. Don't know if
that will necessarily be of assistance, but it might be worth checking
out.
cheers,
: MySQL to Oracle
We are getting some servers from the state here that will have MySQL on
them, we will need to consolidate all of the data on a nightly basis to
our Oracle server. Does anyone know of a tool that will help with this?
Bob
Oracle Migration Workbench:
http://www.oracle.com/technology/tech/migration/workbench/index.html
I'm sure Toad has the ability to import from MySQL. I'm almost positive
you can export MySQL data to Oracle using Navicat and/or EMS SQL Manager
too.
http://www.navicat.com
http
Federated tables looks to be the best solution so far. This would allow us to
have a schema in oracla set up just for this initiative with a table for each
school. Then we can write a stored procedure to dump the data once a nice to
the designated table.
Bob
Tuesday, January 14, 2003, 8:25:27 PM, John Paul Ashenfelter wrote:
snip
If you look at the methodology of the eWeek study (a link that seems
to have been removed since I first read the article), you'll find a
lot of fine print
snip
I've looked all over eWeek's site and can't find the
: Re: eweek MySQL vs Oracle, etc (Re: WOT: MySQL in the
Enterprise)
Tuesday, January 14, 2003, 8:25:27 PM, John Paul Ashenfelter wrote:
snip
If you look at the methodology of the eWeek study (a link that seems
to have been removed since I first read the article), you'll find a
lot of fine
Wednesday, January 15, 2003, 9:24:51 AM, John Paul Ashenfelter wrote:
eWeek does that for every article with statistics that I've ever
really wanted to read -- details are there, then gone. grr.
Well, looks like this might be it:
http://www.eweek.com/article2/0,3959,808852,00.asp
If you have hard copies, the story was in the January 6, 2003 edition on
page 16.
-Original Message-
From: Tim Laureska [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 15, 2003 9:48 AM
To: CF-Talk
Subject: RE: eweek MySQL vs Oracle, etc (Re: WOT: MySQL in the Enterprise
they turned off in memory, performance
dropped by two thirds according to the article. Equal to Oracle only when
MySQL is running in-memory...
3) The MSSQL JDBC driver was the limiting factor in their tests. They choose
to use a 3rd party driver for MySQL (a good one, but they say
Tuesday, January 14, 2003, 8:25:27 PM, John Paul Ashenfelter wrote:
snip
If you look at the methodology of the eWeek study (a link that seems
to have been removed since I first read the article), you'll find a
lot of fine print
snip
I've looked all over eWeek's site and can't find the article
12 matches
Mail list logo