The database platform service with type Microsoft.Data.Tools.Schema.Sql.SqlAzureV12DatabaseSchemaProvider is not valid

I got this error while trying to import a BACPAC from SQL Azure, into a local SQL server (LocalDb) instance.  This was using the DacServices.ImportBacpac method.  I had previously received BACPAC files from my esteemed DevOps colleagues which did not generate this error, but this particular set of BACPACs did.

If you google this error, mostly what you find is people who are getting the same error while trying to import the bacpac manually in SSMS.  But in my case I was trying to do it programmatically.  Anyway those posts mostly suggest upgrading SSMS to the latest service pack etc, which I tried, to no avail.  I also thought maybe if I changed the parameters it might help, but in fact there weren't many parameters to change.

So I went back to the old school method (using SqlPackage.exe from the command line).  But then I got a different error:

you must have a user with the same password in master.

Eventually I hit upon a method that worked, which was to use the connection string parameter ("tcs" parameter), rather than trying to specify the server and database as separate parameters.  This worked:

SqlPackage.exe /Action:Import /tcs:"Data Source=(localdb)\MyDatabaseServer;Initial Catalog=MyDatabaseName;Integrated Security=SSPI;MultipleActiveResultSets=True;" /sf:C:\Users\david\Bacpacs\MyProductionBacpac.bacpac

 I hope this may help somebody.

Comments

Post a Comment

Popular posts from this blog

Parsing MSTEST results (.trx files) programmatically (in C#)

  Hello, it’s been quite awhile since I’ve posted anything; I’ve been quite busy.  I just felt like sharing this.  This is an extension of other people’s ideas, but I’ve taken it slightly further and thought it might be useful to somebody. I came across a situation where I needed to programmatically examine a .trx file for specific strings.  The .trx file was large (31MB) because it contained the output of around 5000 unit tests.  Around 800 of those tests were failed tests, and they were failing for a specific reason (which is not important now).  The point is, I wanted to programmatically examine the error messages that were being output, and do something (which is also not important now), based on certain strings that might be found in the error message of each failed test. Searching led me to this post in Rasheed’s blog , which was a great starting point for what I wanted to do.  As described in that post, first I had to: Use XSD.EXE (see M...
Read more

Request.Browser.IsMobileDevice

It's known that the .Net framework's "Request.Browser.IsMobileDevice" is not entirely reliable in all cases as evidenced by the fact that our MVC2 site wasn't correctly detecting Android as a mobile, and as evidenced by some hits you can see in this search: http://www.bing.com/search?q=request.browser.ismobiledevice&src=IE-SearchBox&FORM=IE8SRC If we really want reliable mobile detection we need to incorporate the WURFL database (a giant XML file of every mobile device - see http://wurfl.sourceforge.net/ ) and from what I’ve seen, the preferred implementation of this for .Net appears to be “51degrees.mobi” … http://51degrees.codeplex.com/ On the MVC2 project I’ve been working on recently, I was using 51degrees.mobi in development; it seemed very effective, and you can do incredibly granular detection with it, but was a bit heavyweight for my particular project, the requirements of which were (in the case of mobile detection) simply to detect wheth...
Read more

The remote procedure call failed (0x800706be)–Windows Azure SDK installation broke SQL Server Config Manager?!?

Image
So I’ve been working on a project which is a large production web application built in ASP.NET MVC.  This is an enterprise level app which means it’s big, it’s complex, and it’s got a lot (i.e. thousands) of unit tests. When you run all unit tests in solution in Visual Studio, and you’ve got, say, 6000 tests, the memory usage goes way up for devenv.exe, QTAgent32.exe (if you’re using 32 bit version of that; same goes for the 64 bit version, I’ve noticed); and, if you’re doing integration tests and your tests are hitting the database, then, the memory usage goes way up for SQL Server.  And, it doesn’t seem to let go of that memory (for any of those applications) when the tests are done.  (I’ve also noticed this type of behavior when I run certain database build scripts). Well, I sometimes use the SQL Server Configuration Manager to, primarily, restart SQL Server, for example when I’ve just run a load of unit tests in Visual Studio.  (Yes you can also re-start the...
Read more