Database Project Schema Compare

Question

I have VS2010 Ultimate, VS2012 Release Candidate, Sql Server 2008 R2 and Sql Server 2012 RC (installed, not running) installed on my computer.

When I try to do a schema compare from my database project to the database on Sql Server 2008 R2 I get this error:

Error 202 Source is unavailable: Internal Error: Ese could not be initialized. SqlSchemaCompare1 0 0 

I have reinstalled the latest SSDT tools, and still get this.  I am unable to find any information on what this error is about.

Any help would be appreciated.

Thanks.

---

nlm

Answer 1

Hi nlm1914,

Thanks for your post. However, I am sorry that I still feel a little confused about your issue, please kindly offer me more information:

1). In which version of Visual Studio you are doing the Schema Comparison? VS2010 or VS2012RC?
2). When do you get the above error? When you select the source and target schema or when you click the "Write Updates" button or...?
3). Could you please show me the detailed steps about how to set up your scenario, and how to reproduce the above error?

Thanks.

---

Vicky Song [MSFT]
MSDN Community Support | Feedback to us

Answer 2

I am doing the Schema Compare in VS2010 Ultimate.  I am comparing my VS2010 Database Project to a Sql Server 2008 R2 database.  (Visual Studio 2012 and Sql Server 2012 are installed on this machine also, but I am not currently using them)

I get the error after I pick the Source and Target and click on the Compare button.

I have tried this on another computer that Does Not have Visual Studio 2012 and Sql Server 2012 installed on it, but has VS2010 and Sql Server 2008 R2 installed and the schema compare works.

I am not sure if it is something to do with the newer version of VS or Sql Server, or it is something else entirely.

The error message does not seem to make sense, especially what is "ESE"?

Thanks for the help.

---

nlm

Answer 3

Hi nlm1914,

I set up the same environment as yours, however, I can't reproduce your issue on my side, I can do the schema compare successfully. And please take a look at the Event logs in the Event Viewer to see if there is any information useful, if so, post here.

Thanks.

---

Vicky Song [MSFT]
MSDN Community Support | Feedback to us

Answer 4

Ok, thanks for the help.  The problem is this:

Log Name:      Application
Source:        ESENT
Date:          08/14/12 07:38:24
Event ID:      505
Task Category: General
Level:         Error
Keywords:      Classic
User:          N/A
Computer:      nlmartzpc
Description:
devenv (8432) 53677728-49ed-46e7-ba3c-6491948f94d9: An attempt to open the compressed file "C:\Users\luke martz\AppData\Local\Temp\e2e88b94-1e73-47f4-868a-c6b8c17e6a8c.model" for read / write access failed because it could not be converted to a normal file.  The open file operation will fail with error -4005 (0xfffff05b).  To prevent this error in the future you can manually decompress the file and change the compression state of the containing folder to uncompressed.  Writing to this file when it is compressed is not supported.
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name="ESENT" />
    <EventID Qualifiers="0">505</EventID>
    <Level>2</Level>
    <Task>1</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="2012-08-14T14:38:24.000000000Z" />
    <EventRecordID>63954</EventRecordID>
    <Channel>Application</Channel>
    <Computer>nlmartzpc</Computer>
    <Security />
  </System>
  <EventData>
    <Data>devenv</Data>
    <Data>8432</Data>
    <Data>53677728-49ed-46e7-ba3c-6491948f94d9: </Data>
    <Data>C:\Users\luke martz\AppData\Local\Temp\e2e88b94-1e73-47f4-868a-c6b8c17e6a8c.model</Data>
    <Data>-4005 (0xfffff05b)</Data>
  </EventData>
</Event>

I have a compressed drive where I moved my user folders (created a junction mount), I am going to remove compression from the appdata folder and see what happens.

Thanks for the help.

---

nlm

Answer 5

Hi nlm1914,

I agree with you that your issue should be caused by compressed folder according to the error message you provided above.

And just as you mentioned above, please try decompressing the compressed folder to see if it helps. Please refer to the Decompress the folder where the databases and logs reside part of this KB article for further information about the detailed steps: http://support.microsoft.com/kb/327772 

Thanks.

---

Vicky Song [MSFT]
MSDN Community Support | Feedback to us

Answer 6

Thanks for the help, the compressed folder was the problem.

I do have Sql Server in a non compressed folder, however I did not realize that the schema compare actually took place in a folder in  my AppData folder, which was compressed, but now is.  This will teach me to look at the event viewer.

---

nlm