Error when trying to upgrade SQL Azure database using DAC Package in MGMT Studio - "Unexpected XML Content"

Unanswered Error when trying to upgrade SQL Azure database using DAC Package in MGMT Studio - "Unexpected XML Content"

  • Donnerstag, 16. Februar 2012 12:34
     
     

    Hi there,

    I am trying to upgrade a database running in SQL Azure from my local dev box which is running SQL Server 2008 R2 Sp1 (Microsoft SQL Server 2008 R2 (SP1) - 10.50.2500.0 (X64))

    I extract the dac with no problems from my local database. However, when I try to upgrade the Azure db I get the below error.

    This error occurs just after I browse to select the dac package and click open in the browse window. I.e. It happens before I actually try and apply this dac to the Azure database. Something is going wrong, presumably, when the package is parsed by management studio.

    I am running Visual Studio 2010 Premium Sp1 if that matters, plus all the various updates required for Azure development..

    Thanks for your help!