Chapter 12. Working with SQL Developer Migrations
Oracle SQL Developer Migrations is an integrated feature of Oracle SQL Developer that's used to migrate from some of the popular non-Oracle databases to Oracle. It provides users with a basic migration wizard (for small, less complex migrations) and an interactive migration alternative, where the stages of the migration are separated, allowing users to make changes to the objects and code at each stage. SQL Developer Migrations supports the migration of most database objects depending on the database in question (including procedures, functions, and the data in the tables) to Oracle. In this chapter, we'll look at preparing the SQL Developer environment, preparing the required Oracle database repository, and the steps involved in the migration process. Refer to http://apex.oracle.com for more information.
Migrating a database requires careful planning and preparation. In this chapter, we'll review the tool support...