I like Toad Data Modeler for this. It reverse-engineers Microsoft SQL Server databases (and other brands of databases too), but more than that, you can start making your modeling changes inside the tool and it'll generate change scripts.
If you use somebody else's tool, make sure that you can round trip changes - meaning, if you put all the time and effort into getting your documentation right, and then you change the database inside SQL, can you re-import your changes from the database without overwriting your work in the documentation tool? Most of 'em don't do that, but Toad Data Modeler does.
(Disclaimer - I work for Quest. I used this program before Quest bought it, though, and always loved it.)
发布评论
评论（3）
查看SQL 文档。
Take a look at SQL Doc.
我总是使用 Visio 来处理此类事情。
I always used Visio for this type of thing.
我喜欢 Toad Data Modeler。 它对 Microsoft SQL Server 数据库（以及其他品牌的数据库）进行逆向工程，但更重要的是，您可以开始在工具内进行建模更改，它将生成更改脚本。
如果您使用其他人的工具，请确保您可以进行往返更改 - 这意味着，如果您投入所有时间和精力来确保文档正确，然后更改 SQL 中的数据库，您可以从 SQL 中重新导入您的更改吗？数据库而不覆盖您在文档工具中的工作？ 大多数人不会这样做，但 Toad Data Modeler 会这样做。
（免责声明 - 我为 Quest 工作。不过，在 Quest 购买之前我就使用过该程序，并且一直很喜欢它。）
http://www.quest.com/toad-data-modeler/
I like Toad Data Modeler for this. It reverse-engineers Microsoft SQL Server databases (and other brands of databases too), but more than that, you can start making your modeling changes inside the tool and it'll generate change scripts.
If you use somebody else's tool, make sure that you can round trip changes - meaning, if you put all the time and effort into getting your documentation right, and then you change the database inside SQL, can you re-import your changes from the database without overwriting your work in the documentation tool? Most of 'em don't do that, but Toad Data Modeler does.
(Disclaimer - I work for Quest. I used this program before Quest bought it, though, and always loved it.)
http://www.quest.com/toad-data-modeler/