JPH10187510A - Method and device for shifting data base - Google Patents

Abstract

PROBLEM TO BE SOLVED: To enable the work of data base shifting between different operating systems and to enable the shifting work concerning not only data but also table. SOLUTION: A table definition information file preparing part 10 prepares a table definition information file 12 storing definition information concerning the table of one data base, a data file preparing part 11 prepares a data file 13 storing the data of one data base, and a managing information registration file preparing part 25 prepares a managing information registration file 26 storing the managing information of the other data base. A table preparing part 27 stores a table stored in one data base into the other data base based on the table definition information file 22 and the managing information registration file 26. Besides, a data format transforming part 28 stores data stored in one data base into the other data base based on a data file 23 and the managing information registration file 26.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a database migration method and apparatus for migrating tables and data between two databases, and more particularly, to data migration between databases existing on different operating systems (OS). It is suitable.

[0002]

2. Description of the Related Art Conventionally, data transfer between different databases has been proposed, for example, in Japanese Patent Laid-Open No. 63-104.
No. 154 was disclosed. The technology disclosed in this publication performs file migration to a different volume. When a file to be migrated is input, an area corresponding to the input is secured in the destination volume, and the file to be migrated is saved to the evacuation volume. After the evacuation is performed once, the data is transferred to the transfer destination volume.

[0003]

However, the above-mentioned conventional database migration technology is aimed at data migration within the same operating system, and has not realized database migration between different operating systems. In particular, different operating systems have different data formats, so if data is simply migrated, the data to be migrated in the migration destination database cannot be used.

[0004] Further, the conventional database migration technology focuses on data migration, and a table for managing a collection of data has not been a migration target. In this,
Even though data could be migrated, the tables that manage it had to be recreated, resulting in a significant increase in time and burden on the database migration procedure. Accordingly, it is an object of the present invention to provide a database migration method and apparatus that enables database migration between different operating systems and that can perform migration of not only data but also tables.

[0005]

SUMMARY OF THE INVENTION The present invention applies to a method for migrating from one database to another. The problem is to create a table definition information file in which definition information relating to a table in one database is stored, and to create a management information registration file in which management information of the other database is stored. The problem is solved by storing the table stored in one database in the other database based on the definition information file and the management information registration file of the other database.

The present invention is also applied to a method for migrating a database from one database to another. The above-described problem is to create a data file storing data of one database, create a management information registration file storing management information of the other database, and create a data file of one database and a data file of the other database. The problem is solved by storing the data stored in one database in the other database based on the management information registration file of the database.

Further, the present invention is applied to an apparatus for migrating a database from one database to another database. The problem is to create a table definition information file creating means for creating a table definition information file in which definition information relating to a table in one database is stored, and to create a management information registration file in which management information of the other database is stored. This problem is solved by providing a management information registration file creating unit and a table creating unit that creates a table stored in one database based on the table definition information file and the management information registration file and stores the table in the other database. You.

Further, the present invention is applied to an apparatus for migrating a database from one database to another database. The object is to create a data file storing data of one database and a management information registration file generating a management information registration file storing management information of the other database. Means and a data format conversion means for converting the format of data stored in one database based on the data file and the management information registration file and storing the converted data in the other database are provided.

[0009]

Embodiments of the present invention will be described below in detail with reference to the drawings. FIG. 1 is a functional block diagram illustrating a schematic configuration of a database migration device according to an embodiment of the present invention. In this figure, 1 is a database system including a source database A, and 2 is a database system including a destination database B. Although these database systems 1 and 2 operate on different operating systems (OSs), it is not a necessary condition in the present invention that the source and destination databases A and B operate on different OSs.

The database system 1 includes a table definition information file creator 10, a data file creator 11, and a transmitter 14.

A table definition information file creator 10 functioning as a table definition information file creator creates a table definition information file 12 as shown in FIG. 2 based on the table stored in the database A. The table definition information file shown in FIG. 2 has a record indicating a table name, a record indicating the number of fields, and a record in which a field length, a field type, a field name, and the like for each field are stored.
The information stored in these records is hereinafter referred to as table definition information.

A data file creating section 11 functioning as a data file creating means creates a data file 13 as shown in FIG. 3 based on the data stored in the database A. The data file 13 shown in FIG. 3 has a record in which data of each field is stored. The data file 13 in the illustrated example is stored in a sequential organization.

The transmitting unit 14 transmits the table definition information file 12 and the data file 13 to the database system 2 via a communication line 30 such as a public telephone line based on a request (polling signal) from the database system 2 side. I do.

On the other hand, the database system 2 includes a receiving unit 24, a management information registration file creating unit 25, and a table creating unit 27.
And a data format conversion unit 28.

The receiving unit 24 transmits a polling signal for data transmission to the database system 1 when migrating the database, receives the data via the communication line 30, and stores the data as the table definition information file 22 and the data file 23. . The contents of the table definition information file 22 and the data file 23 are the same as those of the table definition information file 12 and the data file 13, respectively.

The management information registration file creation section 25, which functions as a management information registration file creation means, creates a management information registration file 26 as shown in FIG. The management information registration file 26 shown in FIG. 4 has records in which table names necessary for creating the database B are stored, and records in which management information of the database B is stored.

Table creator 27 functioning as table creator
Reads the data in the management information registration file 26 and the table definition information file 22, creates a table creation SQL statement, converts the table stored in the database A into a format compatible with the database B, and stores it in the database B. .

The data format conversion unit 28, which functions as a data format conversion unit, stores the data file 2
3 is read, converted into a data format suitable for the database B according to the table created by the table creating unit 27, and stored in the database B.

The database migration device shown in FIG. 1 is actually an arithmetic device such as a CPU, a storage device such as a ROM, a RAM, a magnetic disk, a magnetic tape, and a keyboard.
Each functional block shown in FIG. 1 is realized by executing a program stored in the ROM, including an input / output device such as a CRT and an interface circuit.

Next, referring to the flowchart of FIG.
The operation of the database migration device according to the present embodiment will be described. First, in step S1, the management information registration file creation unit 25 accesses the database B and creates the management information registration file 26. In step S2, the table definition information file creator 10 accesses the database A and creates the table definition information file 12. In step S3, the data file creator 11 accesses the database A to create the data file 13.

In step S4, the receiving means 24 sends a polling signal for a file read request to the transmitting means 14, and the transmitting means 14 transmits the table definition information file 12 in response to the polling signal. Read this. In step S5, the receiving unit 24 converts the file format of the table definition information file 12 so as to be suitable for the OS of the database system 2, and stores the converted file as the table definition information file 22.

In step S6, the receiving means 24 sends a polling signal for a file read request to the transmitting means 14, and the transmitting means 14 transmits the data file 13 in response to the polling signal. Read. In step S7, the receiving means 24 stores the data file 13 as the data file 23.

In step S8, the table creation unit 27 reads a table name from the table definition information file 22, and then in step S9, reads management information corresponding to the table name from the management information registration file 26. In step S10,
The table creator 27 reads from the table definition information file 22 data such as field names, field lengths, and field types corresponding to the table names read in step S8.

In step S11, a table creation SQL statement is created and executed based on the management information read in step S9, the field names read in step S10, and the like, thereby creating a table in the database B. Further, in step S12, the data format conversion unit reads data from the data file 23 one record at a time, divides the data according to the field length of the table created in step S11, and converts the code and format of the data according to the field type. And store it in the database B.

In step S13, it is determined whether or not the operations in steps S8 to S12 have been performed for all tables and data. If the determination is affirmed, the program shown in the flowchart of FIG. Step S
Returning to FIG. 8, the above-mentioned operation is performed for other tables and data.

[0026]

As is apparent from the above description, according to the present invention, it is possible to perform a database migration operation between operating systems having different data formats and the like, and also possible to migrate not only data but also tables. Become.

[Brief description of the drawings]

FIG. 1 is a functional block diagram showing a database migration device according to an embodiment of the present invention.

FIG. 2 is a diagram illustrating an example of a table definition information file according to an embodiment;

FIG. 3 is a diagram illustrating an example of a data file according to an embodiment;

FIG. 4 is a diagram illustrating an example of a management information registration file according to an embodiment.

FIG. 5 is a diagram illustrating an operation of the database migration device according to the embodiment;

[Explanation of symbols]

 A, B Database 1, 2 Database system 10 Table definition information file creation unit 11 Data file creation unit 12, 22 Table definition information file 13, 23 Data file 25 Management information registration file creation unit 26 Management information registration file 27 Table creation unit 28 Data format converter

Claims (4)

[Claims] 1. A method for migrating from one database to another database, wherein a table definition information file storing definition information relating to a table of one database is created, and management information of the other database is stored. Creating a management information registration file, and storing the table stored in one database in the other database based on the table definition information file of one database and the management information registration file of the other database. Database migration method to use. 2. A method for migrating data from one database to another database, wherein a data file storing data of one database is created and management information storing management information of the other database is created. A database migration method, wherein a registration file is created, and data stored in one database is stored in another database based on a data file of one database and a management information registration file of the other database. 3. An apparatus for migrating from one database to another database, a table definition information file creating means for creating a table definition information file storing definition information on a table of one database, and the other database Management information registration file creating means for creating a management information registration file storing the management information of the other, creating a table stored in one database based on the table definition information file and the management information registration file, A database migration device comprising: a table creation unit that stores the table in a database. 4. An apparatus for migrating from one database to another database, comprising: a data file creating means for creating a data file storing data of one database; and storing management information of the other database. Management information registration file creating means for creating a management information registration file, and converting the format of data stored in one database based on the data file and the management information registration file and storing the converted data in the other database A database migration device comprising: a data format conversion unit.