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 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 Revisions for Snowflake
Snowflake 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 takes the place of the "NoDDL" tab in the previous version of this screen.
More databases will transition to this format in the future.