Schema View for SQL Server Data Tools

Today the team released the first version of the SQL Server Data Tools – Power Tools, which adds the ability to navigate the schema of your project inside the SQL Server Object Explorer. Blog post detailing the release: http://blogs.msdn.com/b/ssdt/archive/2012/04/02/first-release-of-ssdt-power-tools.aspx SSDT Power Tools installation location: http://visualstudiogallery.msdn.microsoft.com/9b0228c6-15d1-44de-9279-66dde12bf861?SRC=Featured Please check it out, @DataDude

0

SQL Connections Spring 2012

Next week, at the SQL Server Connections conference, I will be presenting “Database Development with SQL Server Data Tools”, a 60 minute overview how you can leverage SQL Server Data Tools (SSDT) for your daily database development and deployment tasks. When: Tuesday March 27th 2012, 10:00-11:00AM Abstract: SMS01: Database Development with SQL Server Data Tools…

0

SQL Server Data Tools Released, Available Today!

Today we released the first official release of the “SQL Server Data Tools” (SSDT) to the web. Even though this release accompanies SQL Server 2012 RTM, you can use SSDT against SQL Server 2005 or later, including SQL Azure. So download it now! and get started developing and deploying your SQL Server databases using SQL…

0

SQL Server Developers Tools code-named “Juneau” becomes SQL Server Data Tools (SSDT)

Last week at the SQL PASS SUMMIT 2011 in Seattle, Ted Kummert announced during his keynote that the final name of SQL Server Developers Tools code-named “Juneau” will be SQL Server Data Tools or SSDT for short. Additionally, the final name for SQL Server “Denali” will be SQL Server 2012. Besides the final name there…

0

VSDB Common Pitfalls 1

Symptom: The resulting database deployment script always creates the database This seems to be a common problem users are struggling with like illustrated by the following set of forum post. A user creates a database project, imports an existing database, builds and deploys. The resulting script always performs a CREATE DATABASE, why? The answer is…

0

Let’s pick up blogging again…

Sorry it has been really quiet on this blog for a while now, new job and new projects get in the way. However when going through the MSDN forum for Visual Studio Database Projects it seems there is a need for more hands-on examples and understanding about how the system works and behaves. Besides that…

0

DefaultDataPath

VSDB uses the the ($DefaultDataPath) SQLCMD variable to represent the location where you would place your data and log file of your database. The deployment engine sets the value of SQLCMD variable by querying SQL Server using the following query: 1: DECLARE @value nvarchar(512), 2: @rc int; 3: EXEC @rc = [master].[dbo].[xp_instance_regread] N’HKEY_LOCAL_MACHINE’,N’Software\Microsoft\MSSQLServer\MSSQLServer’,N’DefaultData’, @value output–…

1

SQL Server 2008 R2

Now that SQL Server 2008 R2 November CTP is available, I found some time to install it and test the existing Visual Studio 2008 Team System Database Edition GDR R2 release with it. The only thing that is really different from a SQL Server point of view besides two changes to the SQL parser, is…

2

Pre and Post Deployment Events

Visual Studio makes it relatively easy to hook in to pre and post build events, by using the Project properties tab named Build Events. However when using Database Projects (.dbproj) you more often need to do something at deployment time. The good news is that the standard MSBuild framework, already defines these events, the bad…

1

Pre-Deployment Scripts

Pre-deployment script do not change the outcome of deployments! The above statements is something that most users do not realize when using pre-deployment scripts. Since the pre-deployment script is included in to the deployment script, it therefore by definition runs after the comparison the the source model with the target database (model), and therefore cannot…

2