The invention discloses a data cross-platform migration method and a data cross-platform migration device, which are used for
data migration between different
database systems. The device comprises a
source data information module, a target
data information module, a conversion module, an
SQL (Structured
Query Language) Engine, a data packet encapsulation, transmission and analysis module and an
SQL statement execution module. The information on a
source data platform and the information on a target
data platform are described through the
source data information module and the target
data information module, a table is acquired from the source
database to generate a Table object, the Table object is subjected to format conversion by the conversion module according to an
XML (
Extensible Markup Language) file for describing the mapping relation of fields between the databases, the converted information is constructed into an
SQL statement by the SQL Engine, the SQL statement is encapsulated and transmitted to the platform where the
target database is positioned, and the SQL statement is executed on the target platform to finish
data migration. The method and the device realize smooth and lossless migration of the data between different databases of a heterogeneous platform.