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.
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
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.