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 fie
> 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
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
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.
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:
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 g
joins?
Oracle will sell it if they can convince the customer.
Just some thoughts.
- Original Message -
From: "Tom Worster"
To: "mos" ;
Sent: Sunday, January 31, 2010 7:39 PM
Subject: Re: 50 things to know before migrating from Oracle to MySQL
On 1/29/10 5:0
On 1/29/10 5:03 PM, "mos" 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 administrators
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?
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 mother
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 goa
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
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-ty
... 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:http://lists.mysql.com/mysql?unsub=arc
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 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.
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
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 ne
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 a
On 1/28/10 5: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?
as a relatively unsophisticated dbms user (just dynamic web site back end),
i thought it was very interesti
Doesn't Google run MySQL ?
Hmmm
On Thu, Jan 28, 2010 at 4:56 PM, Carl 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
>
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"
To:
Cc: "'changuno '"
Sent: Thursday, January 28, 2010 5:4
> -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
>
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
To
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
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 a
anguno wrote:
> Hi folks,
>
> Read a blog which states 50 things to know before migrating from Oracle to
> MySQL. Any comments on this?
>
> 1. Subqueries are poorly optimized.
> 2. Complex queries are a weak point.
> 3. The query executioner (aka query optimize
Hi folks,
Read a blog which states 50 things to know before migrating from Oracle to
MySQL. Any comments on this?
1. Subqueries are poorly optimized.
2. Complex queries are a weak point.
3. The query executioner (aka query optimizer / planner) is less
sophisticated.
4. Performance
[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 r
-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
[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 aren'
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:
selec
> >> 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 or fun
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
> > 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 no
> > oth
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 no
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 o
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 In
: 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
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 of
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 as Ora
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
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. Can you please pass on the url.
regards
anandkl
--
MySQL General Mailing Li
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 Int
possibility of the error? Any Suggestions?
Best,
Sri
-Original Message-
From: Arun Kumar PG [mailto:[EMAIL PROTECTED]
Sent: Monday, March 12, 2007 3:37 AM
To: Ananda Kumar
Cc: mysql@lists.mysql.com
Subject: Re: tool to migrate data from oracle to mysql
http://www.mysql.com/products/tools
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
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
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
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 w
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
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 numb
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 use
Hi Green,
Thanks for the email. As you said, i am also trying other resources to find
answers for this question. Just waiting for their answers.
Since the answers were little urgent, i was little curious.
I will let you all know once i find any solution to this.
regards
anandkl
On 9/23/05, [EM
Ananda Kumar <[EMAIL PROTECTED]> wrote on 09/23/2005 05:25:10 AM:
> 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
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
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
w. I
believe there is also some paging 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:
mysql@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
> -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
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 of record
;:
> > > > > Hi Friends,
> > > > > Can you please help me on this.
> > > > > regards
> > > > > anandkl
> > > > >
> > > > > -- Forwarded message --
> > > > > From: Ananda Kumar &l
5/9/21, Ananda Kumar < [EMAIL PROTECTED]>:
> > > > Hi Friends,
> > > > Can you please help me on this.
> > > > regards
> > > > anandkl
> > > >
> > > > -- Forwarded message --
> > > > From: Ananda Kumar <
/05, Pooly <[EMAIL PROTECTED]> wrote:
> >
> > 2005/9/21, Ananda Kumar <[EMAIL PROTECTED]>:
> > > Hi Friends,
> > > Can you please help me on this.
> > > regards
> > > anandkl
> > >
> > > -- Forwarded message ------
&
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
> >
> >
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 oracl
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
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/odbc.i
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
PROTECTED]
Subject: RE: 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 segm
Subject: RE: 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 ?.
If I remember correctly Views don't appe
help me how to do this in mysql?.
Thanks,
Narasimha
-Original Message-
From: martin fasani [mailto:[EMAIL PROTECTED]
Sent: Tue 10/5/2004 4:32 PM
To: [EMAIL PROTECTED]
Cc:
Subject: Migrating from Oracle to mySql [online stats
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
kno
Remi Mikalsen wrote:
Car
-
| ID | IDBrand | IDModel | Year | Price |
-
Characteristic
| ID | Description |
CarCharacteristics
| IDCar | IDCharac |
-
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 didn'
land
tools like 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
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 lo
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
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 gi
nyone 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
> T
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.
> 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
I have searched the archives but have not found an answer to this.
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.)
1. The primary question/issue here is that with the "complexity" of our
: )
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 r
> 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
t; And (I quote) If one uses sockets to connect to the MySQL server, the
> server will open and
> read the text file directly.
>
> As I said, these are ideas & I hope it will at least give you some ideas
> too...
>
> Cheers,
>
> Andrew
>
>
>
>
> -Original
the way that i would do it.
> 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.
--Original Message-
From: Wesley Brown [mailto:[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
> Can you explain this procedure to me a little better or point me to
> something I can read? I still have to convince the person who manages the
> Oracle box to open up an NFS share.
The point of using NFS to transfer the files from the oracle box to the
mysql box is to avoid copying the data twi
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
command in mysql and sustaned about 11,000 inserts a second. This is with no
indexes on the mysql tables at all. I have also tried using the dbtools
im
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
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
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 incl
more detail please e-mail me directly.
Regards
Peter Goggin
- Original Message -
From: "RP C987342" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, September 19, 2002 4:29 PM
Subject: Oracle to Mysql
> hello
>
> I want to move my database fr
hello
I want to move my database from Oracle to MySql, I am new to MySql.
Is there any documentation listing the important issues involved
in the migration?
thanks,
_
MSN Photos is the easiest way to share and print your photos
ision Support Services
913.315.4576
913.226.3090 PCS
[EMAIL PROTECTED]
-Original Message-
From: francois.joubert [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 16, 2002 8:46 AM
To: mysql
Subject: Migrating Oracle To MySQL
Hi
I am new to the world of databases. We will be installi
> From: Francois Joubert [mailto:[EMAIL PROTECTED]]
> Sent: 16 August 2002 14:46
> To: MySQL List
> Subject: Migrating Oracle To MySQL
>
> Hi
>
> I am new to the world of databases. We will be installing an Oracle9i
> database shortly as the backend for our current f
. Is it a scary job transferring data from Oracle to
MySQL? What tools are available to assist in such a process.
Thanks.
Francois
--
Imagination 25 Store Street South Crescent London WC1E 7BL England |
Tel +44 20
Chugh,
Tuesday, August 13, 2002, 2:40:54 PM, you wrote:
CS> We are in the process of transferring our databse from Oracle to MYSQL.
CS> Oracle has some triggers to insert into the table on some events. How can we
CS> handle this dynamic insertion of triggers in MYSQL.
CS> Also
We are in the process of transferring our databse from Oracle to MYSQL.
Oracle has some triggers to insert into the table on some events. How can we
handle this dynamic insertion of triggers in MYSQL.
Also what is the alternative for check constraint of Oracle in MYSQL
1 - 100 of 111 matches
Mail list logo
