Use the Compare Revisions feature to identify differences between your SqlDBM revisions within seconds. This feature helps you detect possible mistakes when migrating DB/DW across environments by comparing the tables and DDL scripts.
Compare Revisions
To use this feature, make sure you have made changes to your project and saved them, thereby creating multiple revisions for comparison.
Click on "Compare Revisions" in the left pane.
Select the two revisions that you would like to compare.
You will see all the database objects listed in the revisions you have selected. Changes are highlighted based on the following colors:
Red - deleted objects
Green - created objects
Yellow - modified objects
To interrupt the process, select any other revision while the comparison is loading.
To review an object in detail, click on that object to see the differences in the DDL. The differences follow the highlighting described above.
Additional tabs exist to highlight changes in non-DDL metadata.
Non-DDL metadata such as flags and colors can be found on the "NoDDL" tab.
Dbt properties such as tests and configs can be found on the "dbt property values" tab.
Compare by properties
Certain projects offer an updated compare format that highlights individual properties instead of plain-text DDL comparisons. This format makes it easier to spot specific changes and offers faster rendering.
The "Metadata" tab replaces the "NoDDL" tab in the previous version of this screen.
The list currently includes:
- Snowflake
- Postgres
- Logical
More databases will transition to this format in the future.