SQL Developer enables database migrations in an interactive manner, that is, users need to set up connections, click through the migration wizard and choose desired options to perform the migrations. This method works well for migrating a very small number of databases. But many organizations have dozens and hundreds of databases, if not thousands, that they need to migrate. Using the SQL Developer GUI to migrate one database at a time is not an optimal method for 'en masse migrations'. This is where using a factory approach to migrations comes in handy. The factory approach to database migrations involves performing database migrations in a batch, non-interactive manner so that users do not have to sit and wait for the migration processes to be completed to click through the GUI.
To facilitate database migrations (schema and data) in a batch mode for many databases at a time, SQL Developer offers a command line interface...