Exporting MySQL to Oracle

2008-07-03 Thread Arpotu
All, I have a customer who has been on MySQL for about 8 years, but they are moving their business elsewhere. They are moving their database into an Oracle shop, and want me to export their MySQL data into a format that's easily imported into Oracle. Does anyone have experience doing this, or ar

Re: Type conversion from Mysql to Oracle

2006-01-31 Thread Martijn Tonies
he Oracle database and I am trying to do that by writing a > small java program. The issue I am facing now is that I need to get > correctly the 'create table syntax' for Oracle and trying to keep the > formats of each column as close as possible to that in the Mysql table. &g

Re: Type conversion from Mysql to Oracle

2006-01-31 Thread Xiaobo Chen
base and I am trying to do that by writing a small java program. The issue I am facing now is that I need to get correctly the 'create table syntax' for Oracle and trying to keep the formats of each column as close as possible to that in the Mysql table. I couldn't find a FREE too

Re: Type conversion from Mysql to Oracle

2006-01-31 Thread Gleb Paharenko
Hello. In case you want to automate the process of migration have a look here: http://dev.mysql.com/doc/migration-toolkit/en/index.html There is a specific forum as well: http://forums.mysql.com/list.php?61 Xiaobo Chen wrote: > Hi, folks > > I am trying to convert some Mysql database into

Re: Type conversion from Mysql to Oracle

2006-01-31 Thread SGreen
"Xiaobo Chen" <[EMAIL PROTECTED]> wrote on 01/31/2006 09:45:00 AM: > Hi, folks > > I am trying to convert some Mysql database into Oracle. But their types > are not exactly match. Could any one give a hint? > > Thanks in advance! > > Xiaobo > > > -- > Faculty of Computer Science > Dalhousie

Re: Type conversion from Mysql to Oracle

2006-01-31 Thread Martijn Tonies
Hi, > I am trying to convert some Mysql database into Oracle. But their types > are not exactly match. Could any one give a hint? What types do you need to convert? Martijn Tonies Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL Server Upscene Productions http://www.upsc

Type conversion from Mysql to Oracle

2006-01-31 Thread Xiaobo Chen
Hi, folks I am trying to convert some Mysql database into Oracle. But their types are not exactly match. Could any one give a hint? Thanks in advance! Xiaobo -- Faculty of Computer Science Dalhousie University Halifax, Nova Scotia Canada -- MySQL General Mailing List For list archives: htt

RE: Mysql to Oracle migration

2005-09-05 Thread Karam Chand
L, but > you can do it from Mysql to oracle. Good luck! > > > -Original Message- > From: David Griffiths [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 01, 2005 2:17 PM > To: mysql@lists.mysql.com > Cc: [EMAIL PROTECTED] > Subject: Re: Mysql to Oracle mig

Re: Mysql to Oracle migration

2005-09-01 Thread Martijn Tonies
Clyde, > Does anyone know of a straght forward approach to migrate a > mysql(4.1.11) Schema to Oracle(9i release 2). > Also, please provide any best practices. Check out our database development IDE (running on Windows): Database Workbench - works with Oracle, MySQL, Firebird, InterBase and MS SQ

RE: Mysql to Oracle migration

2005-09-01 Thread Nguyen, Phong
Look at http://www.ispirer.com It is free and very good tool to do it. I did it from Oracle to MySQL, but you can do it from Mysql to oracle. Good luck! -Original Message- From: David Griffiths [mailto:[EMAIL PROTECTED] Sent: Thursday, September 01, 2005 2:17 PM To: mysql

Re: Mysql to Oracle migration

2005-09-01 Thread David Griffiths
You need to talk to Oracle, or look on an Oracle mailing list. People here are more concerned about migrating from Oracle to MySQL, rather than the other way around. There are probably lots of commercial tools out there that will do it (and compared to your Oracle licensing costs, they are pro

Mysql to Oracle migration

2005-09-01 Thread Clyde Lewis
Does anyone know of a straght forward approach to migrate a mysql(4.1.11) Schema to Oracle(9i release 2). Also, please provide any best practices. Thanks in advance. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PR

Re: mysql to oracle

2001-09-13 Thread Nick Willey
It's amazing what a search on google will turn up. First result when searching on "convert mysql to oracle" came up with: http://freshmeat.net/projects/m2o.pl/?highlight=m2o Nick - Original Message - From: "g g" <[EMAIL PROTECTED]> To: <[EMAIL PRO

Re: mysql to oracle

2001-09-13 Thread Ian Barwick
On Thursday 13 September 2001 19:16, g g wrote: > Hi. > > > Is anyone aware of any tool to convert a mysql > database to an oracle database? see: http://www.mysql.com/news/article-57.html Ian Barwick -- Ian Barwick - Developer - [EMAIL PROTECTED] akademie.de asp GmbH - http://www.akademie.d

Re: mysql to oracle

2001-09-13 Thread Jeremy Zawodny
On Thu, Sep 13, 2001 at 10:16:35AM -0700, g g wrote: > Hi. > > > Is anyone aware of any tool to convert a mysql database to an oracle > database? Oracle published one several months back. -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408

mysql to oracle

2001-09-13 Thread g g
Hi. Is anyone aware of any tool to convert a mysql database to an oracle database? thanks __ Terrorist Attacks on U.S. - How can you help? Donate cash, emergency relief information http://dailynews.yahoo.com/fc/US/Emergency_Information/ ---

Re: mysql to oracle conversion

2001-09-12 Thread Paul DuBois
At 8:31 AM -0700 9/12/01, Gene Gurevich wrote: >Hi. > >Is there a tool to convert a mysql database to oracle? > >thanks Check the Oracle web site. -- Paul DuBois, [EMAIL PROTECTED] - Before posting, please check: http://www

mysql to oracle conversion

2001-09-12 Thread Gene Gurevich
Hi. Is there a tool to convert a mysql database to oracle? thanks = __ Do You Yahoo!? Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger http://im.yahoo.com --

MySQL to Oracle schema conversion utility

2001-08-06 Thread Tim Bunce
Here's a MySQL to Oracle schema conversion utility that I've written. It's rather more functional than the m2o one posted recently. Tim. p.s. I could have implemented the SQL 'create table' parser using Parse::YAPP and the yacc syntax in the mysql source code but I

Re: Does anyone remember a MySQL to Oracle schema migration tool?

2001-07-14 Thread Paul Vallee
ECTED]> Cc: <[EMAIL PROTECTED]> Sent: Saturday, July 14, 2001 3:40 PM Subject: Does anyone remember a MySQL to Oracle schema migration tool? > I recall that maybe a month or four ago someone posted a message (on > the [EMAIL PROTECTED] list I think) saying that they'd written

Does anyone remember a MySQL to Oracle schema migration tool?

2001-07-14 Thread Tim Bunce
I recall that maybe a month or four ago someone posted a message (on the [EMAIL PROTECTED] list I think) saying that they'd written a utility to parse MySQL create table statements and write out equivalent Oracle create table statements. I remember replying to the message (possibly privately) and

Re: MySql to Oracle migration

2001-06-26 Thread Tim Bunce
On Tue, Jun 26, 2001 at 05:20:25PM -0400, Sherzod Ruzmetov wrote: > > Can someone explain me why is it waste of space??? No support for emulating autoincrement fields. No support for mysql specific types. No support for mysql specific functions. No support for ... In fact no support for almost

Re: MySql to Oracle migration

2001-06-26 Thread Sherzod Ruzmetov
there a way/tool to migrate the Application from MySql to Oracle > > > 8i? > > > > Oracle has one available on their web site... > > Mostly a waste of space. > > Tim. > > - > Before post

Re: MySql to Oracle migration

2001-06-26 Thread Tim Bunce
On Tue, Jun 12, 2001 at 04:42:42PM -0700, Jeremy Zawodny wrote: > On Tue, Jun 12, 2001 at 05:06:59PM -0500, Zhu George-CZZ010 wrote: > > > > Is there a way/tool to migrate the Application from MySql to Oracle > > 8i? > > Oracle has one available on their web site.

Re: MySql to Oracle migration

2001-06-12 Thread Jeremy Zawodny
On Tue, Jun 12, 2001 at 05:06:59PM -0500, Zhu George-CZZ010 wrote: > > Is there a way/tool to migrate the Application from MySql to Oracle > 8i? Oracle has one available on their web site... -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408)

MySql to Oracle migration

2001-06-12 Thread Zhu George-CZZ010
Is there a way/tool to migrate the Application from MySql to Oracle 8i? Thanks. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To

Re: Problem in migrating from mysql to Oracle

2001-06-06 Thread Rolf Hopkins
ay, June 07, 2001 3:37 Subject: Problem in migrating from mysql to Oracle > Hi, > > I am Rajani working as a Java Programmer. I was trying to migrate > from mysql to oracle and getting some kind of problems. I want to get some > kind of help from you and i really appreciate it. Her

Problem in migrating from mysql to Oracle

2001-06-06 Thread Penubothu, Rajani
Hi, I am Rajani working as a Java Programmer. I was trying to migrate from mysql to oracle and getting some kind of problems. I want to get some kind of help from you and i really appreciate it. Here is my explanation what i am exactly doing :-) I downloaded Oracle Migration

MYSQL to Oracle

2001-03-07 Thread Mashood Ahmed
Can anybody tell me what datatype exists in Oracle that is similar or could be used instead of BIGINT and TIMESTAMP. Also, what does the LIMIT # expression do in the select query. Can this be converted to be used in Oracle somehow? Thanks Totalise - the Users ISP -- To beco

SV: Exporting data from MySQL to Oracle

2001-02-14 Thread P?l Wester
OTECTED] > Emne: AW: Exporting data from MySQL to Oracle > > > Hi there, > > please check the oracle migration bench at the oracle technet. > > http://technet.oracle.com > > kind regards > denis mettler > > > -Urspr?ngliche Nachricht- > Von

AW: Exporting data from MySQL to Oracle

2001-02-13 Thread Denis Mettler
: Exporting data from MySQL to Oracle I couldn't find such product on Oracle's website. Noor -Original Message- From: Cal Evans [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 13, 2001 5:51 PM To: Noor Dawod; MySQL List Subject: RE: Exporting data from MySQL to Oracle Didn

RE: Exporting data from MySQL to Oracle

2001-02-13 Thread Noor Dawod
I couldn't find such product on Oracle's website. Noor -Original Message- From: Cal Evans [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 13, 2001 5:51 PM To: Noor Dawod; MySQL List Subject: RE: Exporting data from MySQL to Oracle Didn't Oracle just release a

RE: Exporting data from MySQL to Oracle

2001-02-13 Thread Cal Evans
Didn't Oracle just release a MySQL to Oracle migration kit? Check the Oracle website. Cal http://www.calevans.com -Original Message- From: Noor Dawod [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 13, 2001 8:41 AM To: MySQL List Subject: Exporting data from MySQL to Oracle

Exporting data from MySQL to Oracle

2001-02-13 Thread Noor Dawod
Hello, I'm having a problem exporting MySQL BLOB's to Oracle, especially those records that has "Carriage Return" or "Line Feed" characters in them. Has anyone done this before, and how did they do it? I need an immediate help in this subject. I'd appreciate you help very much. Thanks Noor -