Skip to Main Content
Forums

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How SQL Developer works in database migration

pnshende_DBEApr 23 2013 — edited Apr 26 2013
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

Comments

thatJeffSmith-Oracle
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
pnshende_DBE
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
1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 24 2013
Added on Apr 23 2013
#developer, #in, #migration, #of, #sql, #sql-developer
2 comments
181 views