Migrate the database from Oracle to S Plus Advanced Server

Postgres Plus Advanced Server has two migration tools, one graphical interface and one command line interface. The following uses a graphical interface as an example.

Read more: Install ipvs Plus Advanced Server 9.2 on 64-bit RHEL6.2

1

First, you must create the user and peer permissions corresponding to the source database on the Postgres Plus Advanced Server of the target database system, and then create the target database.

Create user "USERNAMEXXX" withsuperuser password 'xxxxxx ';

Create database DatabaseNameowner = "TYTUTOR" encoding = 'utf8 ';

2

Copy the Oracle database driver to the following directory based on the jre version (the current environment is version 1.4 ):

/Opt/PostgresPlus/9.2AS/jre/lib/ext/ojdbc14.jar

3

Run ipvs Plus Advanced Server migration tool

 

4

5

Right-click servers and choose add migration source and target database.

6

1 2 3 Next Page