数据库反向工程和刷新不会更正数据库更改。 [英] Database Reverse Engineer and Refresh do not correct database changes.
问题描述
在一个窗口中，我正在删除/创建数据库（SQL 2008 SP1 10.0.2520.0）;在另一个我使用VISIO来构建该数据库的图纸。 我尝试使用Visio的刷新按钮，但它没有获取所有更改。 从图表中删除
表格，然后通过逆向工程师将它们带进来没有帮助..它实际上增加了一个问题。
嗨吉姆，
您似乎没有收到有关您列出的项目的反馈，因此我想提供一些信息。 我认为您的问题的根本原因是相同的，并且源于您在数据库中根据描述进行了"无变化更改"这一事实。
当您撤消时使用Visio从数据库工程师，创建了数据库的"地图"。 除非表格或视图列表发生更改，否则地图不会更改。 因此，如果从模型中删除表，但源数据库
中的任何内容实际上都没有更改，则无法提醒Visio重新添加表 - 因为数据库列表没有更改。
您可以尝试做的是在现有图表中执行新的逆向工程师，然后选择仅带入丢失的表格。 我已成功完成此操作，当我完成后，重新添加的表正确地连接到现有实体，当
我将其放在页面上时。
我希望帮助！
In one window, I am dropping/creating a database (SQL 2008 SP1 10.0.2520.0); in another I am using VISIO to build a drawing of that database. I tried using Visio's Refresh button, but it didn't pick up all the changes. Dropping tables out of the drawing, and then bringing them in through Reverse Engineer didn't help.. it actually added a problem.
1) on Refresh, column order (physical order was chosen) does not refresh... even if a column in the table was modified (length change).解决方案Hi Jim,
It doesn't appear that you have gotten feedback on the items you listed, so I wanted to offer some info. I think the root cause of your issues is the same, and stems from the fact that you have made a 'no-change change' in your database, from the description.
When you reverse engineer from a database using Visio, there is a 'map' of the database created. Unless the list of tables or views changes, the map does not change. So if you remove a table from the model, but nothing in the source database actually changes, you have no way to alert Visio to re-add the table - since the database list did not change.
What you can try to do is perform a new Reverse Engineer in the existing diagram, then select to bring in ONLY the missing table(s). I have done this successfully, and when I'm done, the re-added table properly connects to the existing entities when I drop it one the page.
I hope that helps!
这篇关于数据库反向工程和刷新不会更正数据库更改。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
