Skip to main content
Share Your Experience: Take the 2024 Developer Survey

Questions tagged [database-projects]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
1 answer
3k views

how to create a calculated column

I want to create a table, this table's name is "Prod", in his table, I have the: ID, name, Buying_price and selling_price when the user inserts the data, I want him to enter "name, and ...
kylie's user avatar
  • 41
0 votes
0 answers
232 views

Visual Studio Data Tools (SSDT) schema comparison tool does not match database objects

I am using Visual Studio Pro 2019 (16.9.4) and SQL Server Data Tools (16.0.62103.10080) but this happens since the beginning of Visual Studio 2019. I use the Schema Comparison tool to compare ...
Alex's user avatar
  • 101
1 vote
1 answer
411 views

ER Schema - bank system

Hello i'm trying to model a simple banking scheme where I have 3 transactions: withdraw, transfer, deposit. of these 3 operations, the transfer is the only one that needs more attributes, I need to ...
Ming's user avatar
  • 123
1 vote
0 answers
408 views

Postgres setup for multiple projects

I have a Postgres db server setup on my raspberry pi. With this I am working on two distinct projects: Project1 Project2 For these projects I have different users and the users of each should not ...
matthewmturner's user avatar
5 votes
1 answer
2k views

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 ...
JackLock's user avatar
  • 468
3 votes
1 answer
755 views

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 ...
user avatar
2 votes
1 answer
580 views

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 ...
dyslexicanaboko's user avatar
4 votes
2 answers
4k views

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 ...
Zach Smith's user avatar
  • 2,370
3 votes
1 answer
4k views

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 ...
Zach Smith's user avatar
  • 2,370
1 vote
1 answer
706 views

How to avoid dropping schemas when publishing DB in SSDT Database project

When publishing a database from SSDT, there are several options to "do not drop" an object if it is not in the SSDT project. However, it seems that there is no option to avoid dropping ...
GHauan's user avatar
  • 603
3 votes
3 answers
4k views

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 ...
Guygar's user avatar
  • 131
2 votes
1 answer
3k views

Link MS Project to Access [closed]

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 ...
AdamB's user avatar
  • 88
0 votes
1 answer
2k views

Access Gantt Chart

I designed and maintained a database used to track my organizations projects. Access frontend with a SQL backend. I have a table for all the scheduling events. Task, Start, Finish, duration etc. ...
AdamB's user avatar
  • 88
3 votes
2 answers
157 views

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

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 ...
Keith Rivera's user avatar
5 votes
1 answer
7k views

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 ...
Magier's user avatar
  • 4,787
15 votes
3 answers
34k views

"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 ...
Greg's user avatar
  • 407
1 vote
2 answers
115 views

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

I am using SQL Server 2008 for product development Currently application is live with 20 users now if I want to check how my database is growing and how much it will grow in month or year projection ...
Yogesh's user avatar
  • 25
-1 votes
1 answer
100 views

Which one is best solution for future database structure?

I'm working on a big web application. so i need to create user_preference_table it has the marks for every users for each attributes. here attributes are games so in the user_preference_table i need ...
Thamaraiselvam's user avatar
4 votes
1 answer
3k views

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 ...
jacobappleton's user avatar
0 votes
1 answer
884 views

Create food database

I'm working on a project for a database that contains, in the best way, the nutritional values ​​of foods. They are divided according to type of food, eg Breakfast, Lunch, Dinner. For portions of the ...
Sergeyweb's user avatar
2 votes
1 answer
2k views

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 ...
sergiogarciadev's user avatar
2 votes
1 answer
131 views

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 ...
Cristiano Ghersi's user avatar
9 votes
1 answer
7k views

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 ....
Justin Dearing's user avatar