VSS
Microsoft Visual SourceSafe, also called ‘VSS’, is a file-system-based source control tool from Microsoft.
VSS database/repository is the central place where all files, history, project structures, permission and user information are stored.
SQL Toolbelt
SQL Toolbelt, by Red Gate Limited made sql task easier for IT professional . SQL Toolbelt allows developers and DBAs to gain access to ALL the SQL Server tools RedGate currently produce, including new releases. This means that when you are working with SQL Server databases, you can finally have the most powerful set of tools right there to hand. Red Gate SQL Toolbelt provides all of Red Gate’s SQL Server tools in a single installer.
Features
SQL Compare Pro
Compare two SQL Server database schemas and generate a report on the differences between them. Synchronise changes between the databases by generating a SQL script that can update one of the databases to match the other. Compare and synchronise database snapshots and backups too. Additionally supports command line access for automated comparison and synchronisation.
SQL Data Compare Pro
Compare the data within two databases and generate a report on the differences between the two data sets. Synchronise changes from backup to live or live to live. Restore data at the row-level quickly and reliably. Additionally supports command line access for automated comparison and synchronisation.
SQL Packager
Package and compress your entire database schema and data or your SQL queries as an executable (.exe). Simplify and speed up the updating of your databases and application deployment by removing the need for manual scripting.
SQL Prompt Pro
SQL Prompt Pro supports code-completion, SQL formatting, SQL statement expansion (e.g. on INSERT and ALTER PROCEDURE statements), ‘SELECT *’ automatic expansion to a list of columns, instant schema information viewer and support for SQL snippets to quickly add commonly used SQL.
SQL Data Generator
Quickly generate quality test data for your databases that simulates production data. SQL Data Generator intelligently reads your column names and data types to automatically suggest the most appropriate test data for that column, choosing from over 60 built-in data generators. Quickly generate names, addresses, phone numbers, products and more or create your own generators. With foreign key support for generating consistent data across tables, automatic data conversion and command line support, SQL Data Generator provides a powerful solution for generating test data.
SQL Dependency Tracker
View your database object dependencies and relationships. Analyse the impact of changes to your relationships by graphically adding new objects, track dependencies across databases and customise the graphical diagrams by moving objects and changing colours and then print or export to PDF or XML.
SQL Refactor
SQL Refactor includes 11 refactorings to improve your SQL. Improve the readability and maintainability of your SQL scripts and database objects by automatically formatting them in a standard style – the SQL layout functionality contains over 30 options to suit the formatting style your company has adopted. Use Smart Rename to rename tables, views, stored procedures and user-defined functions and automatically update all references to these objects. Encapsulate a selection of code and convert it into a stored procedure, split a table into two and automatically update all references, summarise scripts to get a concise overview of their action, find unused variables and parameters, and more. Please note: SQL Refactor is an add-in to SQL Server Management Studio.
SQL Doc
Easily write, edit and output database documentation for your databases. Generate HTML documents, printable Word documents or CHM files of your documentation. The documentation supports multiple databases and all internal and cross-database dependencies.
SQL Backup Pro
SQL Backup Pro provides advanced compression algorithms with a powerful backup application to provide secure, small backup files. SQL Backup Pro is licensed per server. Backup Pro is even fault-tolerant – if the network goes down during a backup process, it will commence the backup once the network is restored, without file corruption. And with command-line support, you can completely automate your backups.
SQL Response
Monitoring tool for SQL Server. Receive alerts via the interface and/or emails about long running queries, SQL deadlocks, blocked processes and more, with relevant information to help diagnose the problem. Optionally capture SQL Profiler trace data if additional information is required. SQL Response starts working immediately with default settings for alerts and recommendations that can easily be configured and requires no special components on your SQL Servers. SQL Response is licensed per server.
SQL Multi Script Unlimited
Easily run multiple SQL scripts on multiple SQL servers. Script results are outputted in an easy to view grid/text based layout and can be exported to .csv or .txt files. Create customised lists of SQL Servers to make it easy to run scripts against them and set the execution order of multiple scripts.
SQL Comparison SDK
Compare and synchronise your database schemas and data from your own applications, programmatically, using the provided API. Fully automate all of your SQL comparison, syncing and packaging jobs and automate the installation, replication and verification of your databases. The SQL Comparison SDK represents the functionality of SQL Compare Pro, SQL Data Compare and SQL Packager.
SQL Object Level Recovery Native
Recover database objects such as tables, functions and stored procedures from native SQL Server backup files without the requirement of restoring full database backups.
Kaushikhalvadiya 