比较工具以生成SQL Server更新脚本 [英] Compare tools to generate update script for SQL server

问题描述

我想使Web应用程序的更新尽可能自动化。

我正在寻找一个可以比较数据库的两个实例并为我生成更新脚本的工具。作为构建过程的一部分，创建数据库的最新版本（即当前正在生产中）的实例，并将其与开发版本中已更改的内容进行比较。

I would like to make the update of the web application as automated as possible.
I'm looking for a tool that can compare two instances of a database and generate an update script for me. As part of the build process create a instance of the last version of the database (ie currently in production) and compare that to what has been changed on the development version.

任何输入都会受到赞赏。

Any input is appreciated.

推荐答案

我喜欢 SqlDbDiff 。比 RedGate的SQL比较

这篇关于比较工具以生成SQL Server更新脚本的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！