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 ...
- 231
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
...
- 715
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 [...
- 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 ...
- 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 ...
- 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 ...
- 2,040
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 ...
- 31
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)...
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 ...
- 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 ...
- 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 ...
- 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-...
- 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!
- 191
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 ...
- 66.1k
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....
- 66.1k
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 ...
- 753
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 ...
- 177k
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 ...
- 649
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)
...
- 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 ...
- 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. ...
- 41.4k
Only top scored, non community-wiki answers of a minimum length are eligible