Visual Studio 2010 DataCompare表比较 [英] Visual Studio 2010 DataCompare table comparison

问题描述

在Visual Studio 2010中，您可以比较两个数据库之间的数据库数据.我想用它来将数据从一个数据库复制到另一个数据库.这些数据库具有完全相同的结构.但是，当我进行比较时，在VS2010的de DataCompare视图中仅看到65个表，但是数据库中有66个表.

In Visual Studio 2010 do you have the ability to compare the data of a database between 2 databases. I wanted to use this to copy data from one database to another. These databases have the exact same structure. But when I do a compare I see only 65 tables showing up in de DataCompare view in VS2010 but I have 66 tables in the database.

下一步是找出未显示的表.该表的名称为"CMS_PluginInstanceRouteParams".在我也检查过的两个数据库中也都存在此表.该表的结构为:

The next step was to find out which table not was showing up. The name of this table is 'CMS_PluginInstanceRouteParams'. This table is also present in both databases which I also have checked. The structure of this table is:

FK是与CMS_PluginInstance表的PK的关系. CMS_PluginInstance确实会出现在数据比较"窗口中，并且还会对数据进行比较和复制.

The FK is a relation to the PK of the CMS_PluginInstance table. The CMS_PluginInstance does show up in the Data Comparison window and the data is also compared and copied.

我也找不到对话框或选项，可以在其中输入一些要忽略的表名.

I also couldn't find a dialog or option where I can enter some table names to ignore.

您是否知道为什么该表未显示在数据比较"窗口的表列表中以及为什么不对该表的数据进行比较?

Does anyone of you know why this table is not showing up in the list of tables in the Data Comparison window and why the data of this table not is compared.

推荐答案

我在 表和视图必须满足两个条件才能出现在列表中:

首先，对象的架构必须在源数据库和目标数据库之间匹配.

第二，列表中仅显示具有主键或唯一键的表和视图.

这篇关于Visual Studio 2010 DataCompare表比较的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！