Database project crash

Question

Hi.

I'm using VS 2010. I've got a database project. SQL Server 2008 Project.

I click SchemaComparison. In "Select Source/Target Schema" dialog push "OK".

And always get the error.

Problem signature:

  Problem event name: APPCRASH
  Application name: devenv.exe
  Application version: 10.0.40219.1
  Application time stamp: 4d5f2a73
  Module with error name: nlssorting.dll
  Module with error version: 4.0.30319.233
  Module with error time stamp: 4d92ec74
  Exception code: c00000fd
  Exception shift: 0000167a
  OS version: 6.1.7601.2.1.0.256.1
  Language code: 1049

Additional information about the problem:
  LCID: 1033

VS 2010 repair didn't help.
How to improve the problem?

Answer 1

Hello Kirill,

What is the source and target schema in your Schema Compare? And have you put your database projects into TFS version control?

In addition, I personally think that maybe there are some add-ins, plug-ins or packages on your machine which cause the VS crash. Please try the following command to open VS to see if the issue is still exist:

• In the command line, try to run devenv /ResetSettings to restore your VS to the default settings.
• Try to run devenv.exe /SafeMode to disable these add-ins.
• Try to run Devenv /ResetSkipPkgs to avoid loading VSPackages.

Thanks.

---

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

Answer 2

Vicky, thanks for your reply.

The commands didn't help.

Source Schema is Project.
Target Schema is Database (remote server)
The database project is under TFS source control.

More details. After I double-click the comparison file, I get the warning:

"The 'RadLangSvc.Package, RadLangSvc.VS, Version=10.0.0.0,
Culture=neutral, PublicKeyToken=89845dcd8080cc91' package did not load correctly.

The problem may have been caused by a configuration change or by the installation of another extension. You can get more information by running the application together with the /log parameter on the command line, and then examining the file
'C:\Users\...\AppData\Roaming\Microsoft\VisualStudio\10.0\ActivityLog.xml'.

Continue to show this error message?"


And sometimes after pushing "OK" in schema comparison dialog VS 2010 crashes with error

Problem signature:
  Event name: CLR20r3
  Problem signature 01: devenv.exe
  Problem signature 02: 10.0.40219.1
  Problem signature 03: 4d5f2a73
  Problem signature 04: System.Windows.Forms
  Problem signature 05: 4.0.0.0
  Problem signature 06: 4ba1e14e
  Problem signature 07: 9c6
  Problem signature 08: 13e
  Problem signature 09: System.OutOfMemoryException

Answer 3

Hello Kirill,

To deal with your issue, please try to get latest version of your database project from TFS version control and check out it. And also make sure the target database in the remote server is accessible.

And the error message you offered above also indicates that there is something wrong with your VS. Will you other team members get the same error as you? Please also try re-install your VS to see if it helps you.

Thanks.

---

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

Answer 4

This helped

1. Downloading the SP! DVD ISO from here.

2. Executing DACProjectSystemSetup_enu.msi from the root of the ISO.

The source:

http://connect.microsoft.com/VisualStudio/feedback/details/532121/tons-of-package-did-not-load-correctly-errors