Stack Overflow
Stack Overflow

Questions tagged [datadude]

Data Dude is another name for Visual Studio 2008 Database Projects. These have been replaced by SQL Server Data Tools (SSDT) and the SQL Server Project type in Visual Studio 2012.

Data Dude is another name for Visual Studio 2008 Database Projects. These have been replaced by SQL Server Data Tools (SSDT) and the SQL Server Project type in Visual Studio 2012.

For more details see: http://blog.navantis.com/ssdt-vs-data-dude-part-1/

33 questions
3
votes
1 answer

Visual Studio For Database Professionals 2008

Anyone know any a few good references for getting familiar with the SQL Server 2008 Database projects? I am getting a bit overwhelmed and would love to find a walk through for putting this project type to good use. Thanks in advance.
user137667
2
votes
4 answers

How to merge changes from a source-controlled VS2010 database project to local development DB

We're trying out VS2010 database projects for a new development, using the following dev cycle: Use Management Studio to develop changes on a local DB instance (using the designers etc) Use VS2010 schema compare to sync / import these changes to…
Chris Brook
  • 2,335
  • 20
  • 24
2
votes
2 answers

Circular references in Visual Studio Database Edition

I'm using Visual Studio Database Edition to script a number of databases. Many of the databases have references between them - for example, view in database A might do select ... from B..TableX This works fine as long as database B is also a…
Jaco Pretorius
  • 24,380
  • 11
  • 62
  • 94
1
vote
1 answer

VS2010 Partial Database Projects, will they help in my scenario?

Can I use partial Database Projects in the following scenario? I have numerous databases which are all inter-dependent on each other. Database2 executes SPs on Database1 and Database3 and Database3 executes SPs on Database2. For example: Database 1…
Ant Swift
  • 20,089
  • 10
  • 38
  • 55
1
vote
3 answers

When deploying a database project with vsdbcmd I get the error "Vardecimal support is enabled for the database but disabled for the project"

I get: SQL01265 Vardecimal support is enabled for the database but disabled for the project I've tried changing the .sqlsettings files to have: "True" and the .sqldeployment file to have:…
Matt
  • 1,494
  • 2
  • 18
  • 38
1
vote
2 answers

DB Pro (data dude) and Wix3 SqlExtension

I'm attempting to use Wix to create a database during install. I have my database setup with the Db Pro Visual Studio SKU (Data Dude as it's sometimes referred). However, the output seems to be only consumable by sqlcmd.exe since it uses specific…
Peter Oehlert
  • 16,368
  • 6
  • 44
  • 48
1
vote
1 answer

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…
Damian Powell
  • 8,655
  • 7
  • 48
  • 58
1
vote
1 answer

Where to start with Visual Studio for Database Developers

Does anyone have a list of advice, best practices, getting started guides, etc. for VS for Database Developers?
Jonathan Allen
  • 68,373
  • 70
  • 259
  • 447
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
0
votes
1 answer

Scripting Server Objects in a Visual Studio 2010 Database Project

Is the Pre-Deployment script (Script.PreDeployment.sql) the best place to put sql commands that create server level objects (specifically logins in my case)? I need to create server logins for the database users in the project and this seems the…
Darren Lewis
  • 8,338
  • 3
  • 35
  • 55
0
votes
1 answer

Good datadude walkthrough

Could anyone point me to a good walkthrough of Datadude (Visual Studio Database project) and the do's and dont's, with focus on remote deployment? We've been using it for versioning and updating our own test environment. My question is now, what to…
jaspernygaard
  • 3,098
  • 5
  • 35
  • 52
0
votes
1 answer

VS 2010 Database unit testing with custom testcondition

After reading the following article Create Test Conditions for the Database Unit Test Designer on MSDN i decided to try create a custom test condition for my database unit tests Ive met the requirements of either Ultimate or Premium as my…
almog.ori
  • 7,839
  • 1
  • 35
  • 49
0
votes
1 answer

VS2010 DB Project - moving stored proc to another schema

I've got a database under source control using a VS2010 database project. I'm trying to move some stored procs from the [dbo] schema to another schema. When I change the schema name in the project (moved in folder structure plus edited the CREATE…
D. Lambert
  • 1,304
  • 6
  • 12
0
votes
1 answer

How do you fix TSD02016 error in Database

I have a database I am using the Visual Studio 2010 Database Project tool vsdbcmd.exe to create a schema from. vsdbcmd /a:Import /dsp:Sql /model:"Database" /cs:"Server=SqlServer; Initial Catalog=DatabaseName; Integrated Security=SSPI;" The tool is…
Keith Sirmons
  • 8,271
  • 15
  • 52
  • 75
0
votes
1 answer

Visual Studio Database Edition memory problems and auto recompile

Currently storing database of a large application with 2,000 stored procedures in Visual Studio Database Edition. The problem I'm having is that when I try and edit a stored procedure, Visual Studio becomes unresponsive and it can take 30 seconds to…
Simon
  • 196
  • 1
  • 2
  • 10
1
2
3