database-edition

How to organise a VSTS Database Edition Solution/Project (GDR)?

We use TFS and are looking at using VSTS Database Edition GDR . I would like to know the best way to structure our projects and wondered if anyone has any experience in this. Let me explain our environment. We have 3 environments, DEV , TST and PROD. Each of these have multiple databases. Currently, we have solution file(s) for eac...

Visual studio database edition: deploy to db without visual studio

Visual Studio database edition comes with a tool, vsdbcmd.exe, that should allow someone to deploy a .dbschema file (which is generated by the database project on build) to a database. It does this by first building the script, then executing it: vsdbcmd.exe /a:Deploy /cs:"Data Source=(local);Integrated Security=True;Pooling=False" /...

Database msi installer using Team System Database Edition

Has anyone developed a msi setup for database using an embedded resource for the sql scripts. The sql scripts should be the output of the Databse project of Team System Database Edition (Database project) ...

VS DB Edition - Database Project vs. Server Project

When creating a new database project with the Database Edition of Visual Studio, you can choose to create either a Database Project or a Server Project. What is the difference between the two? The resulting projects seem to be pretty much identical. The server project still seems to target a single database. (For the record, I'm using V...

Can SQL Server 2008 Enterprise Edition install to Windows 7 Professional Edition?

I want to install SQL Server 2008 Enterprise Edition to Windows 7 Professional Edition. I tried many times, but it also failed. Is it possible to do that? Anyone has successful to install on this case? Best regards, On ...

GDR - deploying multiple database targets with one project

I'm using Visual Studio Team System 2008 with GDR Version 9.1.40413.00 and am trying to resolve the issue of deploying a single DB project to multiple databases. For instance if I have a Performance.DB project I would like to deploy databases called Performance, Performance2, Performance3 etc. However it seems if you go to the properti...

Visual Studio 2008 Database Edition - how to Source control with visualsvn and other db features in vsts db edition?

Hi there, I was wondering if anyone has any links to tutorials or walk throughs for managing db's with vsts Database edition? Specifically i am looking how to do source control with visualsvn? I have downloaded the R2 GDR which updated my vs 2008 with the sql server 2008 templates I don't have a problem with vs 2008 but i am bit conf...

VSTS Database Edition - Intellisense for creating tables etc?

Hi There, Just begin starting to use Visual Studio 2008 database edition and loving it.... but there doesn't seem to be any intellisense inside create table for example .. in the editor ... and it also appears you can't add a table graphically like you can in SSMS ... Is this true, any tricks of ways round it or plugins or something,...

Visual Studio + Database Edition + CDC = Deploy Fail

Hi All, I've got a database using change data capture (CDC) that is created from a Visual Studio database project (GDR2). My problem is that I have a stored procedure that is analyzing the CDC information and then returning data. How is that a problem you ask? Well, the order of operation is as follows. Pre-deployment Script Tables...

Visual Studio Team System 2008 Database Edition - no Code Analysis tools?

I can't find the code analsis tool in Visual Studio Team System 2008 Database Edition. Is this feature not available in the Database Edition? ...

You have insufficient permissions to create the database project

I am running Vista and I am not using Admin user. I tried with an Admin username too, but it did not work. Any ideas? ...

Visual Studio Database Edition - Do I have the Current Version?

Is there a way I can tell if I have the latest version of Visual Studio Database Edition? When I select Help in my VS 2008, I see the following entry for Database Edition: Microsoft Visual Studio Team System 2008 Database Edition 91901-270-3346032-60220 Microsoft Visual Studio Team System 2008 Database Edition ...

Is it possible to automatically deploy dependent database projects in VS2008 Database Edition?

Is it possible to automatically deploy dependent database projects in VS2008 Database Edition? I have two database projects, let's call them A and B. B depends on A (B doesn't create the database but A does, etc.). I want to be able to 'Deploy' B on demand and have A automatically deploy first. I know it's possible to configure the s...

Is it possible to run Visual Studio Database Edition schema migrations from the command line?

Visual Studio 2008 Database Edition (Data Dude) has the ability to perform schema comparisons between databases and generate a script which migrates from one database to the other. Is it possible to perform this comparison and generate the migration script from the command line? If so, what are the command line tools, and are the same to...

Issues Visual Studio Team System 2008 Database Edition and GDR

I have Visual Studio Team System 2008 Team Suite, that included Visual Studio Team System 2008 Database Edition. I have VS 2008 SP1, .net framework 3.5 sp1. In a project SQL parser, we need to add two assembly references two: Microsoft.Data.Schema.ScriptDom.dll Microsoft.Data.Schema.ScriptDom.Sql.dll those assemblies: are in Vi...