在SQL Server 2008中区分两个表架构的最简单方法？ [英] Easiest Way To Diff Two Table Schemas In SQL Server 2008?

问题描述

我必须在开发和发布数据库之间进行检查，然后手动进行，这既缓慢又不可靠（我只能目视检查表），而且速度也不是100％。

I have to do checks between a development and release database and do this manually, which is both slow and not 100% reliable (I only visually inspect the tables).

是否有快速简便的方法来自动比较表模式？

Is there a quick and easy way to compare table schemas automatically? Maybe even a feature that does this built right into SQL server?

编辑：我只是比较结构，谢谢您指出这一点。

I'm comparing structure only, thank you for pointing this out.

推荐答案

我是 SQL DBDiff ，这是一个开放源代码工具，可用于比较两个SQL Server数据库实例的表，视图，函数，用户等，并在源数据库和目标数据库之间生成更改脚本。

I'm a fan of SQL DBDiff, which is an open source tool you can use to compare tables, views, functions, users, etc. of two instances of SQL Server databases and generate a change script between the source and destination databases.

这篇关于在SQL Server 2008中区分两个表架构的最简单方法？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！