摘要: 介绍了数据库管理系统Microsoft SQL Server 2000 的数据转换服务(DTS),提出了其在实际应用中的某些不足之处,即不能定时、自动地将Xbase 数据库(dbase, Visual DBASE, Clipper, Foxbase, Foxpro and VFP 等)中的数据导入到Microsoft SQL Server 2000 数据库中。为此,本文开发了ActiveX 脚本和Java 数据转换应用程序,弥补了DTS 在此方面的缺陷,为企业应用系统集成在数据库层面的集成提供了一个方法,具有一定的实用价值。
关键词:
武汉理工大学计算机科学与技术学院,武汉 430000
Abstract: This paper introduces data transformation services of Microsoft SQL Server 2000, presents its limitation in application, that is, DTS cann’t scheduledly and automatically import the data of Xbase database(such as dbase, Visual DBASE, Clipper, Foxbase, Foxpro and VFP) to Microsoft SQL Server 2000. So ActiveX script and Java DTS application are developed to make up the shortcoming of DTS in the research. What is more, this solving method can be used in enterprise application integration(EAI) to integrate different software systems at the level of database
Key words:
Data transformation services(DTS); Meteadata; Enterprise application integration(EAI)
马永恒,熊前兴,杨金娥,李玉强,车 蕾,杨 健. 用 Java 开发数据转换服务的研究[J]. 计算机工程, 2006, 32(1): 267-269.
MA Yongheng, XIONG Qianxing, YANG Jine, LI Yuqiang, CHE Lei, YANG Jian. Research of Developing Data Transformation Service Using Java[J]. Computer Engineering, 2006, 32(1): 267-269.