Migration apparatus which convert database of mainframe system into database of open system and method for thereof

A migration apparatus for converting a database of a mainframe system into an appropriate database for an open system, the migration apparatus comprising:

• a computer system comprising at least one processor and at least one computer readable medium, the at least one computer-readable medium comprising:
• a data extraction module connected with a database of the mainframe system and extracting data composed of Extended Binary Coded Decimal Interchange Code (EBCDIC) in binary format;
• a code conversion module converting the extracted EBCDIC data into American Standard Code for Information Interchange (ASCII) code, full-width characters being converted into half-width characters corresponding to ASCII code using a previously set full-width/half-width conversion table;
• and
• a data transfer module for transferring data which has been converted into ASCII code by the code conversion module, the data transfer module configured to:
• generate a temporary table in the database of the open system;
• store the data, in the form of ASCII code, in the temporary table;
• replace all full-width characters enclosed in the data stored in the temporary table with corresponding half-width characters, as determined by the code conversion module;
• and
• transfer the data stored in the temporary table to a database previously built in the open system to correspond to the database of the mainframe system;
• wherein at least the data transfer module and code conversion module are external to both of the mainframe system and the open system;
• wherein the code conversion module converts a value of ‘00’ into an ASCII code corresponding to space during code conversion;
• and
• wherein the code conversion module converts a character string including shift-outs (SOs) and shift-ins (Sls) by removing the SOs and Sls from the character string and then moving letters behind the SOs forward to fill empty spaces leftover by removing the SOs and the Sls during code conversion.