Red Gate Software SQL Source Control and TeamForge
Red Gate SQL Source Control makes database version control seamless. It links your databases to your existing source control system, so you can enjoy the benefits of source control without having to disrupt your workflow. In less than five minutes you can connect TeamForge Subversion repository to SQL Server and start developing your SQL databases in a source controlled environment.
Database development with the same rigor as source code management
For the first time you can develop SQL databases in a source controlled environment without using resource-heavy change management scripts. Simply and easily bring all the benefits of working in a source controlled environment, familiar to you from working with application code, to SQL database development:
Source control schema and data: Promote reuse for collaboration across team members
Develop against a real database: Better support Continual Integration and frequent release
Full Audit trail: Trace who changed what, when, and why for regulatory compliance
Distributed Model – Know who is making changes to the shared database; commit only your own changes by default
Get back to previous versions: View development history for easy access to specific database versions
Completely integrated into SSMS: SQL Server Management Studio (SSMS) is a tool included with Microsoft SQL Server for configuration and administration
Why SQL Source Control and CollabNet?
Red Gate Software produces highly usable, reliable tools that solve the problems of Data Base Administrators (DBAs) and developers. It doesn't matter whether your development team works with a central database or individual, local copies – SQL Source Control supports both a dedicated and a shared database development model.
When you link a database to source control, you must specify whether the database will be shared or dedicated. This allows SQL Source Control to better support your development model. For example, under a shared model, SQL Source Control displays information about which SQL Server user made which change. This means you can avoid committing another user's changes, and more easily see who is working on what. The ability to instantly keep database structure in synchronization across development, test and production environments instantly reduced the amount of work and potential for error.
In less than five minutes you can connect your TeamForge Subversion repository to SQL Server using SQL Source Control. You can keep track of who changed what, when, and why; improve change management and auditing; and easily share or reverse changes. SQL Source Control also stores a complete history of your updates to simplify database versioning, and provides a sandbox for risk–free experimenting.
"I have been using SVN for years as my main version control system. It was tricky to do SQL Server versioning with it, I had to export the scripts and save them inside the working copy directory. Now it's much easier with Red Gate's SQL Source Control. I can do the versioning and get the updated version right inside SQL Server Management Studio. It saves so much time and reduces the hassle in maintaining database versions within my team"
-Ferry Meidianto, Windows Phone MVP
