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
15
votes
1 answer

Is there a way to suppress SQL03006 error in VS2010 database project?

First of all, I know that the error I am getting can be resolved by creating reference project (of type Database Server) and then referencing it in my Database project... However, I find this to be overkill, especially for small teams where there is…
zam6ak
  • 7,229
  • 11
  • 46
  • 84
13
votes
1 answer

Does wrapping nullable columns in ISNULL cause table scans?

Code analysis rule SR0007 for Visual Studio 2010 database projects states that: You should explicitly indicate how to handle NULL values in comparison expressions by wrapping each column that can contain a NULL value in an ISNULL function. However…
Tom Hunter
  • 5,714
  • 10
  • 51
  • 76
13
votes
4 answers

VS 2010 build database project receive SQL04151

I just started working with the Visual Studio 2010 Premium database project. I must say it does indeed rock. One thing I can't figure out is how to avoid the SQL04151 warning Procedure: [dbo].[MyProc] has an unresolved reference to object …
beezler
  • 646
  • 6
  • 18
9
votes
2 answers

Is there a way in a visual studio database project to exclude certain object during deployment?

I have a scenario where I am using a visual studio 2010 database project to deploy changes to multiple database installations, but on certain ones I want to exclude a set of views from that copy. Is there a way using build configurations to exclude…
Jason
  • 2,701
  • 2
  • 25
  • 35
6
votes
2 answers

vsdbcmd data loss may occur, but where?

When using vsdbcmd to deploy my database: vsdbcmd.exe /a:Deploy /manifest:MyDatabase.deploymanifest I Get: SQL01268 .Net SqlClient Data Provider: Msg 50000, Level 16, State 127, Line 6 Rows were detected. The schema update is terminating because…
Matt
  • 1,494
  • 2
  • 18
  • 38
6
votes
5 answers

Is there a table designer for VS2010 database project?

Am I missing something here? It seems that the only options to create a new table in a database project in VS2010 is: Create a table object as a file, then create all constraints (defaults) as separate files, then create each index as a separate…
Richard B
  • 1,183
  • 1
  • 10
  • 22
6
votes
1 answer

Syncing permissions between a Database project and a database using Visual studio

I have a database project in visual studio (2008) that I am using to keep my database structure in a version control system (Git). I use the data schema compare tool in VS to maintain this database project. The issue that I'm encountering is that…
Dug
  • 825
  • 1
  • 9
  • 19
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
5
votes
1 answer

RedGate SQL tools v Microsoft Visual Studio Team System Database Edition (Data Dude)

I've been looking at RedGate's SQL tools and Microsofts Visual Studio Team System Database Edition (formerly Data Dude) for use within a testing and continuous integration environment. What we need to be able to do is have: Schema and Data under…
Gilbert Liddell
  • 1,203
  • 4
  • 14
  • 21
4
votes
3 answers

VS 2010 Database Project dropping data on column name change

I am testing out the new database project features of Visual Studio 2010 and want to change the name of a column in a table. I changed the name in the create script and deployed it against the database. The script that was generated just dropped…
Keith Sirmons
  • 8,271
  • 15
  • 52
  • 75
3
votes
1 answer

Frequent Setup and Tear Down of SQL Server Replication

I am using the Visual Studio Database Project for my database. I have it setup to auto-build twice a week. When it builds it drops the database and recreates it from scripts. I really like the tear down and re-build system as it prevents junk from…
Vaccano
  • 78,325
  • 149
  • 468
  • 850
3
votes
2 answers

Schema Compare and Update comments out unused code

I have a Visual Studio 2010 Database Project. It works great for most stuff. However one thing is very annoying. Say I have a table called dbo.MyCoolTable. If I go the the database and rename it to dbo.MyKindaCoolTable it works fine in the…
Vaccano
  • 78,325
  • 149
  • 468
  • 850
3
votes
3 answers

Why does Schema Compare in Visual Studio 2010 show differences when there are none?

I had hoped that Visual Studio 2010 would have brought some improvements to the Schema Comparison function. I suspect there are some, but I can't get something basic working. I've sucked in a schema from a SQL Server 2005 database. Then to assure…
Howard Pinsley
  • 11,300
  • 15
  • 49
  • 66
3
votes
1 answer

VS for Database Developers: Lookup Tables

How to you handle the contents of lookup tables that should be treated as "code" rather than data?
Jonathan Allen
  • 68,373
  • 70
  • 259
  • 447
3
votes
6 answers

Using nullable columns in a WHERE clause

Assume a table definition in SQL Server as follows: CREATE TABLE MyTable ( Id UNIQUEIDENTIFIER NULL, Info VARCHAR(MAX) ) And a query: DECLARE @id UNIQUEIDENTIFIER DECLARE @info VARCHAR(MAX) IF @id IS NOT NULL BEGIN SELECT @info = Info …
RickNZ
  • 18,448
  • 3
  • 51
  • 66
1
2 3