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 the default templates used to generate database objects, particularly stored procedures. In...
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 you have project that defines some base tables, and then you have a different project th...
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? ...
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 settings or upload any server level stuff. I only have the server project because my DB p...
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 test fail and requires a short pause between each call. Any ideas? is there a standard...
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 using MSBuild. I wonder is it possible to copy required .targets files and some .dll and make...
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 following error: Failed to import target model MyCatalog. Detailed message The Reverse Engineer ...
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 personal TEMP folder from the virus scanner, along with my local source repository). Short o...
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 our projects. However, I am not sure how well this will work with projects that share a ...
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 encountered. I couldn't find much on this error, and I am unclear what is the conflict. I have t...
Is there any way to get the visual studio 2010 task list to work with database projects? ...
Hi, 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 variable ProjectName so I could easely deploy different project data. Something like this ...
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 Acme.Database... D:\TeamCity\BuildAgent\Work\da2fc5ebd5805d44\src\Acme.Database\sql\Acme.Database.sql(30,0): Error SQL01268: .Net SqlClient Data Provider: Msg 5133, Level 16, State 1, Line 1 ...