Results 1 to 3 of 3

Thread: Transfer oracle to MySQL database

  1. #1
    PerryCollins is offline Senior Member
    Join Date
    Dec 2009
    Posts
    380
    Rep Power
    3

    Default Transfer oracle to MySQL database

    I want to convert an oracle database server into mySQL database server. I want third party tool software or any way that is inbuilt with oracle or mySQL database. My machine is running with this specifications-Oracle 9i with Linux4.if anybody knows how to transfer oracle database server into mySQL database server let me know. Thanks in advanced.

  2. #2
    SmithJohnson is offline Senior Member
    Join Date
    Dec 2009
    Posts
    364
    Rep Power
    3

    Default

    Features of oracle-to-MySQL :

    There are so lots of features it has to implementation of relocation, which are as follows :
    1- All of the data types are supported but BFILE and MLSLABEL cannot be applied.

    2- It can run with the all of the versions of UNIX and Windows MySQL servers.

    3- It is command line supported software.

    4- Would transfer the indexes with related attributes.

    5- able to migration of foreign keys.

    6- able to merge the Oracle data with a MySQL database.

    7- Transfer the Oracle contents to MySQL dump file.

    8- User friendly with wizard-style interface.

  3. #3
    Williamsjones is offline Senior Member
    Join Date
    Dec 2009
    Posts
    352
    Rep Power
    3

    Default

    The software use some approach to continue the transfer process. It works in this way, the software convert the Oracle data into a local MySQL dump file. It does not export the entire data at once. This dump file haves a few MySQL statements which are used to create all database tables and to fill up them with the data.

Similar Threads

  1. Setting Time Zone in oracle database
    By ThompsonHarris in forum Programming
    Replies: 2
    Last Post: 02-13-2010, 02:34 PM
  2. Oracle speaks of Sparc and MySQL
    By Christian Gabriel in forum Latest Hardware News
    Replies: 0
    Last Post: 01-29-2010, 08:51 AM
  3. Oracle ensures the future of MySQL
    By CALANTHA in forum Latest Hardware News
    Replies: 0
    Last Post: 12-16-2009, 09:38 AM
  4. Oracle increases prices on database options
    By John Petijohan in forum Latest Hardware News
    Replies: 0
    Last Post: 07-17-2009, 06:30 AM
  5. Optimize Your MySQL Database
    By Jacq44 in forum Applications
    Replies: 0
    Last Post: 12-10-2008, 06:29 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
SEO by SubmitEdge

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48