Stack Overflow
Stack Overflow

Questions tagged [sqlproj]

Database development project extension created by Visual Studio, a Windows software development IDE; stores the schema of the database and can include SQL source code; used for creating databases for SQL Server, Microsoft's relational database management system (RDBMS) software.

Database development project extension created by Visual Studio, a Windows software development IDE; stores the schema of the database and can include SQL source code; used for creating databases for SQL Server, Microsoft's relational database management system (RDBMS) software.

Older .DBPROJ files can be migrated to the newer SQLPROJ format in Visual Studio 2012.

Information from: http://www.fileinfo.com/extension/sqlproj

101 questions
1
vote
0 answers

Visual Studio not reporting error 71501 in SQL Server Database Project when joining temporary table

I am trying to figure out why Visual Studio does not report error SQL71501 (unresolved reference to an object) when joining temporary table. I am using VS 2019 version 16.3.6 and the issue can be reproduced by creating a new SQL Server Database…
Matej Darebnik
  • 11
  • 1
1
vote
1 answer

Detect Visual studio build configuration in sql post deployment script

I have a VS solution whose purpose is to publish an sql database, via .sqlproj. It runs a post deployment script. I would like to set it up for multiple publish workflows. I want my sql post deployment script do do something like the following…
William Jockusch
  • 26,513
  • 49
  • 182
  • 323
1
vote
1 answer

AfterPublish target for sqlproj in Visual Studio 2017

Goal: Run custom action after publishing SQL server database project in visual studio 2017 Problem: I have a SQL Server Database Project (.sqlproj) in the solution. In order to execute a customer action after publishing the project, the .sqlproj…
101V
  • 492
  • 1
  • 6
  • 13
1
vote
1 answer

QBO3 database deployment does not create Entity view

When deploying a database theme to create a new QBO3 database, the Entity view was not created. My theme includes references to the following .sqlproj projects: Standard Mortgage Credit Debt And I see that the Standard.sqlproj > Scripts >…
Eric Patrick
  • 2,097
  • 2
  • 20
  • 31
1
vote
1 answer

Building dacpac only when there are changes

Using Visual Studio 2015 and TFS 2012. We use a TFS build server to build and deploy our project. Building and deploying the dacpac for our database takes up most of our deployment time. A lot of times, there are no changes to the database. Is it…
Nick
  • 841
  • 2
  • 9
  • 30
1
vote
1 answer

publishing .sqlproj database project

I'm trying to build a .sqlproj database project and I'm getting the following error: The "SqlServerVerification" parameter is not supported by the "SqlBuildTask" task. Verify the parameter exists on the task, and it is a settable public instance…
El Facha
  • 113
  • 4
1
vote
2 answers

SSDT publish script recreates procedures with no changes

I have a database imported into a .sqlproj, and a .publish.xml publish profile which publishes changes to a remote DB. My understanding is that when I right click -> Publish -> Generate Script, it should calculate the diff between the local…
Taran
  • 12,822
  • 3
  • 43
  • 47
1
vote
1 answer

Stored Procedure gets published encrypted

So I made a simple stored procedure with SQLCLR and published it to my database. There are already some SPs and they are all not encrypted, only my published SP is encrypted. I googled for hours but could not find out how to turn the encryption off.…
Siggi
  • 101
  • 1
  • 10
1
vote
0 answers

EF Migration equivalent for sqlproj projects in VS

We're evaluating a setup where we have a solution with two projects, one is an asp.net 5 project using EF7, the other is a full-blown sqlproj that actually manages the database. One thing I'm curious about is whether sqlproj has some kind of data…
gzak
  • 3,908
  • 6
  • 33
  • 56
1
vote
3 answers

C# VS 2013 Error 02019: Invalid target type for /target: must specify 'exe', 'winexe', 'library', 'module', 'appcontainerexe' or 'winmdobj' CSC

I work on a website that uses various class libraries that are occasionally updated. One of the libraries is a sqlproj file and I believe it was made with VS2010. It is a dependency for other libraries and I'm not able to build/rebuild my solution…
Justin L.
  • 993
  • 14
  • 33
1
vote
1 answer

How to make SQL projects load version from props file?

I have created several SQL projects in visual studio, I want to manage the version of the dacpac in a centralized way. In order to fulfill that I want to reuse a props file using the answer this post :
XtianGIS
  • 967
  • 16
  • 39
1
vote
2 answers

SQL Server Project View references tables from different Database

I am converting a database model into a SQLModel so we can start deploying with a dacpac. I have completed this with a few other databases but none references external databases. I have an issue where a couple views and stored procedures reference…
greektreat
  • 2,329
  • 3
  • 30
  • 53
1
vote
1 answer

Multiple-domain security with SSDT .sqlproj projects?

I'm doing a small pilot project trying to implement Sql Server Data Tools sqlproj projects in order to better bring our databases under source control. In my organization, we have separate no-trust domains for test environments of various purposes,…
bwerks
  • 8,651
  • 14
  • 68
  • 100
1
vote
0 answers

SQLPackage - Comparing between two dacpacs always contains objects related to linked server

first I'm sory for my broken English. I have two different databases in two different SQL instances, and both instances have references to each other by linked server. I have added this references in the database solution and use a variable to…
R G
  • 21
  • 4
1
vote
1 answer

How to cope with SQL Server 2012 vs SQL (Azure) Database sql files

I'm trying to port my system to SQL Database (Azure instance) from SQL Server 2012. I'm using Visual Studio 2013 and I have my .sqlproj with all the definition of my database inside. Given that a number of SQL statements are not available in SQL…
Cristiano Ghersi
  • 1,944
  • 1
  • 20
  • 46
1 2 3
4
5 6 7