计算机工程与应用 ›› 2007, Vol. 43 ›› Issue (16): 186-188.

• 数据库与信息处理 • 上一篇    下一篇

基于SQL和ADO的用户数据库自动部署

曾 强,龚育昌   

  1. 中国科学技术大学 计算机系,合肥 230027
  • 收稿日期:1900-01-01 修回日期:1900-01-01 出版日期:2007-06-01 发布日期:2007-06-01
  • 通讯作者: 曾 强

Programming approach to arrange user database using SQL and ADO

ZENG Qiang,GONG Yu-chang   

  1. Department of Computer Science and Technology,University of Science and Technology of China,Hefei 230027,China
  • Received:1900-01-01 Revised:1900-01-01 Online:2007-06-01 Published:2007-06-01
  • Contact: ZENG Qiang

摘要: 现有安装程序(如Installsheild、InstallFactory等)在解决用户数据库的自动部署时,操作步骤非常复杂和繁琐,不易掌握和使用。针对这一问题,提出了利用SQL和ADO编程来实现用户数据库的自动部署的方法。该方法对于大多数数据库管理系统(如SQL Server、Oracle、Sybase、DB2等)具有通用性;并且没有编程语言的限制,对VC、VJ、VB、Delphi等都适用,使用简便,具有较高的实用性。

Abstract: For arranging user database,it is trivially and complicated for users to use existing installers such as Installsheild or InstallFactory.To resolve the problem above a simple and easy method using SQL and ADO is proposed in this paper.The method is not only universal for different database such as SQL Server,Oracle,Sybase and DB2,but also universal in different programming language such as VB,VC,VJ,and Delphi,so it is very useful.