Skip to main content

Compare Data Store Model Versions

In this example, we will compare two single-model data source models. There are several versions of the DDL for the models in the models folder.

Create a new model. Complete the dialog as follows:

In the Import Setup tab specify in the File parameter the location:

Information note

C:\temp\Models\MetadataManagement\Finance\_ConfigurationVersions\v1\DatabaseDDL\FinanceDWStaging.sql

And “dbo” as the Default schema .

Click SAVE and then IMPORT . Click IMPORT again without checking any boxes.

When the import has completed, in the Import Setup tab update in the File parameter with the location:

Information note

C:\temp\Models\MetadataManagement\Finance\_ConfigurationVersions\vComplete\DatabaseDDL\FinanceDWStaging.sql

And again click Save and then IMPORT . Click IMPORT again without checking any boxes.

Go to the Versions tab.

Information note

There are now two different versions of this model in the repository. The latest one is in the current configuration.

To compare the two versions, you must step outside the configuration, so as to see all the versions of the model.

Go to MANAGE > Repository , expand the Comparison Staging DW model, right-click the latest version, and select Compare with previous version .

Click the row for the PaymentAmount column with the difference icon .

Information note

The difference is in the Length of the data type.

Scroll down to the bottom of the comparison.

Information note

We see three table (AccountCategory, Category and CategoryGroup) have been added with the latest version.

Click the Filter icon to show only New Objects .

Click Show Statistics :

Click SWAP to change the order of the comparison:

Information note

The three tables are now New Objects , rather than Missing Objects .

Click COMPARE OPTIONS .

Information note

One may control the different options of the comparison.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!