clssqlupgrade.vb

软件用于升级SQL数据库

Imports ADODB
Imports ADOX
Imports DAO
Imports JRO

Public Class clsSqlUpgrade
    '
    '   SQL Database Upgrade Utility
    '
    '   By:  	Richard B. Sorensen
    '           [e-mail]
    '           www.westernesse.com
    '
    '   This application is used to upgrade an SQL database via an external script file.
    '   Any type of database schema update can be done - adding, deleting, or modifying
    '   tables, fields and/or indexes.  Furthermore these routines can be used with any
    '   type of database (Access, MySql, Oracle, Postgres, SqlServer, etc.)  All that is
    '   necessary is to supply the database type and a connection string.  Many variations
    '   and features for specific database systems are implemented as a part of this app,
    '   and additional customizations can be added as desired.
    '
    '   If you make any enhancements, please send a copy of the code back to the author
    '   along with documentation indicating the changes that were made so that the
    '   additional functionality can be shared with others.
    '
    '   The database upgrade logic was written as a VB.Net class (clsSqlUpgrade.vb) with
    '   one public method (UpgradeDatabase).  The class module can be placed directly
    '   within a project, as has been done in the associated sample, or it can be compiled
    '   into a DLL by using the associated class library project.  The sample project
    '   contains logic to locate the script file for processing as well as an Access
    '   database file, but could easily be modified to work with another type of database
    '   simply be changing the connect string.  
    '
    '   The database upgrade code employs three Microsoft classes for the following
    '   purposes:
    '
    '       ADODB   (ActiveX Data Objects for Databases)