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
0
votes
0 answers

VS 2019 dacpac file will NOT let me choose to suppress reference warnings. Any suggestions how to fix?

I added a database reference to a visual studio 2019 database project. It was built by another developer, but that shouldn't matter. I point to the dacpac file and select "Same Database" as my database location and check the box to suppress…
C Post
  • 46
  • 4
0
votes
0 answers

Determine the first occurrence of a particular customer visiting the store in a particular month

I need to determine the counts breakdown to per month (and year) of customers [alias'ed as Patient_ID] which made their first visit to a store. The date times of store visits are stored in the [MDT Review Date] column of the table. Customers can…
Gauransh Bhutani
  • 1
  • 1
0
votes
1 answer

Is there any way to build and publish locally a .sqlproj on Linux

I am currently trying to find a work around to build and publish locally a .sqlproj project. Apparently this is meant to be done using SSDT tools provided by Visual Studio, which is not available on Linux. My question is, what are my options? What…
Stephanos B.
  • 340
  • 3
  • 15
0
votes
1 answer

Include sql file into a SQL Database project programmatically

I am using t4 templates to generate code. One of the parts I am generating is sql code and I would like to add it to a SQL DB project in my solution. What I tried so far is: var p = new…
Tarta
  • 1,729
  • 1
  • 29
  • 63
0
votes
1 answer

How to load VS Database Project from .NET Core app?

There is an Visual Studio SQL Server Database Project with such import lines inside .sqlproj file by default: 11.0