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
20
votes
3 answers

Visual Studio gets stuck on opening a sql project

We are trying to setup a sql project, in a new machine with Windows 7, VS 2010 with SP1 & SSDT 2010 (installed SSDT 2010 from iso image). But getting the below message when I open the sqlproj. 'Verifying your model is synchronized with your source…
Baga
  • 1,354
  • 13
  • 24
13
votes
3 answers

Build sqlproj on Azure DevOps

I'm trying to use Azure DevOps Pipelines to build my .NET Core 2.1 solution from GitHub. It includes a SQL project that has a TargetFrameworkVersion of v4.6.2. This project always fails to build. Build…
Hand-E-Food
  • 12,368
  • 8
  • 45
  • 80
12
votes
4 answers

Visual Studio Hangs when closing .SQL files

I have all extensions disabled, and only 1 Sql Project open. Yet Visual Studio hangs whenever I close a SQL file. Versions affected: 2017 Enterprise 2015 Enterprise During this "hang time" Visual Studio possesses a Not Responding status. It…
pim
  • 12,019
  • 6
  • 66
  • 69
11
votes
3 answers

SQL Project Dynamically set Recovery Model

We have a SQL Server Database Project (.sqlproj) in Visual Studio 2012 that we use as source control for our database schema. One of the cool things that it does is generate the SQL to update the schema when we release code. We have 3 profiles setup…
Greg
  • 3,442
  • 3
  • 29
  • 50
8
votes
1 answer

How to make SSDT Profile.xml SqlCmdVariable an empty string or optional

I am using SSDT (and sqlproj) for our MSSQL projects. We have a few variables we need to set when publishing to each environment. This works great on most of our environments where we assign values to all of the variables, but when we publish to our…
Saan
  • 544
  • 5
  • 19
7
votes
0 answers

How do I turn off background processing with SQL server data tools in VS2013

I am using Visual studio 2013 with the SQL data tools (SSDT) with SQL project. When I open the project then every time it will checking some background models and showing the message like this "Verifying your model is synchronized with your source…
Tushar Maru
  • 3,347
  • 10
  • 34
  • 53
7
votes
1 answer

Visual Studio .sqlproj always built

When I have an SQL Server Database project (.sqlproj) in Visual Studio solution, I notice that that particular project always gets built every time I build the solution even though there is no change in the project files. This is inconsistent with…
Aditya Santoso
  • 1,031
  • 6
  • 19
7
votes
1 answer

Why does Visual Studio 2013 Schema Compare include Permission Statements for each object definition and treat them as different from the project?

I recently updated one of my projects to Visual Studio 2013. The update changed my .dbproj into a .sqlproj to make it compliant with the new SQL project format. After the conversion, I ran a schema compare against my SQL project and my SQL 2008…
Aaron Hawkins
  • 2,611
  • 1
  • 20
  • 24
7
votes
3 answers

How to include created database project created dacpac into a cs project

I have a separate database project that I’d like to build within the same solution and then reference the created dacpac. When I try adding the database project it builds fine and the dll is added to the secondary project file, but the dacpac is…
Karl
  • 275
  • 1
  • 12
7
votes
1 answer

Database msbuild publish not working from command line

I am trying to Publish a .sqlproj from command line with MSBuild with the command: msbuild /t:Publish [MySqlProjPath] but i get the following error: error MSB4019: The imported project "C:\Program Files…
Arthur Rizzo
  • 333
  • 1
  • 7
6
votes
1 answer

How to deploy SQLPROJ DACPAC to Amazon RDS

We have always done our database design and development with VS2012 SSDT using the .sqlproj extension, and deployed to SQL Server using SQLPackage with a DACPAC... or alternatively setup a publish rule from Visual Studio. We have migrated our…
James Selleck
  • 199
  • 2
  • 9
6
votes
1 answer

Cannot open .sqlproj because it is not supported

I have inherited a VS2010 project that includes a .SQLPROJ. I'm not having any problems with the .csproj. But I am having a problem opening the .SQLPROJ in the solution. When I try to open the .SQLPROJ, I get the following…
Jerry
  • 6,357
  • 8
  • 35
  • 50
5
votes
0 answers

Parameter for path to dacpac file using SqlPublishTask

I am trying to use TeamCity to automate the publish of my database project after it builds. I am using the MSBuild runner with "Publish" targets My SQL project contains a publish profile file "Test.publish.xml" I used this MSBuild parameter to tell…
Glen Thomas
  • 10,190
  • 5
  • 33
  • 65
5
votes
2 answers

Setting SQLProj Pre/PostDeploy scripts to fail build

I'm working to deploy SQLProj (Database Project) via VS2013 and I'm encountering an issue that I could use some feedback on. When I publish changes it executes a CCRD (Create, Copy, Rename, Delete) operation for a table. Create and Copy in the…
swilliams
  • 532
  • 3
  • 11
5
votes
0 answers

How to publish all database projects in a solution in one operation?

Back in VIsual Studio 2010, it was possible to right-click on the solution and pick "Deploy Solution", and it would push all database projects to their respective configured database server(s). In Visual Studio 2013, for database projects "publish"…
user
  • 6,897
  • 8
  • 43
  • 79
1
2 3 4 5 6 7