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
1 answer

Remove warnings when referencing system stored procedures in SQLProj

I use a SQLproj to create a dacpac, and I have stored procedures in it that references systems stored procs. exec @Result1 = sp_addarticle .... When I compile, I have warnings : Warning SQL71502: Procedure: [dbo].[MyProc] has an unresolved…
glacasa
  • 1,770
  • 2
  • 16
  • 32
0
votes
3 answers

Build and publish sqlproj from code for integration testing

I have a (2015) solution with a database (SQL Server 2008) project (.sqlproj) and I want to write integration tests using this database project. I need to recreate the database for each test but I can't seem to get it to work using…
grmbl
  • 2,514
  • 4
  • 29
  • 54
0
votes
1 answer

SourceGear merge of .sqlproj files

We use Sourcegear Vault Standard version 8.0.1 (299) with VS2013. The .sqlproj file extension has been added to the inclusion list and now when doing a merge Vault wants to overwrite the project file. As a general rule I think that is a bad idea.…
Rod C
  • 56
  • 9
0
votes
2 answers

Export Bacpac from 2008 R2 fails on Azure validation rules

I'm exploring the SSDT .NET class offering in Microsoft.SqlServer.Dac.dll using Powershell, and I'm trying to work a database into a source-control-based SDLC as a proof of concept. The first thing I tried was to export a bacpac so that we could…
bwerks
  • 8,651
  • 14
  • 68
  • 100
0
votes
0 answers

User in .sqlproj causes duplication error

We are using visual studio database projects to define our databases and deploy them. CREATE LOGIN [My_User] CREATE USER [MY_User] FOR LOGIN [My_User] WITH DEFAULT_SCHEMA=[dbo] And it works fine when deploying locally. But when deploying on the…
MrFox
  • 4,852
  • 7
  • 45
  • 81
0
votes
1 answer

Using Visual Studio Database Projects when not dbo

I am a new user of the Visual Studio Database Project, and I am inching in. However, I am not the dbo, and do not have all rights. Does that mean that I am UNABLE to use this type of project? When I try the Schema Compare, and try to update the…
Kevin
  • 61
  • 1
  • 7
0
votes
1 answer

How-To Set and Get Build Version in TFS SQL Project

I'm using TFS in Visual Studio 2013 & SSDT to create various SQL Database scripts. i.e. I'm doing all my SQL DB development via VS not SSMS. Want I'm now trying to achieve is to generate/retreive a version number from an external text file when the…
Simon Wray
  • 192
  • 4
  • 12
0
votes
1 answer

Error SQL71501 when Rebuilding new dacpac from an existing dacpac

I have a requirement to merge multiple dacpacs into a single dacpac so using the example (http://dacsamples.codeplex.com), when I attempt to build using Microsoft.SqlServer.Dac.Extensions.dll - DacPackageExtensions.BuildPackage() method, I get…
Rubans
  • 4,188
  • 6
  • 40
  • 58
0
votes
2 answers

SQL Error: Operand should contain 1 column

While working on a system I'm creating, I attempted to use the following query in my project: SELECT WEEKLY_TOTALS.DOMAIN, WEEKLY_TOTALS.CATEGORY, DAY FROM( (SELECT DOMAIN,CATEGORY,DAY,CNT FROM BASE_DATA) AS DAY_CNTS INNER JOIN …
Matt Dannheisser
  • 3
  • 2
0
votes
0 answers

why use a mdf if using a sqlproj in MVC project

I set up a MVC 4 project and created a sqlproj to store all my database objects. I can publish it to sql express and then to Azure just fine. I know there is a .mdf file for an actual database that gets placed into the app_data folder in my…
chuckd
  • 13,460
  • 29
  • 152
  • 331
0
votes
1 answer

Can I use a .sqlproj file in my .vbproj environment?

I just got VS2013 because I had to do a system restore... unfortunately during the system restore my project's DB files didn't make it over. So, rather than build a LocalDB from my .vbproj environment I decided to manage it in a separate SQL…
turbonate
  • 159
  • 2
  • 13
1 2 3 4 5 6
7