Forum Stats

  • 3,872,051 Users
  • 2,266,372 Discussions
  • 7,911,041 Comments

Discussions

How SQL Developer works in database migration

pnshende_DBE
pnshende_DBE Member Posts: 17
edited Apr 26, 2013 1:09AM in SQL Developer
Hi All,

Could any one please help me out to understand SQL Developer's roll during third party database migration into oracle ?, I am doing migration of DB2 database to Oracle using sql developer.

I wanted to know, How does exactly it work internally during migration to move data, structure and all ?, How should we deal with performance improvement when we are trying to migrate a database with bulky data ?

Please help me out to understand these things.

Thanks
Pravin

Answers

  • thatJeffSmith-Oracle
    thatJeffSmith-Oracle Distinguished Product Manager Posts: 8,866 Employee
    SQL Developer serves as your migration platform - it will connect to DB2 and capture the objects, help you rebuild them in Oracle, migrate the data over, and identify and translate your SQL.

    You can find more information for DB2 migrations here
    http://www.oracle.com/technetwork/products/migration/db2-084087.html
  • Hi Jeff,

    Thanks for your support !!!!!!

    But, Could you please tell me more about the actual process of migration takes place using sql developer ?

    I mean, How internally it works ?, like it takes data from source database into some temporary memory of machine on which we have sql developer installed and then push forward data to target database etc.


    Thanks
    Pravin
This discussion has been closed.