“凑整法”在跨数据库产品批量数据迁移过程中的应用

Application of“rounding up”Method in the Process of Batch Data Migration of Cross-database Products

在跨数据库产品进行批量数据迁移时,有时会遇到一些数据记录因某个字段的数据最后一个字节或最后两个字节数据为不可见字符而无法迁移的情况,如果此类数据记录较多的话,将给数据迁移工作造成极大困扰和障碍。在本文中,作者采用"凑整法"实现了对此类批量数据迁移问题的解决,并通过两个典型的数据库产品进行了验证。

In the process of batch data migration across database products,sometimes some data records cannot be migrated because the last one byte or last two bytes of data of a field are invisible characters.If there are many records of such data,it will cause great troubles and obstacles to the data migration.In this paper,the author solves the problem of this kind of batch data migration by means of“rounding up”method and verifies it through two typical database products.