SQL Server 2000与异构数据源之间的传输转换技术

Data translation between SQL Server 2000 and data sources with different structure

MicrosoftSQLServer2000是一个高性能的关系型数据库管理系统,具有客户机 服务器体系结构和强大的WEB功能,为企业应用提供了优良的扩展性和可靠性,能够满足大规模分布式计算环境的需要。SQLSever2000的数据传输转换技术,不仅可以生成资料仓库,还可以用来检索不同结构的数据源中的资料,对资料进行复杂转换并将资料存储到另一个资料源中,以便对数据进行析取、分析汇总,对数据仓库的海量数据存储和快速的检索技术提供了强大的支持。本文主要从SQLServer2000的工作原理和实例应用角度出发,介绍了用SQLServer2000中的TransactSQL编程和DTS(数据转换服务)等功能实现SQLServer与异构数据源之间传输转换的方法。

SQL Sever 2000 is a high-performance relation-type database managing system. It has clients/servers systems and powerful Web function in structures, which offers fine expansibility and reliability for using in the enterprises and also can satisfy the needs of large-scale distributed calculation. The data translation service can not only produce the materials warehouse, but also search for many kinds of data sources with different construct. It can translate one kind of data sources into another, facilitating the extract and gather of data sources. It can also support mass data and quick search technique. From the point of working principle and practical application, we introduce the method for translating data between SQL Server 2000 and data source with different construct by the function of Transact SQL Programming and Data Translation Service (DTS).