Sql Server 版本控制的最佳工具是什么 [英] What are the best tools for Sql Server version control

问题描述

阅读this 帖子，以及使用 Team Edition for Database Professionals 的建议，我想知道 SQL server 2008/Visual stuio 2010 Ultimate 中是否有与此等效的版本.

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.

我正在寻找工具来完成 Jeff 在 他的文章:

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

• 创建测试数据.
• 架构比较.
• 数据比较.
• 数据库单元测试.
• 重构.
• 集成 T-SQL 编辑器，IDE 中的一流语言结构，就像 C# 和 VB.NET.

有关本文的完整详细信息:http://www.codinghorror.com/blog/2006/12/is-your-database-under-version-control.html

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

Visual Studio 2010(和 2008)似乎对这个问题有很强的处理方法.我不知道这是否是现有的最佳选择，但绝对不错.

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.

这里是入门和Walkthrouge 了解如何开始使用它.

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

推荐答案

VS 2010 Premium 和 Ultimate 已内置(扩展数据库开发链接)

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.

如果您正在寻找要在 VS2010 之外使用的东西，那么 redgate 有一个测试版http://www.red-gate.com/Products/SQL_Source_Control/index.htm

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

这篇关于Sql Server 版本控制的最佳工具是什么的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！