摘要： 提出了在两个孤立的SQL Server数据库之间的自动数据交换的方案，每个数据库都有输入接口和输出接口，在输出接口中生成操作一个数据库的SQL语句，然后通过自行制订的协议传输到另一个数据库发布SQL语句，对数据库中的输入接口进行同样的SQL操作，从而达到数据交换的目的。方案通过Visual Basic平台和串行接口通信进行了实现，其中包括自行制订的数据抽取模式和简单传输协议。所提的方案在一定程度上对解决“数据孤岛”问题也有所帮助。

关键词: 数据交换, 联邦数据库, Unicode码, 协议

Abstract: A data exchange automatic scheme between two isolated SQL Server databases is presented in this paper. There is input and output interface in each database. First, SQL sentence which manipulates a database is built in output interface; second, the SQL sentence is transmitted to the other database; then, the same manipulation to this database is executed using the SQL sentence in input interface. Consequently, the aim of data exchange is realized. The scheme is implemented on the Visual Basic and serial interface communication, including transmission protocol and data extract model. The scheme can also help to solve the problem of data island.

中图分类号: 

• TP311.13