DB2 SQL查询以比较2个模式 [英] DB2 SQL query to compare 2 schemas

问题描述

我一直无法找到一个解决方案，我在网上搜索这个，大多数反馈建议一个工具，这导致我相信，这可能很难用SQL查询或什么，但...

I have been unable to find a solution in my searching for this throughout the web, most responses recommend a tool, which leads me to believe this may be very difficult with an SQL query or something, but...

我已经被告知要使用Toad来编写DB2数据库的查询，它将比较2个模式并提供一个结果，如果有任何差异。我知道这种能力存在于Toad，但由于某种原因，我们的DBA不想使用它。购买额外的软件不是一个选择。

I have been told to write a query for our DB2 database, using Toad to interface, that will compare 2 schemas and provide a result if there are any differences. I know this capability exists in Toad, but for some reason our DBA does not want to use it. Purchasing additional software is not an option.

我有非常有限的SQL知识/经验，这是我的学习任务之一。我没有取得什么进展，我感觉很困难。任何人都可以给我建议吗？非常感谢您的帮助。

I have very limited SQL knowledge/experience, and this is one of my 'learning' tasks. I have not made much progress and am feeling very stuck. Can anyone offer me suggestions? The help is greatly appreciated!

推荐答案

尝试IBM Data Studio，它是免费的，您可以选择任何2个对象， 。

Try IBM Data Studio, it is free, you can select any 2 objects then compare between them.

这篇关于DB2 SQL查询以比较2个模式的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！