I cannot get dacpac working on my installation of MS SQL Server 2008 R2. I am using Visual Studio 2010 Shell with MS SQL Server Data Tools to build a project into a dacpac file. However, when I try to deploy it, I get the following error:
<DacType xmlns='http://schemas.microsoft.com/sqlserver/dac/Serialization/2012/02'> was not expected. (6di0urgg)
(This seems to indicate that it is using a xml schema that the 2008 server does not know, however in the project properties the target platform is set to SQL Server 2008 R2)
Just to see how the "correct" dacpac file looks like, I tried to Extract/Register Data-tier Application (of a very simple existing database) via Management Studio. Everything seems to go smoothly, but then the export dies with the following message:
Method not found: 'Void Microsoft.SqlServer.Management.SqlParser.Metadata.IdentityColumnInfo..ctor(Int64, Int64, Boolean)'. (Microsoft.SqlServer.Management.SmoMetadataProvider)
Googling for these error messages yields no relevant results (as far as I was able to tell). Can anybody advise? Is anybody using dacpacs?