Some one asked the other day about source control for SQL Server. I groaned as I knew what was coming next. Don't get me wrong, I believe in source code control as it has saved my rear-end many times. However, none of the tools do exactly what I want and nothing is seamlessly integrated within SQL Server. Anyhow, here is a list that I have from my research (in
no particular order).
SQLVSS is integration solution for SQL Version Control, it scripts database objects into Visual Source Safe, keeps records of different versions of database throughout the development process without storing a copy of the entire database each time. it simplified troubleshooting process by knowing exactly what has changed, and has the ability to roll back changes to prior version of the objects.
DB Ghost tools, in conjunction with any source control system, provide a true change management solution for SQL Server 2000, 2005 and 2008 code. It guarantees a full audit trail and complete database integrity by building and promoting databases directly from a source control system whilst preserving data in the target databases.
Embarcadero Change Manager offers database administrators and developers a powerful set of tools to simplify and automate the database change management lifecycle.
SQL Compare is the industry-standard tool for comparing and synchronizing SQL Server database schemas.
Change Director for SQL Server provides a powerful automated solution for managing and tracking schema changes to SQL Server databases.
Randolph is a new and unique solution that revolutionizes the way
version control and change management is done for SQL Server. It shifts
the responsibility for versioning from the users to the software.
SQL Source Control 2003 enables source control of code and
documentation of your databases. Full source control and documentation
versioning support is possible through integration with Visal Source
Safe.
SQLSourceSafe Integrates with both SQL
Server and Visual SourceSafe, providing an effective and effortless SQL code
version control management system for individuals and project teams to manage
SQL Server database objects. It also provides a development platform for
developers to work on and execute their SQL objects and scripts.
Good luck and I hope you find something that meets your needs. Oh and if you have any others to add, just us the contact page above and let me know!