SQL Server和国产数据库之间数据移植研究

Research of Data Transplantation between SQL Server and Domestic Database

首先分析了数据库在软件系统开发中的重要性,指出国产数据与国外大型数据库之间的差距,主要对SQL Server2000和国产数据库从数据类型、变量声明以及赋值、存储过程的定义、执行和部分SQL语句等几个方面进行比较、分析,以SQL Server2000和国产数据库-Kingbase Es3.1、Openbase等为例为它们之间的数据移植问题提出了解决方案.

The importance of database in software development was analyzed,and the gap between domestic database and the famous abroad database was presented.The difference between domestic database and SQL Server was discussed from data types,variables statements and assignment,the definition of store-process and implementation,and part of SQL,etc.Taking SQL Server 2000 and KINGBASE Es 3.0 for example,the resolve approach of data transplantation was presented.