Previous Topic

Next Topic

Book Contents

Book Index

Comparing Views, Triggers and Functions

These objects are difficult objects to compare, as they are generally defined by a block of text, such as a view or procedure definition. A "simple" compare of this text will show a difference when only a single byte is different; this can often happen due to differences in formatting such as extra blanks or linefeeds.

AQT will deal with in two ways

Unformatting the Text

Firstly, AQT will unformat the text before comparing it. Unformatting the text will remove all linefeeds, tabs and extra blanks. By doing this, AQT is more able to deal with simple differences in the formatting of the definitions.

When you view the compare results, you will be shown the unformatted text in the compare results. This may be less readable than the original view / procedure definition, however is useful for seeing the difference between the definitions.

Changing the Schema Name

If you are comparing objects from two different schemas, AQT will do a replace the schema names in the values. This is best demonstrated with an example.

Suppose you are comparing view Prod.Cust_Orders to Dev.Cust_Orders. Prod.Cust_Orders has the definition:

Create View Prod.Cust_Orders As

Select * From Prod.Customer_Details a, Prod.Order_Details a,

Where a.Cust_Code=b.Cust_Code

Whereas Dev.Cust_Orders has the definition:

Create View Dev.Cust_Orders As

Select * From Dev.Customer_Details a, Dev.Order_Details a,

Where a.Cust_Code=b.Cust_Code

To compare these two definitions, AQT will replace "Dev." with "Prod." in the second definition before comparing it with the first. This will provide a more realistic comparison of the definitions as all the view text.

Advanced Query Tool
© 2023 Cardett Associates Ltd. All rights reserved.