What are the best tools for Sql Server version control

Question

After reading this post, and the suggestion to use Team Edition for Database Professionals, I want to know is there any equivalent to this for SQL server 2008 / Visual stuio 2010 ultimate.

I'm looking for tool need to do all the thing that Jeff mention in his article:

• Create test data.
• Schema comparison.
• Data comparison.
• Database unit testing.
• Refactoring.
• Integrated T-SQL editor, a first class language construct in the IDE, just like C# and VB.NET.

For the full details look on this article: http://www.codinghorror.com/blog/2006/12/is-your-database-under-version-control.html

---

It seems that Visual Studio 2010 (and 2008) have very strong approach for this issue. I don't know if it the best option that exist, but it definitely good.

Here are Getting Started and Walkthrouge to learn how to start using it.

Answer 1

VS 2010 Premium and Ultimate have that built in (Expand database development link)

http://www.microsoft.com/visualstudio/en-us/products

In short, your database project gets checked into source control, and you deploy to production from the database project.

If you are looking for something that is to be used outside of VS2010 then redgate has a beta http://www.red-gate.com/Products/SQL_Source_Control/index.htm

Answer 2

Check for the below link :

http://www.codinghorror.com/blog/2006/12/is-your-database-under-version-control.html

Tools for the read gate
Sql Compare - Compares and synchronizes SQL database schemas. Sql Data Compare : Compares and synchronizes SQL database contents.

link of 14 day trial version : https://www.red-gate.com/dynamic/downloads/downloadform.aspx?download=sqlcompare

Answer 3

I use visual studio. eveloper database per developer, using the VIsual Studio 2010 Ultimate database tools - works nicely, "even" against TFS 2010 ;)

Answer 4

Did anyone of you ever have to care for the license costs of VS2010 Ultimate? It IS a good product, but you have to pay the price... ...which is beyond the 10.000 $, even € and SFR.