Title:
SqlDatabaseUpgraderSource
Download
Description: 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 an
To Search:
File list (Check if you may need any files):
ClassUtilitySqlUpgrade
......................\bin
......................\...\Debug
......................\...\Release
......................\...\.......\Interop.ADOX.dll
......................\...\.......\Interop.DAO.dll
......................\...\.......\Interop.JRO.dll
......................\...\.......\UtilitySqlUpgrade.dll
......................\...\.......\UtilitySqlUpgrade.pdb
......................\...\.......\UtilitySqlUpgrade.xml
......................\ClassUtilitySqlUpgrade.sln
......................\ClassUtilitySqlUpgrade.vbproj
......................\clsSqlUpgrade.vb
......................\My Project
......................\..........\Application.Designer.vb
......................\..........\Application.myapp
......................\..........\AssemblyInfo.vb
......................\..........\Resources.Designer.vb
......................\..........\Resources.resx
......................\..........\Settings.Designer.vb
......................\..........\Settings.settings
......................\obj
......................\...\ClassUtilitySqlUpgrade.vbproj.FileListAbsolute.txt
......................\...\Debug
......................\...\.....\build.force
......................\...\.....\ClassUtilitySqlUpgrade.vbproj.ResolveComReference.cache
......................\...\.....\Interop.ADOX.dll
......................\...\.....\TempPE
......................\...\.....\......\My Project.Resources.Designer.vb.dll
......................\...\Release
......................\...\.......\ClassUtilitySqlUpgrade.vbproj.GenerateResource.Cache
......................\...\.......\ClassUtilitySqlUpgrade.vbproj.ResolveComReference.cache
......................\...\.......\Interop.ADODB.dll
......................\...\.......\Interop.ADOX.dll
......................\...\.......\Interop.DAO.dll
......................\...\.......\Interop.JRO.dll
......................\...\.......\TempPE
......................\...\.......\......\My Project.Resources.Designer.vb.dll
......................\...\.......\UtilitySqlUpgrade.dll
......................\...\.......\UtilitySqlUpgrade.pdb
......................\...\.......\UtilitySqlUpgrade.Resources.resources
......................\...\.......\UtilitySqlUpgrade.xml
Resources
.........\Interop.ADOX.dll
.........\Interop.DAO.dll
.........\Interop.JRO.dll
.........\SampleUpgradeScript.txt
.........\SqlDatabaseUpgrader.doc
.........\SqlDatabaseUpgrader.exe
.........\UtilityCommonDialog.dll
.........\UtilityFileDirectory.dll
.........\UtilitySql.dll
.........\UtilitySqlUpgrade.dll
SqlDatabaseUpgrader
...................\ApplicationEvents.vb
...................\bin
...................\...\Debug
...................\...\.....\Interop.ADOX.dll
...................\...\.....\Interop.DAO.dll
...................\...\.....\SqlDatabaseUpgrader.vshost.exe
...................\...\.....\UtilityCommonDialog.dll
...................\...\.....\UtilityFileDirectory.dll
...................\...\.....\UtilityINI.dll
...................\...\.....\UtilitySql.dll
...................\...\Release
...................\...\.......\Interop.ADOX.dll
...................\...\.......\Interop.DAO.dll
...................\...\.......\Interop.JRO.dll
...................\...\.......\SqlDatabaseUpgrader.exe
...................\...\.......\SqlDatabaseUpgrader.pdb
...................\...\.......\SqlDatabaseUpgrader.xml
...................\...\.......\UtilityCommonDialog.dll
...................\...\.......\UtilityFileDirectory.dll
...................\...\.......\UtilitySql.dll
...................\clsSqlUpgrade.vb
...................\frmMain.designer.vb
...................\frmMain.resx
...................\frmMain.vb
...................\modUtilityErrorHandler.vb
...................\My Project
...................\..........\Application.Designer.vb
...................\..........\Application.myapp
...................\..........\AssemblyInfo.vb
...................\..........\Resources.Designer.vb
...................\..........\Resources.resx
...................\..........\Settings.Designer.vb
...................\..........\Settings.settings
...................\
