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".
Questions tagged [visual-studio-dbpro]
25 questions
1
vote
2 answers
Can I do database deployments, without installing Visual Studio or VSTSDB?
In setting up our TFS 2010 build machine we are trying to avoid installing Visual Studio (2005/2008/2010). For most builds just installing the necessary SDK has allowed us to get good builds w/o visual studio.
However, with VSTSDB (Visual Studio…
BozoJoe
- 6,117
- 4
- 44
- 66
1
vote
1 answer
Using Visual Studio 2008 DBPro to convert database from Sql 2005 to Sql Server 2008
I have a DBPro database project that was created for Sql 2005. I am trying to build this on a different environment, with Sql 2008, and I am getting the following error:
MSBUILD : Build error TSD158: An unsupported target database version was…
Dan
- 59
- 2
- 6
1
vote
1 answer
Data Dude/VS Team System Database - Use with multi project databases
My current project uses Visual Studio Team System for Database Professionals GDR2 (aka DataDude). We are the only application using the database that we model using DataDude.
My company would like to consider using DataDude across the board on all…
Vaccano
- 78,325
- 149
- 468
- 850
1
vote
1 answer
DBProj.dbschema(0,0): Warning SQL01271: The unnamed foreign key between tables X and Y will be checked by checking the table
I received this error while deploying a Visual Studio SQL Server DBProject
DBProj.dbschema(0,0): Warning SQL01271: The unnamed foreign key
between tables [dbo].[Match] and [dbo].[Team] will be checked by
checking the table. Name the foreign…
codingbiz
- 26,179
- 8
- 59
- 96
0
votes
2 answers
TSD00563 Deployment may encounter errors because it depends on [sys].[sp_executesql] and it does not exist in the target database
I'm running into a very annoying issue. One of our SPROC is building up a dynamic bit of SQL which is then executed with sp_executesql (please let's not go into the issues with building up SQL strings for execution).
Using Visual Studio 2010…
Jaans
- 4,598
- 4
- 39
- 49
0
votes
1 answer
How can I automatically kick-off deployment of a VS database project after the deployment of another database project
I have a Visual Studio 2010 solution containing 2 database projects, the primary project is a SQL Server 2005 database project, the secondary project is a 2008 database project. The main 2005 project is deployed when you deploy the solution,…
samaspin
- 2,342
- 1
- 26
- 31
0
votes
2 answers
Visual Studio error when trying to open dbproj files
I have Visual Studio 2008 Database Edition, and everything worked great until the first time I tried to load a .dbproj file. These database project files work for the other developers I work with, but when I try to open it, I just get an error…
Alain
- 26,663
- 20
- 114
- 184
0
votes
1 answer
Dynamically read files in VS DBPro (using SQLCMD)
I'm using VS2008 DBPro. In my PostDeploy file I have many lines like this one
:r .\Data\Test\Classifiers.CodeType.data.sql
:r .\Data\Test\Classifiers.Currency.data.sql
:r .\Data\Test\Classifiers.LOB.data.sql
What I would like is to create a…
Sergej Andrejev
- 9,091
- 11
- 71
- 108
0
votes
1 answer
Custom MSBuild task in DBProj
I've created a custom MSBuild task for our database project. This tasks uses XLSX file to generate reference data insert scripts that get merged into the post deployment script.
I tested this with a test MSBuild proj and it works well.
Now when I…
Jonesie
- 6,997
- 10
- 48
- 66
0
votes
1 answer
Visual Studio DB GDR2 - Can I deploy to a File without SysAdmin Privleges?
I have a Data Solution that has a Database Project and a Server Project.
I want to deploy to an SQL Script. I don't want to have to have SysAdmin privileges on the SQL Server (SQL 2008).
Is there a way to do this? I really don't want to set any…
Vaccano
- 78,325
- 149
- 468
- 850