Visual Studio 2012模式比较：列顺序和约束名称 [英] Visual Studio 2012 Schema Compare: Column Order and Constraint Names

问题描述

我在试验Visual Studio 2012 Premium中的SQL模式比较。

如何在比较中忽略列顺序？

我发现一些帖子说明这个选项是在VS 2010中引入的，但我只看到忽略列排序规则的选项在VS2012。
（关于vs2010的讨论）

如何忽略比较中约束名称的任何差异？ p>

约束应该存在，但不需要具有相同的名称。

解决方案

根据 VS2012，删除了忽略列顺序。 a927b26f45f1rel =nofollow>链接

对于忽略约束名称，我只能通过视觉比较它。我假设你想这样做，因为你有系统生成的约束名称。您可以避免系统生成的约束名称，以克服该问题。

I'm experimenting with the SQL Schema Compare in Visual Studio 2012 Premium.

How do I ignore the column order in the comparison?

I found some posts that state this option was introduced in VS 2010, but I only see "Ignore column collation" the option in VS2012. (Discussion for vs2010)

How do I ignore any differences in the names of the constraints in the comparison?

The constraints should be present, but do not need to have the same name.

解决方案

The ignore column order was removed for VS2012 according to this link

As for ignoring the constraint name the only way I could see it done is visually comparing it. I am assuming you are wanting to do this because you have system-generated constraint names. You can avoid system-generated constrain name to overcome the issue.

这篇关于Visual Studio 2012模式比较：列顺序和约束名称的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！