These pages cover SQL Compare versions 10.0 to 10.7. Help for older versions is also available.

We've released a beta version of the improved migration script feature. We'd love to hear what you think.

Skip to end of metadata
Go to start of metadata
Icon

DACPAC support is in beta.

You can use SQL Compare to compare data-tier application packages (DACPACs).

To specify a DACPAC as a data source:

  1. In Windows Explorer, right-click the DACPAC file you want to use, and click Unpack.
    The Unpack Microsoft SQL Server DAC Package File dialog opens.
  2. Specify the folder you want the files in the DACPAC to be unpacked to, and click Unpack:

    Icon

    DACPACs contain a model.sql file. This is a creation script for all the database objects in the package. SQL Compare uses it when you compare a DACPAC.

  3. In SQL Compare, on the Project Configuration dialog box, select Source Control as a data source:
  4. Select Scripts folder, and browse to the folder you unpacked the DACPAC to:

    Icon

    When you specify a DACPAC folder, SQL Compare displays a warning: 'Scripts folder found with missing metadata file'. This is a known issue with the beta DACPAC support, and can be ignored.

If you have any problems using DACPACs with SQL Compare, contact Red Gate support.

  • No labels