Error deploying DACPAC on Azure SQL Server

Question

Using the application project level VS2010 SP1, I created a simple database that I could:

CREATE TABLE [dbo].[Table1] ( column_1 int NOT NULL, column_2 int NULL )

Then I successfully built .dacpac and tested it by deploying it using SSMS 2008 R2 to a local instance of SQL Express (everything works fine).

Then I tried using SSMS 2008 R2 to deploy .dacpac on Azure SQL Server. The wizard managed to go through every step (including creating a database and creating a circuit), but failed at the last stage - "Register DACs in DAC metadata" - with the exception of IndexOutOfRangeException (see below).

I tried to do this against an existing Azure SQL Server, against a new Azure SQL Server (both refused with the same exception), and against an Azure SQL Server with an empty database with the same name (this failed with SSMS exception).

I have no ideas now. Any ideas on how to deploy .dacpacs for SQL Azure would be greatly appreciated.

System.IndexOutOfRangeException: The index was outside the array. at Microsoft.SqlServer.Management.Smo.SqlPropertyMetadataProvider.PropertyNameToIDLookupWithException (String propertyName, PropertyAccessPurpose pap) at Microsoft.SqlServer.Management.Smo.SqlSmoObject.GetDlSermerlSermeerlermeerlremerServermreerServerMlServerMlServerMlServerMerServerMerServerMlServerMerServerInlerServerMerServerInlServerMerServerInlServerMerServerInlServerInlServer Microsoft.SqlServer.Management.Smo.AbstractCollectionBase.get_StringComparer () in Microsoft.SqlServer.Management.Smo.SimpleObjectCollectionBase.InitInnerCollection () in Microsoft.SqlServer.Management.Smo.SmoCollectionBase.get_InternalQ SmoCollectionBase.GetObjectByKey (ObjectKeyBase key) in Microsoft.SqlServer.Management.Smo.DatabaseCollection.get_Item (String name) in Microsoft.SqlServer.Management.Dac.RegisterDacStep.Execute () in Microsoft.SqlServer.ManagementMan.ActionManation.DaT. TransactionalStep.DoExecute () in Microsoft.SqlServer.Management.Dac.TransactionalActionManager.ManagedActionStep.Execute () at Microsoft.SqlServer.Management.Dac.TransactionalActionManager.ExecuteActionSteps (IEnumerable`1 managedActionSteps) at Microsoft.SqlServer.Management.Dac.TransactionalActionManager.Go () at Microsoft.SqlServer.Management.Dac.DacSty.Type.Tan. DatabaseDeploymentProperties deployProperties, Boolean skipPolicyValidation, Boolean skipDacRegistration)

Answer 1

According to Microsoft, there seems to be some kind of problem around which you are installing VS 2010 SP1 and SQL 2008 R2 SP1.

Herve's answer may also solve the problem (for example, reinstall SQL 2008 R2 SP1), but I could not verify it, because I already solved the problem by following the solution recommended by the SQL Azure team - go to http://www.microsoft.com/download /en/details.aspx?id=26728 and download / install a new MSI SMO (which is listed as 1033 \ x64 \ SharedManagementObjects.msi).

Thanks MS!

Answer 2

Do you have the latest SSMS build? You must run SSMS R2 SP1. This has fixes for the DAC DAC.

Here it is: http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=26727