You may or may not already have heard about it, but the next version of our favorite database, SQL Server 2012, ships with a client tool called SQL Server Data Tools (SSDT). Just like the BIDS was actually Visual Studio 2008 (or 2005 if you’re long enough in the business) with BI-related project templates, SSDT is Visual Studio 2010. But that’s not all: it contains additional functionality! Do you remember the database projects you could create using the “data dude”, or officially known as Visual Studio 2008 with the GDR2 add-on? Well, this is version-next of the data dude.
Let’s find out how such a database project can be created!
Getting Started With SSDT
Obviously the first step is installing SQL Server 2012 and making sure to select SQL Server Data Tools in the Feature Selection page:
With that up and running, launch the SQL Server Data Tools from the Microsoft SQL Server 2012 folder in the Start menu and go to File > New Project.
One of the template categories is called SQL Server. Under that you’ll find a template called SQL Server Data Tools – Database Projects (Web Install).
Erm, hang on, what do you mean, “web install”? Does that mean it’s not installed yet? The description on the right also gives some clue to what’s going on: “provides instructions for installing SQL Server Data Tools – Database Projects from the web”. Okay, let’s get on with it then!
Click the OK button to proceed to the installer.
Installing the SSDT Database Projects template
I think the message in that window above is a bit misleading. It says that “Database Projects” is required, but isn’t that what we’re going to install now? Sounds like chicken and egg to me! Let’s just ignore the message then and click the Install button.
We’re now presented with a web page in Internet Explorer. In this Data Developer Center, click the blue Download SQL Server Data Tools link.
Next, when presented with the following pop-up, click Allow:
The next window is the Web Platform Installer 3.0 that wants to install the Microsoft SQL Server Data Tools. Click the Install button to get to the next step.
As usual with any installer from Microsoft, we need to accept the license terms so click the Accept button.
Finally, the installation begins!
To keep us busy, we’re presented with another pop-up with a progress bar:
Woah! Is this thing installing SQL Server 2012 Express LocalDB like it says in the message? I didn’t ask for that! MS people, as I already have a version 2012 DB engine running on my machine, please make this optional…
Just a little later we’re presented with this:
Clicking the Finish button gives us yet one more pop-up:
The Web Platform Installer presents us with a list of applications we can install, including Microsoft SQL Server Data Tools. Oh my, I thought we just finished installing it? Let’s not be silly and click the Exit button
To conclude, we need to restart Visual Studio 2010, or aka SSDT.
Really Getting Started With SSDT
With everything up and running smoothly this time, open SSDT once more and in File > New Project you’ll now find the SQL Server Database Project under the SQL Server collection:
If you also have Visual Studio 2010 installed in Premium or Ultimate edition, you should take care to open up the correct SQL Server template collection. The reason for that is because the data dude projects are included in those versions of Visual Studio, as shown in the screenshot below:
So the templates under Database > SQL Server are not what you’re looking for!
That’s it for now, I’ll demonstrate my favorite SSDT feature in an upcoming post!