The database-projects tag has no usage guidance.
0
votes
1answer
63 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
55 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
vote
1answer
169 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.
...
1
vote
0answers
58 views
SQL Server - Project based on the TDS protocol [closed]
From what I understand, TDS is an application level request/response protocol used for communication between a client and SQL server.
Now, I'm in the process of finding a master thesis (computer ...
-1
votes
1answer
56 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 ...
0
votes
1answer
74 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 ...
1
vote
1answer
398 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 which multiple modules and each modules has it's ...
1
vote
0answers
37 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 ...
3
votes
0answers
3k views
SQL Server Projects in Visual Studio 2013 [closed]
I am looking for information regarding Visual Studio 2013 and working with SQL Server projects. We are currently working on a project where we are using a database that already exists and is used by ...
4
votes
1answer
2k 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 ...
