Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [database-projects]

24 questions
15
votes
3 answers

"Unresolved reference to User" after importing as a VS DB project

I just imported an existing SQL Server 2008R2 production database into a VS 2013 database project. I now get a number of errors along the lines of Error SQL71501: User: [mydbuser] has an unresolved reference to Login [mydbuser]. I don't really need…
Greg
  • 407
  • 1
  • 3
  • 11
9
votes
1 answer

Reference assembly in sqlproj not being deployed to server

I have a Visual Studio 2013 Database Project which takes a modified version of fastJSON as a reference. I selected Generate DDL in the reference properties as shown in this screenshot: And in the .sqlproj msbuild file:
Justin Dearing
  • 2,717
  • 6
  • 36
  • 52
5
votes
1 answer

SQLPackage resets database recovery model

I am using SQLPackage.exe with database publish profiles to deploy database changes to DEV and QC instances. I have databases in simple recovery mode. But when I deploy changes using SQLPackage, it reverts them to full recovery mode. This is what I…
JackLock
  • 466
  • 1
  • 5
  • 18
5
votes
1 answer

SSDT project with working linked server references gets SQL71562 warning

I have a VS 2013 solution with two database projects. One of them, let's call it the "worker" is supposed to get deployed to about 10 different production servers. The other one, that is supposed to work as an "Controller" instance, is basically…
Magier
  • 4,827
  • 8
  • 48
  • 91
4
votes
1 answer

Will SSDT publish always fail with "Data Loss May Occur" when table is rebuilt?

Consider the following scenario: We have a SSDT database project. We add a new column to the middle of a table. This forces the database project to rebuild the table in order to deploy the change. We publish this SSDT database project with the…
jacobappleton
  • 298
  • 3
  • 8
4
votes
2 answers

How to delete stored procedures from a database project and have that reflect on the server?

I have a Visual Studio database project with several stored procedures. I deleted one of them and then published the project. But the SP was still present on the published database and I had to delete manually. I would want the VS project to be the…
Zach Smith
  • 2,430
  • 13
  • 34
  • 65
3
votes
1 answer

deploy only a new schema as a separate database project without affecting existing production DB code

We have a production database (SQL Server 2019) with existing code (tables, procedures, functions, synonyms) that was deployed without a source repository. Our client wants to introduce a new schema with new code, but keep all the old code and data…
adam.g
  • 465
  • 2
  • 11
3
votes
1 answer

Make SQL Server SSDT Database Project Reference Different in Publish Profile

In a SSDT Database project, I know how to publish the Self-Database to different locations. I can change eg, the Customer database name in the Publish profile. Example In: Dev Environment: will publish profile to CustomerDevDB QA Environment: will…
user162241
3
votes
1 answer

how do you reference server logins from a visual Studio database project?

I'm looking for a way to move all our SQL Server databases (on one server) into source control. I tried creating a solution, and then adding VS database projects to the solution that correspond to the SQL Server databases. As I was creating the…
Zach Smith
  • 2,430
  • 13
  • 34
  • 65
3
votes
3 answers

Visual Studio database project and Enity Framework code-first

At work we are developing our latest module in C# Entity framework code-first approach. I have been given the role of developing databases from the DBContexts from within the project/s. I generated the tables/entities from the DBContext and created…
Guygar
  • 131
  • 1
  • 2
3
votes
2 answers

Separate license needed for Visual Studio 2012 SQL Server database projects?

We have SQL Server 2014 Standard Edition and would like to use Visual Studio 2012 Database Projects for version control. Do we need to purchase a license to use VS database projects? Or is it included with our standard edition license; we just have…
Keith Rivera
  • 617
  • 2
  • 9
  • 20
2
votes
1 answer

How To Merge Database Projects on Visual Studio 2013

Can I have multiple database projects to the same SQL Server database? Like, one main project referencing multiple subprojects. I have an application with multiple modules and each module has its own database structure living in a schema. I want to…
sergiogarciadev
  • 123
  • 4
2
votes
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
  • 221
  • 2
  • 4
2
votes
1 answer

Storing sensitive information in a SQL Server project

I am very new with encryption in SQL Server so I am stumbling over things that require prior experience. I have done my googling, but I need reassurance so here we go: Scenario I have a SQL Server Project (*.sqlproj) where my team and I put all of…
dyslexicanaboko
  • 121
  • 3
2
votes
1 answer

Link MS Project to Access

I have a large project tracking database used to track PMs, status, help needed, action items, reports etc. I keep the project schedule in a large MS-Project file. I've exhausted all efforts to have my organization invest in an MS-Project…
AdamB
  • 88
  • 2
  • 9
1
2