I'm in the research phase trying to adopt 2012 Database Projects on an existing small project. I'm a C# developer, not a DBA, so I'm not particularly fluent with best practices. I've been searching...

Can anybody please clarify the difference between build, publish, deploy, and compare+update in SQL Server Data Tools (SSDT) 2012 ?

I am using SSDT to manage my database. Right now it generates SQLCMD deployment scripts. Is there any way to have it generate plain t-sql scripts?

Normally we can format code or markup in visual studio with Ctrl + K + D shortkeys. How we can format SQL script code like stored procedures or views or other things using shortkeys? Note...

I got SQL Server 2012 installed on my machine and I have SSDT to create BI projects. Today i installed Visual Studio 2012; but i cannot create any of BI projects in Visual Studio 2012. Is there a...

With VS2010 database projects, I could define a target (or not) database, set an action (create script only or create script and deploy to target), execute a "deploy" (through VS or MSBuild) and ge...

In my database project, I have added a reference to a linked server. When I use this linked server in a view and try to build my database project, SSDT reports errors because it cannot understand r...

For seemingly no reason, choosing SQL > Schema Compare > New Schema Comparison and then attempting to "select source" causes Visual Studio 2012 to crash. (It has been working as expected for months...

I have a SQL Server Database Project targeting a SQL Server 2012 RC0 database. The project was created in Visual Studio 2010 + SQL Server Data Tools CTP4. (The project type is different than the re...

When working with a Database Project in Visual Studio 2012, VS defaults to the "Design-View" pane when you add or edit a table. While you can work in split-screen mode, the T-SQL pane defaults to t...

I am using SQL Server Data Tools (SSDT) to manage my database schema. Every time I choose to publish changes to my schema, the script contains the following bit: IF EXISTS (SELECT 1 FROM [master]...

I have just installed vs2010 sp1 ultimate, sqlserver 2012 and the latest version of sqlserver data tools. I have opened up a solution from source control and receive a bunch of error like the follo...

I am new to SSDT and I am trying to find a way to ignore some tables when I am comparing schema using the ssdt UI in Visual Studio. Is there a way to do this in SSDT. I think it is possible via com...

I've just started dabbling with SSDT and hit an issue already. My solution consists of 2 databases. Both databases reference each other with the use of synonyms. Thus we have circular references a...

I'm starting to use Visual Studio 2012 with integrated SQL Server Data Tools and although I watched 2 of microsoft's video's on getting started with SQL Database Projects I'm still having trouble u...

I have two SSDT projects. Database1 references Database2. When deploying Database1, Table2 (from Database2) is deployed as expected. That is because when I am deploying, the check box "Include c...

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 ca...

I am working on a Linq based CLR Stored Procedure for some complex filtering and manipulation, which would otherwise require a lot of messy and poorly performant T-SQL code, if implemented in a mor...