Database data replication with Oracle SQL Developer

Recently, because of the job needs, the boss asked the Oracle database on the server to migrate data to another server, I am not very familiar with Oracle, the migration of the database This is a matter of time spent, but also on the internet to inquire a lot of information. All kinds of moves are exhausted or not successfully migrated.

Finally, the spirit of the dead horse as a live horse doctor, the Oracle SQL Developer after the operation found that no command operation at all, with the Oracle SQL Developer can be very convenient to solve the problem.

I'll take the latest oracle12c as an example:

1: First, you need to download Oracle's client online: http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html

2: Installation

3:windows Open the Start menu to find the SQL Developer

，

4: Create a connection: Create your two databases that need to be migrated

5: Click Tools, select Database replication

6: Select the database you want to copy

7: Click Find. It takes a few minutes to wait here, and after the query is finished, click on the ">>" symbol and then next to the end, OK pull.

Database data replication with Oracle SQL Developer