StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POWhat are the best tools for Sql Server version control
text
Body
copied!<p>After reading <a href="http://www.codinghorror.com/blog/2006/12/is-your-database-under-version-control.html" rel="nofollow noreferrer">this</a> post, and the suggestion to use <code>Team Edition for Database Professionals</code>, I want to know is there any equivalent to this for SQL server 2008 / Visual stuio 2010 ultimate.</p> <p>I'm looking for tool need to do all the thing that Jeff mention in <a href="http://www.codinghorror.com/blog/2006/12/is-your-database-under-version-control.html" rel="nofollow noreferrer">his</a> article:</p> <ul> <li>Create test data.</li> <li>Schema comparison.</li> <li>Data comparison.</li> <li>Database unit testing.</li> <li>Refactoring.</li> <li>Integrated T-SQL editor, a first class language construct in the IDE, just like C# and VB.NET.</li> </ul> <p>For the full details look on this article: <a href="http://www.codinghorror.com/blog/2006/12/is-your-database-under-version-control.html" rel="nofollow noreferrer">http://www.codinghorror.com/blog/2006/12/is-your-database-under-version-control.html</a></p> <hr> <p>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.</p> <p>Here are <a href="http://msdn.microsoft.com/en-us/library/dd193266.aspx" rel="nofollow noreferrer">Getting Started</a> and <a href="http://msdn.microsoft.com/en-us/library/aa833258.aspx" rel="nofollow noreferrer">Walkthrouge</a> to learn how to start using it.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload