Oracle SQL Developer database copy

If the total size of the data you are migrating is under 200 MB, the simplest solution is to use the Oracle SQL Developer Database Copy function. Oracle SQL Developer is a no- cost GUI tool available from Oracle for data manipulation, development, and management. This easy-to-use, Java-based tool is available for Microsoft Windows, Linux, or Mac OS X. With this method, data transfer from a source database to a destination database is done directly, without any intermediary steps.

Because SQL Developer can handle a large number of objects, it can comfortably migrate small databases, even if the database contains numerous objects. You will need a reliable network connection between the source database and the destination database to use this method. Keep in mind that this method does not encrypt data during transfer.

To migrate a database using the Oracle SQL Developer Database Copy function, perform the following steps:

1. Install Oracle SQL Developer.

2. Connect to your source and destination databases.

3. From the Tools menu of Oracle SQL Developer, choose the Database Copy command to copy your data to your Amazon RDS or Amazon EC2 instance.

4. Follow the steps in the Database Copy Wizard. You can choose the objects you want to migrate and use filters to limit the data.

The following screenshot shows the Database Copy Wizard.

The Database Copy Wizard in the Oracle SQL Developer guides you through your data transfer