在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屋!