“Internal Error: Ese could not be initialized” when performing a schema compare in SSDT

I have recently imported several of our live databases into SSDT and was just trying to perform a schema compare to make sure I pick up any changes since the import before we start using the SSDT solution as our source code.  I have just received the following error…

“Target is unavailable: Internal Error: Ese could not be initialized”

SSDT Ese Error1

In this case the source is my database and the target is the database project (if I switch them round so the database project is the source then the error changes to “Source is unavailable…”).

If you look in the application log you can see a much more useful error…

SSDT Ese Error2

Looking at this error we can see that during the schema compare SSDT creates a .model file in “C:\Users\SimonP\AppData\Local\Temp\12aadf86-a621-49fa-8c75-de8dfa92fdc2.model” and it cannot open it because it is compressed.  My C drive is compressed but if I remove the compression from “C:\Users\SimonP” the schema compare now works.


SQL Server 2012 Exam Progress

I’ve managed to pass the following exams so far:

  • 461 – Querying Microsoft SQL Server 2012
  • 462 – Administering Microsoft SQL Server 2012 Databases
  • 464 – Developing Microsoft SQL Server 2012 Databases

Since then I’ve had a break and have been going through Kalen Delaney’s excellent Microsoft SQL Server 2012 Internals book but now I’m going to start looking at

  • 463 – Implementing a Data Warehouse with Microsoft SQL Server 2012

This one along with 461 and 462 will give me the Microsoft Certified Solutions Associate (MCSA) qualification.

Then I’ve got

  • 465 – Designing Database Solutions for SQL Server 2012

which along with 464 increases the MCSA to a Microsoft Certified Solutions Expert (MCSE).  There are two flavours of MCSE, this one would be the Data Platform one.  There is also the Business Intelligence one which has the following exams instead of 464 and 465.

  • 466 – Implementing Data Models and Reports with Microsoft SQL Server 2012
  • 467 – Designing Business Intelligence Solutions with Microsoft SQL Server 2012

I haven’t decided if I’ll go for the BI ones as well but we’ll see.

If you’re looking for a good resource for helping with the exams then I’d recommend the official guide books and practise tests. The first 2012 exam I did was the DBA one (462) and I read that cover to cover before even looking at the practise tests.  For 461 I found it much better to read the book not in chapter order but in objective order.  The front couple of pages of the book list the exam objectives along with the relevant chapters for each one. I read all the chapters for the first objective and kept at the practise tests for that objective until I was getting 80 – 90%, then moved on to the next one.  You can set up the practise tests to only include questions for a particular objective, or multiple objectives which is very handy. Once I was passing the questions for the second objective I ran through a few tests containing questions for both the first and second objectives and then moved on to the third.  I carried on until all objectives where complete and I was getting high scores on the entire test.   I’m planning on doing the same for the data warehousing book (463).