Skip to content

schema-compare-extension.md

Latest commit

 

History

History
67 lines (41 loc) · 2.88 KB

schema-compare-extension.md

File metadata and controls

67 lines (41 loc) · 2.88 KB
title Schema Compare extension
titleSuffix Azure Data Studio
description Install and use the Schema Compare extension for Azure Data Studio
ms.custom seodec18
ms.date 11/04/2019
ms.reviewer alayu; sstein
ms.prod sql
ms.technology azure-data-studio
ms.topic conceptual
author yualan
ms.author alayu

Schema Compare extension

The Schema Compare extension provides an easy-to-use experience to compare two database definitions and apply the differences from the source to the target.

Features

  • Compare schemas of two dacpac files or databases
  • View results as a set of actions that must be taken against the target for it to match the source
  • Selectively exclude actions listed in results
  • Set options that control the scope of the comparison
  • Apply changes to target or generate a script with the same effect
  • Save the comparison

Schema Compare: Example Comparison

Why Would I Use the Schema Compare Extension?

It can be tedious to manually manage and synchronize different database versions. The Schema Compare extension simplifies the process of comparing databases and gives you full control when synchronizing them — you can selectively filter specific differences and categories of differences before applying the changes. The Schema Compare extension is a reliable tool that will save you time and code.

Schema Compare: Options Dialog

Install the Extension

  1. Select the Extensions Icon to view the available extensions.

    extension manager icon

  2. Search for the Schema Compare extension and select it to view its details. Click Install to add the extension.

  3. Once installed, Reload to enable the extension in Azure Data Studio (only required when installing an extension for the first time).

Launch a Schema Compare

  1. To open the Schema Compare dialog, right-click a database in the Object Explorer and click Schema Compare. The database you select will be set as the Source database in the comparison.

    schema compare launch menu

  2. Select one of the ellipses (...) to change the Source and Target of your Schema Compare and click OK.

    schema compare select source/target

  3. To customize your comparison, click the Options button in the toolbar.

  4. Click Compare to view the results of the comparison.

Next steps

To learn more about Schema Compare, check our documentation. Report issues and feature requests here.