Source Control

SQLDBcontrol offers source control for Microsoft® SQL Server™ stored procedures views and user-defined functions that is tightly integrated with the database objects. In addition to being able to check database objects in and out, whenever an object is checked-in, the object's definition is automatically updated on the SQL Server™ database.

In other words, there is no need to copy the source-control version to the corresponding database - SQLDBcontrol does that for you automatically.

Not only this but SQLDBcontrol compares itself with the target database and lets you know whether the latest version of a database object is the same as the current source control version held in SQLDBcontrol.

This means that if someone changes an object’s definition directly on the database, without using SQLDBcontrol, you will be made aware of it.

Every change made to an object’s definition whilst using SQLDBcontrol is recorded, providing a history of changes.

This allows you to track the changes of any given object and if necessary, rollback to a prior version of an object’s definition.

SQLDBControl’ssource control functionality enables database administrators and managers to know about every change that occurs on their databases. It also provides database developers with the reassurance that another developer within SQLDBcontrol cannot alter an object that is currently checked-out.

SQL Server™ - integrated source control

• Detects when changes have been made to database objects regardless of whether the objects were edited through SQLDBcontrol or not.
• Object-level permissions are maintained as part of the object's definition.
• User security is tied in to SQL Server's security.
• Changes made to database objects using SQLDBcontrol are automatically applied to the corresponding object's database.
• All changes made are recorded as part of the object's change history.
• The entire history of changes for any object is instantly viewable.
• The differences between an object and its historical versions can be seen side by side and an object's definition can be rolled back to any one of its previous historical versions.