Database Version Control V2.1

Database Version Control V2.1 is a tool for developers to compare and maintain off site SQL Server databases assosiated with an application.

Dowload EXE Dowload \Help

Concept
While developing or maintaining an application, it is sometimes necessary to alter tables or fields in the application's database. When this application runs on several databases and servers, it is quite a task to keep all the databases in sink. This application enables the developer to make the changes to one database and his application will modify the other tables automatically.

Features

Script Maintenance
The developer can maintain scripts to run on the application databases and search through the scripts to see which object has been altered and when.
Error Logs
A log is automatically created of scripts that failed on a database. The server name, database name, the error description and time of execution is kept.
Analysis
With this tool the developer can see which databases on which servers have:
- Missing Tables
- Missing Fields
- Field Discrepancies
- Extra Tables
- Extra Fields
Password Control
A password can be set to allow only authorized personnel to apply database changes.
Script Generation
The application can create scripts to alter off site databases to bring them up to date

VB Example

Private Sub Command1_Click()
Dim oDB As clsDBUpdate
Set oDB = New clsDBUpdate
oDB.RegCode = "34743745-93693643"
oDB.AuthCode = "846743-673546"
oDB.Server = "(Local)"
oDB.Database = "AppDB"
oDB.MDBPath = "C:\AppPath"
oDB.SQLConstring = "Provider=SQLOLEDB.1;Password=sa;" & _
"Persist Security Info=True;User ID=sa;" & _
"Initial Catalog=AppDB;" & _
"Data Source=(Local)"
oDB.VersionField = "DBVersion"
oDB.VersionTable = "tDBVersion"
oDB.ConfirmUpdate = True
oDB.Password = "Password"
oDB.GetPassword = True
oDB.Compare
Set oDB = Nothing
End Sub

Screen Shots

Price $95.00

Inquiries