"Object reference not set to an instance of an object" when trying to run VSDBCMD.exe

1.5k Views Asked by At

We are trying to deploy a database project using tfs deployer and "vsdbcmd.exe" (VS 2010 version).

Both are on a windows server 2008 r2 (64 bit).

When our deployment script runs and we call the VSDBCMD.exe, we get the following error:
An unexpected failure occurred: Object reference not set to an instance of an object.

Note: SQL Server is not installed on this server, the script calls to a different server which has the databases we want to execute the database schemas against. Visual studio is also not installed on this server so I executed reg add HKEY_CURRENT_USER\Software\Microsoft\VisualStudio\10.0 as I found a missing registry key could be causing the issue. However, the problem still occurs

The dll's copied to the server are:

Extensions (folder)
DatabaseSchemaProviders.Extensions.xml

Microsoft.Data.Schema.dll

Microsoft.Data.Schema.ScriptDom.dll

Microsoft.Data.Schema.ScriptDom.Sql.dll

Microsoft.Data.Schema.Sql.dll

Microsoft.Data.Schema.Utilities.dll

Sqlceer35en.dll

Sqlceme35.dll

Sqlceqp35.dll

Sqlcese35.dll

sqlceca35.dll

sqlcecompact35.dll

sqlceoledb35.dll

System.Data.SqlServerCe.dll

vsdbcmd.exe

vsdbcmd.exe.config

Any ideas on how to resolve this would be great

Thanks,

Ryan

0

There are 0 best solutions below