记住的工具，放弃对数据库所做的更改 [英] tools to remeber, discard changes you do to your database

问题描述

是否有任何工具可以让您知道您对SQL SERVER数据库所做的更改(例如，删除一列)，其以前的状态是什么?
我想要一个可以告诉我从以前的数据库状态到当前状态的工具，例如，我已经更改了列的类型.

Is there any tool that permits to know the changes you do to your SQL SERVER database( for example deleting one column) from its previous states?
I want the tool that it could tell me that from the previous state of database to the current state of it i have changed the type of the column for example.
It would be helpful if the tool can discard the changes.

推荐答案

您正在寻找数据库的源代码或版本控制.
Redgate有一些东西，但是我没有用过:
http://www.red-gate.com/products/sql-development/sql -source-control/ [ ^ ]

You are looking for source or version control for a database.
Redgate has something, but I''ve not used it:
http://www.red-gate.com/products/sql-development/sql-source-control/[^]

如果您不寻找SQL源代码控制工具，则可能正在寻找SQL模式差异/比较工具.我知道的最受欢迎的一种(也是RedGate的)称为 SQL比较 [ ^ ]. Visual Studio 2010 Ultimate和Database版本内置了相当不错的数据库比较工具.还有功能较少的免费工具，例如打开DBDiff [您可能想尝试的 ^ ].

If you aren''t looking for a SQL source control tool, you might be looking for a SQL schema diff/comparison tool. One of the most popular ones that I know of (which is also by RedGate) is called SQL Compare[^]. Visual Studio 2010 Ultimate and Database editions have pretty good database comparison tools built in. There are also less feature-rich free tools like Open DBDiff[^] that you may want to try.

这篇关于记住的工具，放弃对数据库所做的更改的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！