Stack Overflow
Stack Overflow

Questions tagged [visual-studio-dbpro]

This tag refers to Microsoft's Visual Studio Team System Database Edition. In earlier versions of the product the database edition was known as "Database Professional" aka "DB Pro".

25 questions
296
votes
1 answer

What is the function of the DBMDL File in VS database project

What is the function of the DBMDL file in a visual studio database project?
Jet Basrawi
  • 3,185
  • 2
  • 15
  • 14
6
votes
4 answers

Which files from a VSTS Database Edition GDR R2 project should be excluded from source control?

I'm getting ready to setup a Visual Studio Database Edition GDR R2 project with source control. Which files (if any), should be excluded from source control?
Rob Boek
  • 1,953
  • 16
  • 20
5
votes
1 answer

Vs2010 Data Generation Plan fails with "Data generation failed because of the following exception: Column "xyz" does not allow DBNull.Value"

I'm fairly new to Vs Data capabilities, and this is my first data generation plan. I have implemented a database using a Vs2010 database project, and used it to deploy to a sql server express 2008 database. All the tables use identity columns as…
bwerks
  • 8,651
  • 14
  • 68
  • 100
4
votes
4 answers

VS2010 DB Project Deploy Error SQL01268 Directory Lookup Failed

My VS2010 database deploy is failing on my build server, which has SQL Server 2008 R2 installed on it. Here's the output that's relevant: Creating…
ssmith
  • 8,092
  • 6
  • 52
  • 93
4
votes
4 answers

Visual Studio Database Professional GDR R2 takes a long time to serialize DBMDL file

The amount of time it takes to completely serialize the DBMDL (to finish "Your project will be available after 10000 operations are completed) is becoming a hindrance to productivity. I've done what I can to optimize disk activity (excluding my…
Nicolas Webb
  • 1,312
  • 10
  • 22
4
votes
2 answers

How to resolve "procedure has an unresolved reference to object dbo.sysssislog"

I have a Visual Studio 2010 database project and I have imported an existing schema. There are stored procedures in this database that refer to the Integration Services system table dbo.sysssislog and is generating a number of warnings in my…
Nick H
  • 433
  • 1
  • 3
  • 10
3
votes
0 answers

How to automatically regenerate DB partial project files?

I am using advanced version of Visual Studio 2010 and using database projects. There's a feature of exporting database schema as partial project (which creates *.files output file), but it is triggered manually by the developer (you need to…
trysil
  • 31
  • 3
3
votes
0 answers

Visual Studio Database Pro Partial Projects Constraints Issue

In Visual Studio 2008 Database edition one can use "partial projects" to allow a database to be separated into multiple projects for deployment and maintainability. I have been looking into doing this with our project but hit the following snag: If…
t3rse
  • 10,024
  • 11
  • 57
  • 84
3
votes
1 answer

Database deploy with VSDBCMD.exe not using integrated security

I'm trying to deploy a Visual Studio Database Project (GDR R2) using the VSDBCMD.exe utility. I can successfully deploy when the connection string is using Integrated Security, but when I switch to using a Sql Server authentication I get the…
Adam Goetz
  • 43
  • 4
3
votes
1 answer

How to build .dbproj without VSTS DB installed?

Is it possible to build Visual Studio Database Project (.dbproj) on a machine without Visual Studio Team Suite or Team Foundation Build installed? I've got a "clean" machine running CC.NET and would like to automatically build .dbproj projects…
user168660
2
votes
2 answers

Visual Studio DB project fails to detect changes to stored procedure parameters. Is that normal?

Whilst working on a SQL Server 2008 database project in Visual Studio 2010 I added a new parameter to an existing stored procedure definition. When I built the project it failed to detect that references to the sproc elsewhere in the project did…
samaspin
  • 2,342
  • 1
  • 26
  • 31
2
votes
1 answer

How to edit default templates for database objects using VSTS 2008 Database Edition GDR Version

I'm giving Visual Studio Team System 2008 Database Edition (GDR Version) a go on a new project I'm working on and have come up against a slightly annoying problem that I am hoping someone knows how to resolve. In a nutshell, I would like to alter…
Tim Lentine
  • 7,782
  • 5
  • 35
  • 40
2
votes
0 answers

Is there any way to get the visual studio 2010 task list to work with database projects?

Is there any way to get the visual studio 2010 task list to work with database projects?
Rob Boek
  • 1,953
  • 16
  • 20
2
votes
2 answers

Build->Deploy doesn't work for database projects

I have a database project in Visual Studio 2012. When selecting "Deploy MyDBProj" on the Build menu nothing happens. When I hit F5 to debug however, the database project is deployed, using the settings in the debug section of the database project…
Anders Abel
  • 67,989
  • 17
  • 150
  • 217
2
votes
1 answer

How do you make the unit test sleep for a period of time within the database pro version of visual studio?

using visual studio (database pro) 2008, i have created a unit test (using the SQL unit test) that tests several stored procedures in order. The solution is designed to call each SP after a period of time, not within the same second. Thus the unit…
TheRealQuagmire
  • 411
  • 1
  • 3
  • 10
1
2