SQL Source Control - versioning for Source Safe and SQL Server documentation

Visual SourceSafe integration and comprehensive database documentation.
The awarded solution avaliable for Microsoft SQL Server developers, that enables source control and comprehensive documentation of your databases by Visual SourceSafe integration.

Manage Database Items

Database items are the connection elements you work with in SQL Source Control™ 2003. These are:

tables
views
stored procedures
triggers
functions

They are accessible through Tables, Views, Stored Procedures, Triggers and Functions treeview nodes, under each Connection in Connections group.

Fig.1 Connections and their subnodes

Create, Edit and Remove database items

By double-clicking selected database item in a treeview you open its MDI window, containing SQL code (Design tab) and Documentation (Documentation tab).

Fig.2 Database Item window, SQL code tab

When item is checked out, you may edit its code, taking advantage of easy to use SQL code editor, that features full syntax color coding to improve the readability of complex statements. It also features all needed editing functionality:

unlimited Undo/Redo
Cut/Copy/Paste clipboard access
Find/Replace with regular expressions support
line numbering (decimal, binary, hex, octal)
show white space
go to line number
automatic line indent
automatic language keywords case correction

and many more.

When item is not checked out by you, you may preview its code, but you are not allowed to make any changes.

Table Designer

You may create and edit existing tables in your database directly from SQL Source Control.

This feature allows you to:

create new tables and edit existing tables
manage table columns and columns properties
manage indexes
manage relationships
manage constraints
manage permissions
browse table dependencies

Fig.3 Table Designer tab

Free query execution

With a built-in Skilled Query Analyzer you may:

Run selected SQL code directly in Stored Procedures, Views, Functions and Triggers editor
Easy execute Stored Procedures and Functions and see the results, preview Views contents
Run any piece of SQL code against SQL Server.
Easy to use tabbed grouping of multiple editing windows.
Benefit from all our SQL edit features - Intellisense code completion, bookmarks, macros, line numbering and more

Fig.3 Skilled Query Analyzer window

Documentation is covered in Managing Documentation section.

You may also Add new database items and Delete existing ones.

next feature - teamwork development...

SQL Diagrams.
This application gives you a graphical overview of your SQL Server database solution, it visualizes all relationships between all database objects. .

Read more

DB tools recommendations.
Where is a requirement, there also is a tool that meets that requirement. Let us find you a perfect tool!

Read more

Database Solutions.
If you have a problem or you are in a need of a cost-effective IT solution for your business, we are here to help.

Read more