13 votes

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

I had the same problem and found this link User has an unresolved reference to Login If you create application specific logins (which you should) then you are going to come across this error ...
user avatar
11 votes
Accepted

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

The easiest way is to not manage users through ssdt (most people don't). So you can just strip them out and don't deploy logins or users. There are three ways: the new options to ignore users/logins ...
user avatar
6 votes

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

Apparently, this issue is still occurring on VS2017 database projects as well. I've managed to solve it by first creating the login and then create the user. -- Windows Account CREATE LOGIN [...
user avatar
  • 161
5 votes
Accepted

SQLPackage resets database recovery model

You're right, as far as I know, that there's nothing in the sqlpackage publish options that would change the recovery model. That property is set in the dacpac. If you have access to the source code ...
user avatar
  • 27.4k
3 votes
Accepted

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

You don't need a special SQL Server license to use Visual Studio database projects. As mentioned in srutzky's answer the database projects are driven by SSDT which is a free download. If you are ...
user avatar
  • 4,722
3 votes

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

Right click on references in your SSDT project. Click on Add Database reference. Fill out the database reference information here. I bring in the server I am connecting to as a dacpac object, then ...
user avatar
3 votes

Visual Studio database project and Enity Framework code-first

Here is and article explaining a good way to do this will little extra effort. The article describes comparing the SQL Database Project with the EF generated LocalDB to persist schema changes. Use ...
user avatar
3 votes
Accepted

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

Yes, you can rely on that. When you enable the "BlockOnDataLoss" attribute what actually happens is that SSDT adds to the deployment script a check like this one IF EXISTS(SELECT 1 FROM TableToChange)...
user avatar
3 votes
Accepted

Looking for application which will provide to determine project database growth and cost per day or month

You can use a third party tool Idera Diagnostic Manager to identify the growth and cost. There is a report inbuilt which forecast database and table growth depending upon how much historical data it ...
user avatar
  • 6,995
2 votes

Looking for application which will provide to determine project database growth and cost per day or month

exec sp_helpdb gives you the size of each database. You can create a table dbsize and do insert into dbsize exec sp_helpdb to insert data into it once a week using a job. After a month, you can see ...
user avatar
  • 1,086
2 votes

Which one is best solution for future database structure?

You can create one table for saving GamesType as with two column GameId(primary Key) and GameName and in user preference table you can have as Userid &GameId where GameId will be the foreign ...
user avatar
  • 2,688
2 votes
Accepted

How To Merge Database Projects on Visual Studio 2013

Certainly appears you can do that in Visual Studio 2012. I just created a Database Project "database1", then added another database project to the same Solution, named "database2". I then right-...
user avatar
  • 67.5k
2 votes

Access Gantt Chart

There are a number of sql report generators that can produce GANTT charts. Might be easier than rolling your own!
user avatar
2 votes

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

I think you mean SSDT (SQL Server Data Tools) which handles Visual Studio Database projects, but can be run independently of Visual Studio. Look into the documentation for SSDT. Start here: Download ...
user avatar
2 votes

SSDT project with working linked server references gets SQL71562 warning

According to the message shown in the Question, this is actually a warning ("warnung") and not an error. An error will stop the build process and prevent the project from being published to the server....
user avatar
2 votes
Accepted

Make SQL Server SSDT Database Project Reference Different in Publish Profile

I'm not sure how to do this in the UI, however, the publish profiles are xml files, and SQL Command variables and their values can be stored within them. In this specific case, you'd want to specify ...
user avatar
2 votes

Storing sensitive information in a SQL Server project

You've got to put these things somewhere, where they are: accessible only to the people who should have access to them; protected from the people who shouldn't; and, recoverable in the event of any ...
user avatar
1 vote
Accepted

ER Schema - bank system

The way I would initially think of this (as an accountant in a previous life) is not as a transfer, but as what is going on in MY bank's account? One stored procedure would deduct funds from one of my ...
user avatar
1 vote
Accepted

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

The easiest way is using "Schema compare", where you would manually select objects to be dropped/ignored/added. to do this: Right click the database in the solution explorer (choose schema compare) ...
user avatar
  • 386
1 vote

Create food database

Some thoughts on the design of this database: For portions, is there only ever one per food? If so it belongs in the food table. Similarly, with the nutritional facts, only per food? If so, probably ...
user avatar
  • 438
1 vote

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

Rather than maintaining two separate code bases, the easier way to do this is by aiming for the lowest common denominator. Try to only use features in the database that are supported in Azure SQL DB. ...
user avatar
  • 41.4k

Only top scored, non community-wiki answers of a minimum length are eligible