I need to migrate about a dozen tables from ORACLE 10g to MySQL 5. I
have manually migrated the schema to MySQL. I am able to write SQL*PLUS
queries to extract ORACLE data into insert statements (including date
conversions to MySQL format etc) that I can run against the MySQL
database. The CLOB
Martijn Tonies wrote:
database. I would also bet that 80% of the people who are actually
writing queries with that many joins don't have a solid grasp of the
fundamental principles of relational database design.
Why not? Normalizing gets you -more- tables, not less.
And normalizing is a
Tom,
I noticed the article didn't say how much money you'll save by not paying
through the nose for Oracle per server licensing, the cost of upgrading
your hardware to get some speed out of Oracle, or the cost of having to
hire one or more Oracle administrators to manage and tweak the database.
Martijn Tonies wrote:
Martijn Tonies wrote:
database. I would also bet that 80% of the people who are actually
writing queries with that many joins don't have a solid grasp of the
fundamental principles of relational database design.
Why not? Normalizing gets you -more- tables, not less.
database. I would also bet that 80% of the people who are actually
writing queries with that many joins don't have a solid grasp of the
fundamental principles of relational database design.
Why not? Normalizing gets you -more- tables, not less.
And normalizing is a goal in itself? I've seen
Oracle will sell it if they can convince the customer.
Any one who has had the pleasure of using Oracle Application Server
can attest to that.
--
- michael dykman
- mdyk...@gmail.com
May the Source be with you.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
On 01/29/2010 07:24 PM, Shawn Green wrote:
Rudy Lippan wrote:
On 01/29/2010 02:57 PM, Chris W wrote:
Hardcore stupid if you ask me. I suppose it is possible to have a
valid reason (can't imagine what it might be) for using more than 61
How about complex data requirements? Depending on the
On 1/29/10 5:03 PM, mos mo...@fastmail.fm wrote:
I noticed the article didn't say how much money you'll save by not paying
through the nose for Oracle per server licensing, the cost of upgrading
your hardware to get some speed out of Oracle, or the cost of having to
hire one or more Oracle
will sell it if they can convince the customer.
Just some thoughts.
- Original Message -
From: Tom Worster f...@thefsb.org
To: mos mo...@fastmail.fm; mysql@lists.mysql.com
Sent: Sunday, January 31, 2010 7:39 PM
Subject: Re: 50 things to know before migrating from Oracle to MySQL
On 1
Martijn Tonies wrote:
database. I would also bet that 80% of the people who are actually
writing queries with that many joins don't have a solid grasp of the
fundamental principles of relational database design.
Why not? Normalizing gets you -more- tables, not less.
And normalizing is a
Rudy Lippan wrote:
How about complex data requirements? Depending on the resolution of
your data set, I could see a simple person-type object that contained
name, address, SSN, mother, and birth_info starting to approach the limit.
Cities change, address changes, names change, and even mothers
On 1/28/10 5:21 AM, changuno chang...@rediffmail.com wrote:
Hi folks,
Read a blog which states 50 things to know before migrating from Oracle to
MySQL. Any comments on this?
as a relatively unsophisticated dbms user (just dynamic web site back end),
i thought it was very interesting to see
Hmmm... I find it suspicious that there are *exactly* 50 things you need to
know before migrating from oracle to mysql. Not 49. Not 51. Exactly 50.
Well, he did repeat that clustering is not what you think it is so I guess
it technically is 49. But I wonder what would happen if he thunk up
25. Each table can have a different storage backend (”storage engine”).
Yes, we absolutely allow this.
Each engine brings a certain strength to the storage and retrieval
solutions you can create with MySQL. We explicitly recognize that there is
no one size fits all approach that meets the
fsb wrote:
as a relatively unsophisticated dbms user (just dynamic web site back end),
i thought it was very interesting to see the kinds of things oracle users do
that i'd never have imagined.
more than 61 joins in a query?! man, those guys are hardcore.
Hardcore stupid if you ask me. I
At 01:57 PM 1/29/2010, Chris W wrote:
fsb wrote:
as a relatively unsophisticated dbms user (just dynamic web site back end),
i thought it was very interesting to see the kinds of things oracle users do
that i'd never have imagined.
more than 61 joins in a query?! man, those guys are hardcore.
as a relatively unsophisticated dbms user (just dynamic web site back
end),
i thought it was very interesting to see the kinds of things oracle users
do
that i'd never have imagined.
more than 61 joins in a query?! man, those guys are hardcore.
Hardcore stupid if you ask me. I suppose it
... or 50 ways to leave your Oracle...
... or 50 ways to save your money...
Choose mysql! :)
--
Jørn Dahl-Stamnes
homepage: http://www.dahl-stamnes.net/dahls/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
On 01/29/2010 02:57 PM, Chris W wrote:
Hardcore stupid if you ask me. I suppose it is possible to have a
valid reason (can't imagine what it might be) for using more than 61
How about complex data requirements? Depending on the resolution of
your data set, I could see a simple person-type
Rudy Lippan wrote:
On 01/29/2010 02:57 PM, Chris W wrote:
Hardcore stupid if you ask me. I suppose it is possible to have a
valid reason (can't imagine what it might be) for using more than 61
How about complex data requirements? Depending on the resolution of
your data set, I could see a
Hi folks,
Read a blog which states 50 things to know before migrating from Oracle to
MySQL. Any comments on this?
nbsp;nbsp; 1. Subqueries are poorly optimized.
nbsp;nbsp; 2. Complex queries are a weak point.
nbsp;nbsp; 3. The query executioner (aka query optimizer / planner) is less
...@rediffmail.com wrote:
Hi folks,
Read a blog which states 50 things to know before migrating from Oracle to
MySQL. Any comments on this?
nbsp;nbsp; 1. Subqueries are poorly optimized.
nbsp;nbsp; 2. Complex queries are a weak point.
nbsp;nbsp; 3. The query executioner (aka query optimizer / planner
changuno wrote:
Hi folks,
Read a blog which states 50 things to know before migrating from Oracle to
MySQL. Any comments on this?
... list snipped ...
MySQL was never designed to be a clone of Oracle (the database). We
have distinct differences in design and implementation that make us
Shawn Green wrote:
23. There are fewer and less sophisticated tools for administration.
MySQL doesn't need them. That alone should tell you something about
our reliability.
This speaks to simplicity-- both in terms of easy to use and in terms of
more limited features. It says nothing
On 1/28/2010 3:21 AM, changuno wrote:
Hi folks,
Read a blog which states 50 things to know before migrating from Oracle to
MySQL. Any comments on this?
would it have been too much to just link to it?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
-Original Message-
From: John Meyer [mailto:johnme...@pueblocomputing.com]
Sent: Thursday, January 28, 2010 2:16 PM
To: mysql@lists.mysql.com
On 1/28/2010 3:21 AM, changuno wrote:
Read a blog which states 50 things to know before migrating
from Oracle to MySQL. Any comments
A quick Google turned up
http://www.xaprb.com/blog/2009/03/13/50-things-to-know-before-migrating-oracle-to-mysql/
Man, I love Google.
Thanks,
Carl
- Original Message -
From: Daevid Vincent dae...@daevid.com
To: mysql@lists.mysql.com
Cc: 'changuno ' chang...@rediffmail.com
Sent
Doesn't Google run MySQL ?
Hmmm
On Thu, Jan 28, 2010 at 4:56 PM, Carl c...@etrak-plus.com wrote:
A quick Google turned up
http://www.xaprb.com/blog/2009/03/13/50-things-to-know-before-migrating-oracle-to-mysql/
Man, I love Google.
Thanks,
Carl
- Original Message - From
Hello,
I've two LEFT OUTER JOINS in the WHERE section in an Oracle script like:
select ...
from...
where
...
and PT1.ID (+) = bl.PARENTTYPE_1
and PT2.ID (+) = bl.PARENTTYPE_2
...
MySQL knows LEFT OUTER JOINS in the FROM section but two joins with the same
table aren't accepted.
example:
[EMAIL PROTECTED] wrote:
Hello,
I've two LEFT OUTER JOINS in the WHERE section in an Oracle script like:
select ...
from...
where
...
and PT1.ID (+) = bl.PARENTTYPE_1
and PT2.ID (+) = bl.PARENTTYPE_2
...
MySQL knows LEFT OUTER JOINS in the FROM section but two joins with the same
table
-Nachricht
Datum: Fri, 31 Aug 2007 09:30:13 -0400
Von: Baron Schwartz [EMAIL PROTECTED]
An: [EMAIL PROTECTED]
CC: mysql@lists.mysql.com
Betreff: Re: JOIN migration from Oracle to MySQL
[EMAIL PROTECTED] wrote:
Hello,
I've two LEFT OUTER JOINS in the WHERE section in an Oracle script
[EMAIL PROTECTED] wrote:
Hello,
thank you - now it works.
d_parenttype PT1 LEFT OUTER JOIN t_booklists bl ON (PT1.ID = bl.PARENTTYPE_1),
d_parenttype PT2 LEFT OUTER JOIN t_booklists bk ON (PT2.ID = bk.PARENTTYPE_2)
I had to put the alias to all listet fields in the select.
Unless you are
, Falcon
gets finished and it does full text indexing, transactions,
check/unique/primary
and foreign key constraints, then we're getting somewhere.
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle
MS SQL Server
Upscene Productions
http://www.upscene.com
My
with the currently available non-alpha storage engines
in MySQL: they just don't cut it.
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions
Martijn Tonies wrote:
LOL - an entertaining read!
Entertaining? I feel to see the humor in his post.
I thought it was concise and well written, with an undertone of I know
I'm swearing in church but So yes, I found it entertaining (I agree
that it was not necessarily humorous
Grant Allen wrote:
Storage engines are unique to MySQL? yes. Is that good? YMMV. Most
of the purported benefits can be achieved with Oracle's features
without the compromises of balkanised storage engines. You're right,
they're not offered by Oracle, or anyone else ... there's a reason
On Thursday 26 July 2007 Rajesh Mehrotra's cat, walking on the keyboard,
wrote:
Check out
http://www-css.fnal.gov/dsg/external/freeware/mysql-vs-pgsql.html
Please note that PostgreSQL provides a gateway to other databases thanks to
the DBI-Link extension, as well as it support more than
Tangirala, Srikalyan wrote:
Hi All:
Could you provide some more information about Oracle limitations, MySQL
limitations, Oracle vs. MySQL etc?
Sure, let's play devil's advocate for a minute.
Some things unique to MySQL that Oracle does not offer include:
- Storage engines, choices like
: RE: Migration from Oracle to MySQL
Check out
http://www-css.fnal.gov/dsg/external/freeware/mysql-vs-pgsql.html
Raj Mehrotra
hccs - Experts in Healthcare Learning
[EMAIL PROTECTED]
-Original Message-
From: Tangirala, Srikalyan [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 26, 2007
Hi All:
I am doing a study on the migration of databases from Oracle to MySQL. In
this process, I gathered few points.
Overall, I think arguments can be made in favor of MySQL in terms of
performance, stability, ease of use, and cost. All of these things point to
decreased TCO when using MySQL
Hi,
Could you provide some more information about Oracle limitations, MySQL
limitations, Oracle vs. MySQL etc?
I thought it was your study?
MySQL doesn't have (compared to Oracle):
- check constraints
- a procedural language as mature as Oracle PL/SQL
- triggers on a per statement basis
Thanks for your input Raj.
Regards,
Sri
-Original Message-
From: Rajesh Mehrotra [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 26, 2007 11:32 AM
To: Tangirala, Srikalyan; cluster
Cc: mysql@lists.mysql.com
Subject: RE: Migration from Oracle to MySQL
Check out
http://www-css.fnal.gov
@lists.mysql.com
Subject: Migration from Oracle to MySQL
Hi All:
I am doing a study on the migration of databases from Oracle to MySQL.
In this process, I gathered few points.
Overall, I think arguments can be made in favor of MySQL in terms of
performance, stability, ease of use, and cost. All
Hi Friends,
Does any body know of any tool available for migrating data from oracle to
mysql. Can you please pass on the url.
regards
anandkl
http://www.mysql.com/products/tools/migration-toolkit/
There is a video presentation as well here for ORacle to MySQL migration.
Thanks,
- Arun
On 3/12/07, Ananda Kumar [EMAIL PROTECTED] wrote:
Hi Friends,
Does any body know of any tool available for migrating data from oracle to
mysql
Hi All:
We are trying to migrate the oracle database to mysql using the
MySQL migration kit. During the process, when we have specified the source
and target information and tried to establish a connection, the error we have
got is the following:
Connecting to source database
Hi,
Does any body know of any tool available for migrating data from oracle to
mysql. Can you please pass on the url.
You might want to try our Database Workbench tool:
www.upscene.com
It includes a Schema Migration and DataPump tool.
Martijn Tonies
Database Workbench - tool for InterBase
here for ORacle to MySQL
migration.
Thanks,
- Arun
On 3/12/07, Ananda Kumar [EMAIL PROTECTED] wrote:
Hi Friends,
Does any body know of any tool available for migrating data from
oracle to
mysql. Can you please pass on the url.
regards
anandkl
--
MySQL General Mailing List
For list
Hello everyone,
I had a quick question...I am looking to move away from our dependence on
Oracle over to using a Mysql Cluster. Due to the complexity of the move it
will have to happen over a period of time, what I would like to do is keep our
mysql database in sync with our Oracle DBthis
or near real time.
On the flip side, because you will be batching updates/inserts/deletes
that happen over a period of time (even if it's just 10-15 minutes) and
apply them to MySQL all at once, you will be putting 10-15 minutes worth
of Oracle processing onto MySQL all at once. Unfort, this isn't
Hi All,
I need some suggestions from you. I need a comunication between Oracle
database with MySQL.
In my application there is a situation is arising, where i need to take some
data to MySql from a table which is in Oracle database (i am planning to
maintain that data in MySQL also). And from
--On August 14, 2006 9:11:30 PM +0530 balaraju mandala
[EMAIL PROTECTED] wrote:
Hi All,
I need some suggestions from you. I need a comunication between Oracle
database with MySQL.
http://www.webmethods.com/
They sell software to do this. Or...well... ActiveSoftware/ActiveWorks did
which
this example: the user updates something, it goes to Oracle, than
MySQL. Your system update lots of things out of it. Than, the user
realizes he's wrong and update again the record, and some of your
updates might not work, other things were deleted that shouldn't
according to your business model.
I'm
PROTECTED]
Sent: Tuesday, September 27, 2005 3:59 AM
To: Sujay Koduri
Cc: mysql@lists.mysql.com
Subject: Re: Avg row length is varying a lot from oracle to MySQL
Sujay Koduri wrote:
we are converting our oracle DB to MySQL DB. One problem i see is that
the abg row length in MySQL is much higher
Jeff wrote:
Each row in the table takes around 600 bytes, taking every
thing into consideration and assuming every field is used to
its maximum bytes. But the major portion of this 600 bytes
are composed of varchar's (100 + 150 + 50 + 16 + 50 + 20 +
9..) Out of these 400 bytes we generally
Sujay Koduri wrote:
we are converting our oracle DB to MySQL DB. One problem i see is that the
abg row length in MySQL is much higher compared to that of Oracle. In
oracle it is around 180 bytes and in MySQL it is around 686 bytes. So as a
result, MySQL is taking more space to store the same
Hi Friends,
Any help on this is highly appreciated.
regards
anandkl
On 9/23/05, Ananda Kumar [EMAIL PROTECTED] wrote:
Hi Friends,
I have set up all the drivers and configured the Hetrogenous service in
oracle and set all the relevent parameter. Now when i am connecting to MYSQL
from ORACLE
and set all the relevent parameter. Now when i am connecting to
MYSQL
from ORACLE i am getting the below error
select counter from ebay_stats@test [EMAIL PROTECTED] where
rownum 2
*
ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this
message:
[Generic
and configured the Hetrogenous service
in
oracle and set all the relevent parameter. Now when i am connecting to
MYSQL
from ORACLE i am getting the below error
select counter from ebay_stats@test [EMAIL PROTECTED] where
rownum 2
*
ERROR at line 1:
ORA-28500: connection from ORACLE
PROTECTED]
Date: Sep 20, 2005 9:46 PM
Subject: connect from oracle to MYSQL.
To: mysql@lists.mysql.com
Hi All,
Can you please help me in connecting from oracle database to mysql
database.
I am trying to setup the hetrogenious service provided by oracle, but
i am
on this.
regards
anandkl
-- Forwarded message --
From: Ananda Kumar [EMAIL PROTECTED]
Date: Sep 20, 2005 9:46 PM
Subject: connect from oracle to MYSQL.
To: mysql@lists.mysql.com
Hi All,
Can you please help me in connecting from oracle
hi ,,
we are converting our oracle DB to MySQL DB. One problem i see is that the
abg row length in MySQL is much higher compared to that of Oracle.
In oracle it is around 180 bytes and in MySQL it is around 686 bytes. So as
a result, MySQL is taking more space to store the same number
-Original Message-
From: Sujay Koduri [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 22, 2005 15:23
To: mysql@lists.mysql.com
Subject: Avg row length is varying a lot from oracle to MySQL
hi ,,
we are converting our oracle DB to MySQL DB. One problem i
see
@lists.mysql.com
Subject: RE: Avg row length is varying a lot from oracle to MySQL
-Original Message-
From: Sujay Koduri [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 22, 2005 15:23
To: mysql@lists.mysql.com
Subject: Avg row length is varying a lot from oracle to MySQL
hi ,,
we
overhead so generally take your
calculated row size and multiply by 1.1.
sujay
-Original Message-
From: Jeff [mailto:[EMAIL PROTECTED]
Sent: Friday, September 23, 2005 1:12 AM
To: mysql@lists.mysql.com
Subject: RE: Avg row length is varying a lot from oracle to MySQL
-Original
Hi Friends,
I have set up all the drivers and configured the Hetrogenous service in
oracle and set all the relevent parameter. Now when i am connecting to MYSQL
from ORACLE i am getting the below error
select counter from ebay_stats@test where rownum 2
*
ERROR at line 1:
ORA-28500: connection
2005/9/21, Ananda Kumar [EMAIL PROTECTED]:
Hi Friends,
Can you please help me on this.
regards
anandkl
-- Forwarded message --
From: Ananda Kumar [EMAIL PROTECTED]
Date: Sep 20, 2005 9:46 PM
Subject: connect from oracle to MYSQL.
To: mysql@lists.mysql.com
Hi All
-- Forwarded message --
From: Ananda Kumar [EMAIL PROTECTED]
Date: Sep 20, 2005 9:46 PM
Subject: connect from oracle to MYSQL.
To: mysql@lists.mysql.com
Hi All,
Can you please help me in connecting from oracle database to mysql
database.
I am trying to setup the hetrogenious
Kumar [EMAIL PROTECTED]:
Hi Friends,
Can you please help me on this.
regards
anandkl
-- Forwarded message --
From: Ananda Kumar [EMAIL PROTECTED]
Date: Sep 20, 2005 9:46 PM
Subject: connect from oracle to MYSQL.
To: mysql@lists.mysql.com
Hi All
Hi All,
Can you please help me in connecting from oracle database to mysql database.
I am trying to setup the hetrogenious service provided by oracle, but i am
not able to complete all the steps.
I am failing at this step
*cp MyODBC-3.51.06-sun-solaris2.8-sparc/libmyodbc3* lib*
# *mv etc
Hi Friends,
Can you please help me on this.
regards
anandkl
-- Forwarded message --
From: Ananda Kumar [EMAIL PROTECTED]
Date: Sep 20, 2005 9:46 PM
Subject: connect from oracle to MYSQL.
To: mysql@lists.mysql.com
Hi All,
Can you please help me in connecting from oracle database
Good morning,
I have scripts to create constraints, sequences, storage..., tables from
ORACLE and I don't know if I can create them in MySQL?
Appreciated your help,
Thank you,
Phong
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Schema Migration tool in Database Workbench a try.
Download a copy here: www.upscene.com
With regards,
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http
Nguyen, Phong wrote:
Good morning,
I have scripts to create constraints, sequences, storage..., tables from
ORACLE and I don't know if I can create them in MySQL?
You can try our Migration Toolkit which has pretty good support
for Oracle now...
, Phong [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 26, 2005 7:55 AM
To: mysql@lists.mysql.com
Subject: ORACLE and Mysql: Create tables, constraints, swquences, storage.
..?
Good morning,
I have scripts to create constraints, sequences, storage..., tables from
ORACLE and I don't know if I can
Good evening all,
I've got an Oracle text dump from a client for conversion to MySQL.
Before I dive into SED or Perl does anyone know of a script to convert
the dump file?
I did the dev site by hand, not much to it, the site is fairly simple.
Mostly NUMBER to INT, VARCHAR2 to VARCHAR, and CLOB
First of all a kind salute to the master yoda of SQL query's Shawn Green :)
He saved me a couple of hours the other day with a linking a table to itself
query !
I've been in the Telecommunications industry for more than 2 years now. I
hope that I can provide feedback any questions regarding DB
Hi,
I am also doing migration from oracle 7.3 to mysql 4.0 classic.
May i know how to handle Oracle Views, stored procedures/triggers in MySQL 4.0 ?.
May i know how to create database, table space, roll back segments, users, allocating
tables to table spaces (as we do in oracle
Oracle to mySql [online stats]
Hi,
I am also doing migration from oracle 7.3 to mysql 4.0 classic.
May i know how to handle Oracle Views, stored procedures/triggers in MySQL
4.0 ?.
If I remember correctly Views don't appear till 8.0 so why do you need them?
Any way the specific answer
: Migrating from Oracle to mySql [online stats]
Hi,
I am also doing migration from oracle 7.3 to mysql 4.0 classic.
May i know how to handle Oracle Views, stored procedures/triggers in MySQL
4.0 ?.
May i know how to create database, table space, roll back segments, users,
allocating
Hello,
I found a question about Oracle 2 MySQL replication in the
archive on Sep. 2001 but no mention since?
We have a department using Oracle 8.1.7 and I'm running MySQL
4.0 and neither of us wants to change :-)
I could call a Perl, C++ or Java program from cron to periodically
update
On Tue, Jul 13, 2004 at 06:11:22PM -0700, Carl Edwards wrote:
Hello,
I found a question about Oracle 2 MySQL replication in the
archive on Sep. 2001 but no mention since?
We have a department using Oracle 8.1.7 and I'm running MySQL
4.0 and neither of us wants to change :-)
I could
.
--- Jeremy Zawodny [EMAIL PROTECTED] wrote:
On Tue, Jul 13, 2004 at 06:11:22PM -0700, Carl
Edwards wrote:
Hello,
I found a question about Oracle 2 MySQL
replication in the
archive on Sep. 2001 but no mention since?
We have a department using Oracle 8.1.7 and I'm
running MySQL
4.0
Hello.
I've got a tricky problem on my hands. It seems very easy, but I can't figure it out
anyway,
and I've already spent quite some time trying to solve it! I'm doing the whole thing
under
MySQL 4.0, which seems to be the real problem here! It doesn't support my query I
wrote! Well, I
Remi Mikalsen wrote:
Car
-
| ID | IDBrand | IDModel | Year | Price |
-
Characteristic
| ID | Description |
CarCharacteristics
| IDCar | IDCharac |
Delphi, or
like the EMS DataPump tool.
Have fun! :-)
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 16, 2004 9:48 AM
To: [EMAIL PROTECTED]
Subject: ORACLE to MySQL migration
Hello colleagues,
I have to migrate a lot of ORACLE 8.1.7
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 commercial tool, otherwise a free software /
shared software should
be very appreciated
Can anyone
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 commercial
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 MySQL
Does anyone know any FREE tool to migrate Oracle databases and schema to MySQL 5.0? I
know one such tool, Oracle-to-mysql which is not free though.
Thanks
Raza
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
to migrate Oracle
databases and schema to MySQL 5.0? I know one such
tool, Oracle-to-mysql which is not free though.
Thanks
Raza
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED
I have a connection problem about MySql vs Oracle, I put an enter in TnsNames of BBDD
Mysql, using the object Oracle HS, and I get this error TNS
Packet checksum transport, Can you help me?
scripts for migrating from MySQL to Oracle. Is it possible
to export
an Oracle db to MySQL for even a simple functionality test? (This idea is kind of being
dismissed because of the information Oracle includes in its exports, but I'm asking
here in
case, as I would think you could query and obtain
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.)
:[EMAIL PROTECTED]]
Sent: Wednesday, 20 November 2002 20:24
To: Simon Windsor; [EMAIL PROTECTED]
Subject: RE: The dreaded move from Oracle to MySQL
Well, it looks like Simon has the best possible answer so far. I did a test
dump into a delimited file from Oracle and imported that using the LOAD
i'm running an oracle enterprise server in a test
environment for corereader, and i've noticed
that, although oracle sometimes takes a while to
wake up, after you have its attention, it throws
data at you very fast. sometimes a developer
does not use connections properly. in your case,
i
: )
excellent. i envy you.
i'd noticed the same thing about oracle. seems
to be a resource hog. the only thing worse that
i've seen is ms access. they make mysql look
very efficient.
hate to say much, since it appears that you know
what you're doing, but you might also take a look
at
Well, This is my first attempt at moving from Oracle to MySQL on such a
large scale and so far it isn't going well at all. We are running oracle
7.3.4.0.1 and MySQL 4.0.4-0 standard. We are moving 101 tables with a total
of 45 millon records over. I have tried several diffrent methods including
Scott Pippin
[EMAIL PROTECTED]
Wesley Brown [EMAIL PROTECTED] 11/20/02 11:24AM
Well, This is my first attempt at moving from Oracle to MySQL on such
a
large scale and so far it isn't going well at all. We are running
oracle
7.3.4.0.1 and MySQL 4.0.4-0 standard. We are moving 101 tables
Hi
I have moved huge amounts of data around in the past, from Oracle to Oracle,
and Oracle to MySQL.
The problems to consider are
- export speed
- load speed
It can take hours to download a large database, nevermind re-loading it into
another database. It is usually best to export the data
1 - 100 of 133 matches
Mail list logo