Questions tagged [database-projects]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
2
votes
1answer
129 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 ...
2
votes
1answer
170 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 ...
2
votes
2answers
1k 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 ...
2
votes
1answer
1k 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 ...
0
votes
1answer
299 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 schemas. Do ...
2
votes
3answers
2k 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 ...
2
votes
1answer
2k 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 ...
0
votes
1answer
1k 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. ...
3
votes
2answers
136 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 ...
4
votes
1answer
4k 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 ...
8
votes
3answers
17k 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 ...
1
vote
2answers
81 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 ...
-1
votes
1answer
93 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 ...
3
votes
1answer
2k 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 ...
0
votes
1answer
420 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 ...
2
votes
1answer
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 ...
2
votes
1answer
75 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 ...
8
votes
1answer
5k 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 ....