Stack Overflow
Stack Overflow

Questions tagged [vsdbcmd]

vsdbcmd.exe is a command line utility which can be used to deploy a database or to import a database schema into a `.dbschema` file.

From MSDN:

You can use VSDBCMD.EXE to:

  • Import a database schema from a live database into a .dbschema file
  • Generate a deployment script from a .dbschema file
  • Generate a deployment script from a .dbschema file and deploy that script to a target database
  • Generate a deployment script by comparing two .dbschema files.

.dbschema files are used in Visual Studio Database Projects (DataDude) as a meta data representation of the DDL within a database.

29 questions
1
vote
1 answer

How to include a sql file in a Database Project without have it run by the deployment process

My database project needs to include a SQL file with a command that will be run manually in another server in order to create a linked server to this one. I wish that this file would be parsed by the VSDBCMD and copied into the output folder with…
ab_732
  • 3,639
  • 6
  • 45
  • 61
1
vote
0 answers

SQL Server database project post deployment script size limit?

We have a SQL Server 2008 database project created in Visual Studio 2010 that we currently have been using for our production database for almost a year and use vsdbcmd to deploy. We have many default data scripts setup to run in the post…
user1457642
  • 11
  • 1
0
votes
1 answer

How do I troubleshoot when VSDBCMD does not deploy, but shows no errors?

I am trying to use VSDBCMD.exe (Visual Studio 2010 version) to deploy the output of a database project. I am including the /dd:+ switch in my command line. Every time I run the command, I get one message: TSD00566 Deployment script generated…
Boris Nikolaevich
  • 1,451
  • 11
  • 21
0
votes
2 answers

Calling VSDBCMD from inside a dbproj file

I have a standard sql server 2008 project which has been created using vs2010. I have been trying to modify the build process so that at the end a custom task should fire which would call VSDBCMD to generate a deploy script by comparing the output…
Nikhil
  • 3,304
  • 1
  • 25
  • 42
0
votes
2 answers

CREATE DATABASE fails using VSDBCMD

When trying to deploy a VS2010 database project using the VSDBCMD tool, I get the following error: SQL01268 .Net SqlClient Data Provider: Msg 5133, Level 16, State 1, Line 1 Directory lookup for the file…
Chris Brook
  • 2,335
  • 20
  • 24
0
votes
1 answer

Unable to load sqlceme35.dll when using vsdbcmd.exe

I'm using vsdbcmd.exe to deploy a database to SQL Server 2008 on Windows 7 x64 and I'm getting an error message saying: An unexpected failure occuured: Unable to load DLL 'sqlceme35.dll': The specified module could not be found. (Exception from…
Michael
  • 1,081
  • 1
  • 12
  • 27
0
votes
1 answer

How do you fix TSD02016 error in Database

I have a database I am using the Visual Studio 2010 Database Project tool vsdbcmd.exe to create a schema from. vsdbcmd /a:Import /dsp:Sql /model:"Database" /cs:"Server=SqlServer; Initial Catalog=DatabaseName; Integrated Security=SSPI;" The tool is…
Keith Sirmons
  • 8,271
  • 15
  • 52
  • 75
0
votes
1 answer

VSDBCMD deployment for additions to third party databases

We have some custom objects (stored procedures etc) in an SQL Server 2005 database belonging to an ERP system. The custom objects are in different schemas to the ERP objects. We're using Database Edition .dbproj projects and vsdbcmd deployment for…
Sam
  • 4,694
  • 2
  • 36
  • 47
0
votes
0 answers

VSDBCMD.exe not setting %ERRORLEVEL% when deploy fails

I am using VS2010 command line tool (VSDBCMD) to deploy SQL projects to specific environments via batch file. My batch file first builds the database project using a User ID and Password that the user enters. I then deploy the project using the…
roonz11
  • 795
  • 1
  • 13
  • 24
0
votes
1 answer

VSDBCMD generates an error when running in PowerShell

We are running VSDBCMD to generate a diff sql script between our database project and our staging database. VSDBCMD is executed locally on staging server and is started by a powershell script from a remote host. When running the script locally…
pakerblom
  • 23
  • 3
0
votes
1 answer

Reading "Model Collation" for a deployed SQL Server database

We are using database projects to deploy our databases. In the project settings, we have specific a Project Version (version of target SQL Server) and a Collation for Data model. However, when I deploy it, I get the following error TSD00560 …
Hamid Shahid
  • 4,486
  • 3
  • 32
  • 41
0
votes
1 answer

vsdbcmd.exe generate drop constraint instructions without constraint name

When generating a diff script between two dbschema with vsdbcmd.exe, I sometime obtain an unexpected output, containing some drop constraint without the name of the constraint : GO PRINT N'Dropping On column: ColumnName ...'; GO ALTER TABLE…
Guillaume
  • 1
  • 2
0
votes
2 answers

Deploy content from a database-project to other database

I have a build-definition in TFS that builds a database-project in Visual Studio. The output is a dbschema and some other files. With that dbschema I deploy that Database to another server by using vsdbcmd. This works fine to deploy the Database…
Mathieu
  • 3,073
  • 1
  • 19
  • 25
-1
votes
1 answer

VSDBCMD remotely

Can I run the VSDBCMD command remotely? I mean without copying the files to the SQL server? I am trying to create a dbschema file to use it as a reference in a database project. I tried to run the command on my machine, and I get the following…
Oana Marina
  • 277
  • 3
  • 19
1
2