Find Code:
All Words
Any of the Words
Exact Phrase
Home
:
Code
:
Forums
:
Submit
:
Mailing List
:
About
:
Contact
Code
All
VB.NET
ASP.NET
C#
VB Classic
ASP Classic
Snippets
Popular
Resources
Submit Code
Forums
Articles
Tips
Links
Books
Contest
Link to us
SQL Database Upgrader
Author:
Richard Sorensen
E-mail:
Click to e-mail author
Website:
http://www.westernesse.com
Submitted:
1/24/2009
Version:
VB 2005
Compatibility:
VB 2005, VB 2008
Category:
Databases
Downloads:
7606
This application is used to upgrade an SQL database via an external script file or script text. Any type of database schema update can be done - adding, deleting, or modifying tables, fields and/or indexes, and the upgrade process can be run repeatedly without any issues - especially nice if you want to do SQL Insert/Delete/Update statements as part of a upgrade process, and perform them only under certain conditions. Anyone with a need to upgrade a database schema can make very effective use of this software, and it can also be used as a DLL or includable class so that you can incorporate a robust SQL upgrading tool directly into your own apps. If your app detects that there is a problem with the schema version (missing fields, etc.), the upgrader logic can be called to fix it. 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, especially for Access (setting properties such as AllowZeroLength, running compact/repair operations, etc., etc.). The DAO object model is used for Access allowing the full range of properties to be specified, while ADOX is used for other database types. The source code is included so that additional customizations can be added as desired. Documentation is also supplied explaing how to use the system.
Home
|
Forums
|
Submit
|
Books
|
Mailing List
|
Advertising
|
About
|
Contact
© 2024 A1VBCode. All rights reserved.
Legal disclaimer & terms of use
Privacy statement