Live DB Compare is an Enterprise feature that allows users to compare project revisions against their existing environments.

Note that Snowflake and Azure Synapse can be added as dynamic connections in the "Environments" pane. All database types are supported with static DDL comparisons. To see how to connect dynamically to Snowflake or Azure Synapse, see the related article, below.

Live DB Revision with dynamic connection (Snowflake, Azure)

Select the "Compare Revisions" panel from the left menu. Click the "+" icon next to "Live DB Connection".

Select the "Connect with [DW]" option

Enter your DW connection parameters.

Select your database and schema(s).

Press "Apply" and review the metadata on the following screen.

Press "Import" and you will be able to perform the revision against the DDL that you've just imported.

Select the revision you wish to compare and "Live DB Connection" which now contains the corresponding DDL.

To perform a fresh Live DB Revision, clear the current "Live" DDL by pressing the "X" icon next to "Revision from uploaded DDL" and perform the steps again.

Live DB Revision with static DDL (all DWs)

Select the "Compare Revisions" panel from the left menu. Select the revision you wish to compare and click the "+" icon next to "Live DB Connection".

Select the "Provide your DDL" option

Paste your DDL into the text box or upload a saved file.

Press "Upload script" and review the metadata on the following screen.

Press "Import" and you will be able to perform the revision against the DDL that you've just imported.

Select the revision you wish to compare and "Live DB Connection" which now contains the corresponding DDL.

To perform a fresh Live DB Revision, clear the current "Live" DDL by pressing the "X" icon next to "Revision from uploaded DDL" and perform the steps again.

See also:

Direct DW Connection

Compare Revisions

Did this answer your question?