I'd given some thought to this a while ago. The only way you are going
to be able to tell if a row changes is to have a date column on every
oracle table that indicates the last time the data changed.
You'll need some program to start up that knows the last time it ran,
and the current date, a
You have a number of options, but to name a couple you could:
.. Use a tool called DBScriptor to export schema/data out of Oracle
and with a few tweaks
it can generate MySQL DDL/insert statements.
.. Use an ODBC "pump" tool like those included with the Borland
tools lik
Perl/DBI is a possibility.
--Walt
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, March 16, 2004 8:48 AM
> To: [EMAIL PROTECTED]
> Subject: ORACLE to MySQL migration
>
>
> Hello colleagues,
> I have to migrate a lot of ORACLE 8.1.7 databases to
Try SQLyog - http://www.webyog.com/sqlyog
Karam
--- [EMAIL PROTECTED] wrote:
> Hello colleagues,
> I have to migrate a lot of ORACLE 8.1.7 databases to
> MySQL 3.23
>
> I'm looking for a tool or for an algorithm which
> fully supports any
> ORACLE structures ...
> If needed I may use a commerc
SQLyog - www.webyog.com is NOT FREE but has a very
good ODBC import tool for $49 and it includes lot of
other poerful tools. You might check it out.
You can try it out for 30days before purchasing it.
karam
--- "Ansari, Raza (GEI, GEFA)" <[EMAIL PROTECTED]>
wrote:
> Does anyone know any FREE tool
> I have searched the archives but have not found an answer to this.
My searches seem to come up dry the first time around lately, too.
> Our company is moving from Oracle and is in a determination phase as to its
> replacement.
> (Platforms are Windows and Solaris, and better be Linux soon, too
There are several major differences that you will need to consider.
1. So far as I know MySQL does not allow you to assign tables and indexes to
table spaces, hence load spreading is much more difficult. You cannot split
tables and indexes so that they reside on differentt disks.
2. There are no
