Sunday, December 21, 2008

Discrepancies Between Schemas

This report shows discrepancies between schemas. It can be helpful when you are in development, and trying to keep a test schema matching the production one. This report is actually three reports that show the following:
1) Missing tables in one or the other
2) Discrepancies found in Tables and Columns
3) Discrepancies in the Number of Columns in Tables

The first line of code is 'Define OnOff = Off'. If you want to test it, set this to on, and it will turn on echo, feedback, term, etc where ever it gets turned off.

You will then be prompted for two schema names.

AllDif.SQL is store as an attachment because of the length of it.

No comments:

Post a Comment