Stack Overflow
Stack Overflow

Questions tagged [dbproj]

dbproj refers to Microsoft Sql Database Projects cerca VS2010. The project files for this type ended in `.dbproj`

32 questions
465
votes
24 answers

Microsoft.WebApplication.targets was not found, on the build server. What's your solution?

Trying to build my project on the build server gives me the following error: Microsoft (R) Build Engine Version 4.0.30319.1 error MSB4019: The imported project "C:\Program Files…
stacker
  • 14,641
  • 17
  • 46
  • 74
35
votes
4 answers

DB Project won't load in Visual Studio 2013

The error says: Failed to create extension manager for the target platform 'Microsoft.Data.Tools.Schema.Sql.Sql120DatabaseSchemaProvider'. My teammate created the DB Project, but when I pulled it down from source control it failed to create.
jocull
  • 20,008
  • 22
  • 105
  • 149
14
votes
2 answers

Visual Studio 2010 database edition schema compare where target is dbproj

I'm using visual studio 2010 database edition and running a schema compare against a SQL database instance to sync up new objects on the database which arent yet in my project (dbproj). My solution contains many projects some of which reference each…
Dav Evans
  • 4,031
  • 7
  • 41
  • 60
7
votes
1 answer

Using nuget within VS solution with only database dbproj projects to reference other dbproj files

So I have a Visual Studio solution which contains 3 database (.dbproj) projects. These projects need to reference other sql projects from other solutions, which I have packaged and uploaded to nuget. How can I manage these external packages /…
geoid
  • 285
  • 3
  • 8
4
votes
1 answer

Error SQL03120 on Trigger scripts in 2008 DB Project

I'm working on adding a database project in VS2010. I created a SQL 2008 DB Project, pointed at the development server, and it seems to have generated all of the appropriate schema objects. However, all of the CREATE TRIGGER scripts have the…
Vardoj
  • 51
  • 3
4
votes
1 answer

In my dbproj, setting «Copy always» or «Copy if newer» on a file fail the build on the build server

In VisualStudio 2010, we have a scenario where one dbproj (B) reference another dbproj (A). In dbproj (A), if I set the build action on one of our custom sql script in the Scripts folder to «Copy always» or «Copy if newer» the build fail (on build…
Hugues Ferland
  • 41
  • 2
4
votes
1 answer

Include SQL Server PostDeployment from DB Project reference

We are splitting up one of our SQL Server DB Projects into two separate projects. Core.DB Tables PostDeployment PreDeployment Core.Seed (Reference to Core.DB) PostDeployment PreDeployment I have the general "table" publish working…
Nix
  • 57,072
  • 29
  • 149
  • 198
4
votes
4 answers

VS2010 DB Project Deploy Error SQL01268 Directory Lookup Failed

My VS2010 database deploy is failing on my build server, which has SQL Server 2008 R2 installed on it. Here's the output that's relevant: Creating…
ssmith
  • 8,092
  • 6
  • 52
  • 93
4
votes
1 answer

In VS 2010, what is the meaning of the "subtype" element in the dbproj file?

After moving and renaming some files within a database project in VS 2010, I was comparing the dbproj file before and after my changes. I noticed that in some cases, the element "SubType" changed from "NotInBuild" to "Code", as follows. from…
JohnnyM
  • 28,758
  • 10
  • 38
  • 37
4
votes
2 answers

How can we extended SQLProj code analysis rules by adding our own custom rule?

Currently .sqlproj files have 15 code analysis rules (SR0001 to SR0015). I would like to create my own code analysis rule to make sure that columns used in where clauses are indexed. How would I extended the current .sqlproj code analysis so that I…
Andrew Thompson
  • 2,396
  • 1
  • 21
  • 23
4
votes
1 answer

Error "SQLBuildTask" Task could not be loaded from the asssembly 'Microsoft.Data.Schema.Tasks.Sql'

I'm trying to build a db project using msbuild.exe, running on a VM with Windows Server 2008 R2 Enterprise for 64-bit OS. Most of my applications are building successfully, this one DB project is giving me problems. .NET Framework 2 and 4 are…
Cheri
  • 81
  • 5
3
votes
1 answer

dbproj : error : Error HRESULT E_FAIL has been returned from a call to a COM component

When I load up a solution in Visual Studio 2010 that contains a database project, I get this error: Loading C:\path\project.dbproj ... C:\path\project.dbproj : error : Error HRESULT E_FAIL has been returned from a call to a COM component. I've…
Rush Frisby
  • 11,388
  • 19
  • 63
  • 83
3
votes
0 answers

AppHarbor one step build and how to deploy my database

I finally got to the point where my solution does everything that's needed in it's build step: Download NuGet packages. Deploy the database (only if it's not there yet). Build the solution. Run any upgrade scripts (just once, the database keeps…
bevacqua
  • 47,502
  • 56
  • 171
  • 285
2
votes
1 answer

Can't open a .dbproj file from VSTS DB Edition

The title says everything. I'm using Visual Studio Team System 2008 Database Edition and I just can't open any database project. I get the following error message: '..' cannot be opened because its project type (.dbproj) is not supported by…
Amokrane Chentir
  • 29,907
  • 37
  • 114
  • 158
2
votes
2 answers

How to deploy a dbproj in vs2010?

Quick question, I'm new to dbproj, how do you actually deploy it to my sqlserver from vs2010? I built the dbproj, and it created a bunch of files in sql/debug folder, then what do I do?
Ray
  • 12,101
  • 27
  • 95
  • 137
1
2 3