Compare the data of database objects

Last modified: 11 February 2024

The Compare Data action compares the output of tables, views, and materialized views. To find this action, select two objects in the Database tool window ( View | Tool Windows | Database) , right-click the selection and navigate to Tools. Also, you can double-click these objects and then compare them from the editor.

You can compare the contents of two objects that belong to different types. For example, the output of a table and a materialized view.

Table contents

Description of Tolerance and Detect column insertion is available in Controls of the Diff Viewer for contents.

By default, when you issue a query, the number of returned rows is limited to 500. This limitation is introduced to avoid an overload (for example, when your SELECT statement returns one million rows). To increase the number of compared rows, configure the Limit page size to parameter.