Exception: Microsoft.SqlServer.Management.Dac.MissingDacSchemaException When importing a bacpac

Unanswered Exception: Microsoft.SqlServer.Management.Dac.MissingDacSchemaException When importing a bacpac

  • Monday, October 31, 2011 4:58 PM
     
     

    I've just upgraded our SQL Server 2008 instance to SP1 and am getting the below error when using DacImportExportCli.exe:

     

    "DAC Exception: Microsoft.SqlServer.Management.Dac.MissingDacSchemaException: Unable to proceed with DAC operations on the target instance because it does not support DACs. Specify another instance, or upgrade to a version that supports DACs."

    The command I am using is below.

     

    "DacImportExportCli.exe -s WATSON\DEVELOPMENT -d DatabaseName20111028 -e -f D:\Backup\20111028_DatabaseName.bacpac -i"

    Is there anything I am missing?

     

     


    • Edited by Luke Merrett Monday, October 31, 2011 4:59 PM
    •  

All Replies

  • Tuesday, November 01, 2011 8:21 PM
     
     

    Hey Luke,

    DAC supports importing to 2008 SP2 and newer.