subject: How to solve all your problems regarding SQL Server Version Control [print this page] How to solve all your problems regarding SQL Server Version Control
Just like the weather, SQL coders and databases administrators deal with version control, but many of them do not do anything regarding it. SQL Server Version control means handling the versions of the objects developed and used in their SQL Server environments. Typically, this involves programmers and DBAs looking at scripts such as object creation development scripts into Visual Source Safe (VSS), or possibly a comparable version control software program, after they create them and then checking them out and back in again whenever they make modifications.
Most shops use version control to maintain track of their code - but why not consider the database? Making use of Randolph, you may always know your database development is fully versioned, that you lose absolutely nothing and can often go back - with virtually zero efforts on your part!
You will find several benefits that comes with establishing version control:
1. Control of the versions of objects which are used within the numerous environments
2. Databases object restoration
3. Alter tracking -- discovery of new or deleted objects
4. Distinction tracking -- detection of what has changed in an object
5. Background and rationale of object modifications
6. Marking of a version of database objects to build upgrade scripts
7. Simplified troubleshooting procedure by realizing specifically what has changed; and the ability to roll back adjustments to prior versions of the objects
An incredibly good SQL Server Version control tool will allow you to perform those activities:
- Complete save of the database's entities
- An effective GUI: Enables an powerful browsing through the database's entities - Their numerous attributes, their full background, and an easy access of every entity's entire source code at each and every stage in time
- Detailed reports: Know specifically what happened on your database across time
- Looking and filtering by means of entities
- Comparing Entities - what exactly has modified with every database entity at any point in time
- Integration with SourceSafe, Subversion and Microsoft Team Foundation Server
- Built-in scripting engine
- Not just the databases: complete monitoring of server level entities (Logins, Jobs...)
Using Randolph, you will always know your database development is fully versioned, that you lose nothing and can always go back with practically zero effort on your part!
