[1]谌新年,余新宇..SQL Server和国产数据库之间数据移植研究[J].郑州大学学报(工学版),2007,28(03):95-97.[doi:10.3969/j.issn.1671-6833.2007.03.025]
　New Years Eve,Yu Xinyu.Research on data migration between SQL Server and domestic databases[J].Journal of Zhengzhou University (Engineering Science),2007,28(03):95-97.[doi:10.3969/j.issn.1671-6833.2007.03.025]

点击复制

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

分享到：

《郑州大学学报(工学版)》[ISSN:1671-6833/CN:41-1339/T]

卷:

28

期数:

2007年03期

页码:

95-97

栏目:

出版日期:

1900-01-01

文章信息/Info

Title:

Research on data migration between SQL Server and domestic databases

作者:

谌新年; 余新宇.

湖南工程学院,计算机科学与技术系,湖南,湘潭,411104, 湖南工程学院,计算机科学与技术系,湖南,湘潭,411104

Author(s):

New Year’s Eve; Yu Xinyu

关键词:

SQL Server;  国产数据库;  数据移植

Keywords:

SQL Server;  domestic database;  Data portability

DOI:

10.3969/j.issn.1671-6833.2007.03.025

文献标志码:

A

摘要:

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

Abstract:

Firstly, the importance of database in software system development is analyzed, the gap between domestic data and foreign large databases is pointed out, and SQL Server 2000 and domestic databases are mainly compared and analyzed from several aspects such as data types, variable declarations and assignments, stored procedure definitions, executions and some SQL statements, with SQL Server 2000 and domestic databases - Kingbase ES3.1. Openbase et al. propose solutions to the problem of data portability between them.

常用功能