CN105677738A - Universal method for migrating heterogeneous relational database - Google Patents

Abstract

The invention relates to the technical field of software development, and in particular to a universal method for migrating heterogeneous relational database. The method includes the following steps: compiling operations of each common relational data, such as connecting, increasing, deleting, searching, and modifying, and encapsulating a set of public JAVA application; when data need migration, operation personnel selects corresponding one by one relations between a source database, tables requiring reading and a target database on an operation interface, then selecting synchronous operation. The method of the invention provides a rapid, efficient and convenient heterogeneous relational database migration method, and can be widely applied to data migration of any type of common heterogeneous relational database.

Description

A kind of method of general isomeric relationship type database data migration

Technical field

The present invention relates to technical field of software development, a kind of method being specifically related to general isomeric relationship type database data migration.

Background technology

What Business survival leaned on is profit, and without profit, an enterprise cannot survive. The method improving enterprise profit is varied, and being summarized as is exactly in short " raising work efficiency ", and only work efficiency is up, and enterprise could obtain maximum generation with minimum putting into, and had both generated profit maximization.

In enterprise, data base administrator, run into the situations such as system upgrade particularly heterogeneous database migration, it is necessary to writing substantial amounts of SQL script, the bothersome effort of traditional method, data accuracy is low, extremely inefficient. Method used in the present invention, it is possible to migrating required time decreased 90%, greatly improve work efficiency.

Summary of the invention

Present invention solves the technical problem that a kind of method being in that to provide general isomeric relationship type database data migration; For data base administrator provide a kind of faster, efficient, facilitate heterogeneous database moving method.

This invention address that the technical scheme of above-mentioned technical problem is:

Described method be first to the connection of various conventional relational datas, increase, delete, look into, change operation, write and packaged a set of public JAVA program; When needs migrate data, operator choose the one-to-one relationship between the table that source database, the table needing reading and target database, needs write on operation interface, then select to carry out simultaneously operating.

Described method comprises the steps:

1st step, first write a set of public each conventional coefficient of relationship JAVA method according to storehouse, to the connection of conventional relational data, increase, delete, look into, change operation and be packaged;

2nd step, create storehouse and table relationship by objective (RBO) type data base, first create table major key, index, constraint etc.;

3rd step, operation interface on fill in: source database IP, source database user name, source database password, source data library name, need read table and target database IP, target database user name, target database password, target data library name, need write table between corresponding relation;

" synchronization " button on 4th step, clicking operation interface, background program arranges migration data according to what choose;

5th step, back within the 3rd step, until the whole table of data base has migrated;

6th step, at operation interface testing data transport number;

7th step, create table major key, index, constraint etc. in target database.

The invention has the beneficial effects as follows: isomeric relationship type database data migration function, it is possible to allow and realize Data Migration between different relevant databases, for data base administrator provide a kind of faster, efficient, facilitate heterogeneous database moving method. Reduce the workload of Data Migration, Data Migration error rate.

Accompanying drawing explanation

Below in conjunction with accompanying drawing, the present invention is further described:

Fig. 1 is general isomeric relationship type database migration flow chart.

Detailed description of the invention

The present invention passes through the connection to various conventional relational datas, increases, deletes, looks into, changes operation, write and packaged a set of public JAVA program, when needs do migration data, operator choose the one-to-one relationship between the table that source database, the table needing reading and target database, needs write on operation interface, click " synchronization " button, can easily realize the Data Migration of two heterogeneous databases.

In detail below for mysql database data migration to oracle database.

As shown in Figure 1, it is mysql database data migration to oracle database flow chart; General isomeric relationship type database migration comprises the steps:

1st step, first write a set of public each conventional coefficient of relationship JAVA method according to storehouse, to the connection of conventional relational data, increase, delete, look into, change operation and be packaged;

2nd step, create storehouse and table at oracle relevant database, first create table major key, index, constraint etc.;

3rd step, operation interface on fill in: mysql data base's IP, mysql database user name, mysql database password, mysql database name, need read table and oracle database IP, oracle database user name, oracle database password, oracle database name, need write table between corresponding relation;

" synchronization " button on 4th step, clicking operation interface, background program arranges migration data according to what choose;

5th step, back within the 3rd step, until the whole table of data base has migrated;

6th step, at operation interface testing data transport number;

7th step, create table major key, index, constraint etc. in oracle database.

Claims (2)

1. the method for isomeric relationship type database data migration one kind general, it is characterised in that: described method be first to the connection of various conventional relational datas, increase, delete, look into, change operation, write and packaged a set of public JAVA program; When needs migrate data, operator choose the one-to-one relationship between the table that source database, the table needing reading and target database, needs write on operation interface, then select to carry out simultaneously operating.

2. the method for general isomeric relationship type database data migration according to claim 1, it is characterised in that: described method comprises the steps:

1st step, first write a set of public each conventional coefficient of relationship JAVA method according to storehouse, to the connection of conventional relational data, increase, delete, look into, change operation and be packaged;

2nd step, create storehouse and table relationship by objective (RBO) type data base, first create table major key, index, constraint etc.;

3rd step, operation interface on fill in: source database IP, source database user name, source database password, source data library name, need read table and target database IP, target database user name, target database password, target data library name, need write table between corresponding relation;

" synchronization " button on 4th step, clicking operation interface, background program arranges migration data according to what choose;

5th step, back within the 3rd step, until the whole table of data base has migrated;

6th step, at operation interface testing data transport number;

7th step, create table major key, index, constraint etc. in target database.