The invention discloses a universal heterogeneous database data migration method, which comprises the following steps of: 1, registering a data source; 2, obtaining a database structure; 3, selectinga source database and a target database; step 4, querying whether a target database name exists in a table database table in the SQLite database or not by using the SELECT statement, and if not, creating a target database completely consistent with the source database structure; 5, selecting a data type mapping rule; 6, extracting database data from the source database; 7, judging whether to backup the data or not, and generating an XML file if the data is backed up; step 8, writing each row of data extracted in the step 7 into a target database; and 9, writing the data migration log into a migration log table of the SQLite database. The general heterogeneous database data migration method provided by the invention is suitable for common databases on the market, such as Oracle, SQLServer,Mysql, post, DM and Jinbao, and can effectively complete data migration.