大数据背景下,SQL Server关系型数据库的存储容量暴涨,如何高效实现把SQL Server数据库中的数据迁移到HBase分布式数据库,是亟需解决的一个关键问题。讨论研究了2种数据库之间的差异之后,首先提出了数据库模式之间的转换,把SQL Server数据表的模式,按照不丢失关系的原则,转换成HBase下的表模式;然后根据不同的表间关系的数据迁移的规则,实现SQL Server数据库中的数据迁移到HBase数据库。因为表间转换关系和数据迁移规则的预定义,实现了一键完成数据的迁移。%Under the background of big data, SQL Server relational database storage capacity soared. How to efficiently realize the data migration in a SQL Server database to distributed database HBase is a key problem needed to solve. The paper discusses and researches the differences between the two kinds of database. First propose the conversion between the database schema, convert the SQL Server data table schema, according to the principle of not losing their relationship, into HBase table schema; then in compliance with the relationship between different tables of data migration, achieve the data migration in a SQL server database to HBase. Because of the predefined relationship between the table and data migration rules, the paper achieves a key to complete the migration of data.
展开▼