Blog » By Valentino Vranken on Valentino Vranken
SQL Server Data Tools (SSDT)
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!
Have fun!
Valentino.
References
SSDT Main page on Data Developer Center
SQL Server Data Tools Team Blog
xanax online can you buy xanax legally online - xanax online us pharmacy
This piece of writing is truly a pleasant one it helps new net users, who are wishing in favor of blogging.
This piece of writing is truly a pleasant one it helps new net users,
who are wishing in favor of blogging.
Nice blog right here! Additionally your site a lot up very fast!
What web host are you using? Can I am getting your affiliate hyperlink
in your host? I desire my web site loaded up as quickly
as yours lol
Nice blog right here! Additionally your site a lot up
very fast! What web host are you using? Can I am getting your
affiliate hyperlink in your host? I desire my web site loaded up as quickly as yours lol
Excellent web site you have here.. It's difficult to find high quality writing like yours nowadays. I honestly appreciate individuals like you! Take care!!
Excellent web site you have here.. It's difficult to find high quality writing like yours nowadays. I honestly appreciate individuals like you! Take care!!
pure green coffee bean extract 800 mg Are these claims really
honest? Can Acai Berry really be that healthy? And can it really help you lose weight?
pure green coffee bean extract 800 mg Are these claims really
honest? Can Acai Berry really be that healthy? And can
it really help you lose weight?
There's definately a lot to find out about this subject. I like all of the points you've made.
There's definately a lot to find out about this subject. I like all of the points you've made.
Useful information. Lucky me I discovered your web site by
chance, and I am stunned why this accident did not took place earlier!
I bookmarked it.
Useful information. Lucky me I discovered your web site by chance, and I
am stunned why this accident did not took place earlier!
I bookmarked it.
Woah! I'm really digging the template/theme of this site. It's
simple, yet effective. A lot of times it's difficult to get that "perfect balance" between user friendliness and visual appeal. I must say you've
done a awesome job with this. Additionally, the blog loads very fast for
me on Internet explorer. Excellent Blog!
Woah! I'm really digging the template/theme of this site. It's simple, yet
effective. A lot of times it's difficult to get that "perfect balance" between user friendliness and visual appeal. I must say you've done a awesome job with this.
Additionally, the blog loads very fast for me on Internet explorer.
Excellent Blog!
I really like what you guys are up too. Such clever
work and reporting! Keep up the superb works guys I've added you guys to my personal blogroll.
I really like what you guys are up too. Such clever work and reporting!
Keep up the superb works guys I've added you guys to my personal blogroll.
Wow, this article is good, my younger sister is analyzing
these things, so I am going to inform her.
Wow, this article is good, my younger sister
is analyzing these things, so I am going to inform her.
Want to discover in my husband Peter is also believed to enhance Pure Green
Coffee Bean Extract 800 Mg is right for starting a severe nutritional deficiency,
a registered dietitian. So, drink, cake and eat only as
per the recommended serving in mind, I'm not worried about what they already have.
Want to discover in my husband Peter is also believed to enhance Pure Green Coffee Bean Extract 800 Mg
is right for starting a severe nutritional deficiency, a registered
dietitian. So, drink, cake and eat only as per the recommended serving in mind,
I'm not worried about what they already have.
If you follow some simple to acquisition for a good
idea for the guy, looking for a Christian Free
Dating websites have personal boundaries.
If you follow some simple to acquisition for a good idea
for the guy, looking for a Christian Free Dating websites have personal boundaries.
I used to be able to find good advice from your blog posts.
I used to be able to find good advice from
your blog posts.
These treadmill raspberry ketones tips that you don't know how difficult it becomes useless. But our life in order to be tough, she kept taking the supplement enters bloodstream easily, making you feel better physically.
These treadmill raspberry ketones tips that you don't know how difficult it becomes useless. But our life in order to be tough, she kept taking the supplement enters bloodstream easily, making you feel better physically.
This is almost impossible, to coffee extract in the human coffee
extract relies on the Longevity coffee extract.
Tea consists of fast food salad.
This is almost impossible, to coffee extract in the human coffee extract relies on the Longevity coffee
extract. Tea consists of fast food salad.
I have been exploring for a little bit for any high quality articles or
weblog posts in this kind of area . Exploring in Yahoo I finally
stumbled upon this website. Reading this info So i am satisfied to convey that I've a very excellent uncanny feeling I came upon exactly what I needed. I so much unquestionably will make certain to don?t fail to remember this website and give it a look regularly.
I have been exploring for a little bit for
any high quality articles or weblog posts in this kind of area .
Exploring in Yahoo I finally stumbled upon
this website. Reading this info So i am satisfied to convey that I've a very excellent uncanny feeling I came upon exactly what I needed. I so much unquestionably will make certain to don?t fail to remember this website and give it a look regularly.
Right now it appears like Drupal is the top blogging platform available right now.
(from what I've read) Is that what you are using on your blog?
Right now it appears like Drupal is the top blogging platform available right
now. (from what I've read) Is that what you are using on your blog?
Hello Dear, are you truly visiting this web site on a regular basis, if so after that you will
definitely obtain nice experience.
Hello Dear, are you truly visiting this web site on
a regular basis, if so after that you will definitely obtain nice
experience.
Thank you for some other informative web site. Where else could I get that kind of information written in such an ideal approach?
I have a undertaking that I'm simply now working on, and I have been at the look out for such information.
Thank you for some other informative web site.
Where else could I get that kind of information written in such an ideal approach?
I have a undertaking that I'm simply now working on, and I have been at the look out for such information.
Hello there! I just wish to offer you a big thumbs up for your great info you have here on this
post. I'll be returning to your blog for more soon.
Hello there! I just wish to offer you a big thumbs up for your great info you have here on this post.
I'll be returning to your blog for more soon.
This is very interesting, You are a very skilled blogger.
I've joined your rss feed and look forward to seeking more of your fantastic post. Also, I've
shared your website in my social networks!
This is very interesting, You are a very skilled blogger.
I've joined your rss feed and look forward to seeking more of your fantastic post. Also, I've
shared your website in my social networks!
We know that Trader 247 binary options on the Trader 247
plan. Social and work have secure financial futures.
Adjusting for subsidiaries valuation of 0.
We know that Trader 247 binary options on the Trader 247 plan.
Social and work have secure financial futures. Adjusting for subsidiaries valuation of 0.
Sweet blog! I found it while searching on Yahoo News. Do you have any tips on how to get
listed in Yahoo News? I've been trying for a while but I never seem to get there! Appreciate it
Sweet blog! I found it while searching on Yahoo News. Do you
have any tips on how to get listed in Yahoo News? I've been trying for a while but I never seem to get there! Appreciate it
Great post. I was checking constantly this weblog and I am impressed!
Extremely helpful information specifically the ultimate phase :) I deal with such information a lot.
I used to be seeking this certain info for a very lengthy time.
Thanks and best of luck.
Great post. I was checking constantly this weblog and I am impressed!
Extremely helpful information specifically the ultimate phase :) I deal with such information a
lot. I used to be seeking this certain info for a very lengthy time.
Thanks and best of luck.
Excellent beat ! I wish to apprentice whilst you amend
your site, how can i subscribe for a weblog website?
The account aided me a applicable deal. I were a little bit acquainted of this your
broadcast provided vibrant transparent concept
You actually make it appear so easy together with your presentation
however I in finding this matter to be really something which I think I'd never understand. It seems too complicated and extremely large for me. I am looking ahead for your next submit, I will attempt to get the hold of it!
You actually make it appear so easy together with your presentation however I in finding this matter to be
really something which I think I'd never understand. It seems too complicated and extremely large for me. I am looking ahead for your next submit, I will attempt to get the hold of it!
Appreciate the recommendation. Let me try it out.
For newest news you have to go to see the web and on
the web I found this website as a best web site for newest updates.
For newest news you have to go to see the web and
on the web I found this website as a best web site
for newest updates.
Hello, i think that i saw you visited my blog
so i came to “return the favor”.I am attempting to find things
to enhance my site!I suppose its ok to use some of your ideas!
!
Hello, i think that i saw you visited my blog so i came to
“return the favor”.I am attempting to find things
to enhance my site!I suppose its ok to use some of your ideas!
!
I m having this error on a 4700 shade laserjet network printer.
It starts spitting out pages non cease with this mistake.
anybody has a suggestion if this is software or hardware.
Likewise I have all latest motorist and firmware updates.
vehicle driver I am suing is PCL6. any sort of aid
would be cherished.
I m having this error on a 4700 shade laserjet network printer.
It starts spitting out pages non cease with this mistake.
anybody has a suggestion if this is software
or hardware. Likewise I have all latest motorist and firmware
updates. vehicle driver I am suing is PCL6. any sort of aid would be cherished.
Thanks in favor of sharing such a pleasant thought, post is nice,
thats why i have read it completely
Thanks in favor of sharing such a pleasant thought, post is nice, thats why i have
read it completely
Combination of some other ingredients is reducing the
cost of Weight Loss Pills That Work, and the petrochemical industry was born.
Eating fewer meals could make you energy deficient and
you could risk of becoming overly tiredand injured.
Combination of some other ingredients is reducing the cost of Weight Loss Pills
That Work, and the petrochemical industry was born.
Eating fewer meals could make you energy deficient
and you could risk of becoming overly tiredand injured.
Natural does not mean that you should take natural Weight Loss Pills For Men to
lose your weight fast.
Hi, i think that i noticed you visited my weblog so i came to go
back the favor?.I'm attempting to find things to enhance my website!I guess its good enough to use a few of your concepts!!
Hi, i think that i noticed you visited my weblog
so i came to go back the favor?.I'm attempting to find things to enhance my website!I guess its good enough to use a few of your concepts!!
http://www.maps.google.com/ - [url=http://www.wikipedia.org/]wiki[/url]
mail
Adios and Adios Max weight tablets can both represent a serious green coffee bean extract benefits part of an afternoon snack.
Fake medicines are produced with inferior quality material that could react with your body
to store fewer calories.
Adios and Adios Max weight tablets can both represent a serious green coffee
bean extract benefits part of an afternoon snack. Fake medicines are produced with inferior quality material that
could react with your body to store fewer calories.
lovely jubbly fantastic thanks so much
lovely jubbly fantastic thanks so much
What's up, every time i used to check webpage posts here in the early hours in the break of day, because i like to find out more and more.
What's up, every time i used to check webpage posts here in the early hours in the break of day, because i like to find out more and more.
There are so many supplements for raspberry ketones.
Studies have shown that you should be well on your way to a healthier, happier existence.
There are so many supplements for raspberry ketones.
Studies have shown that you should be well on your way to a healthier, happier existence.
It's going to be end of mine day, however before end I am reading this wonderful paragraph to improve my knowledge.
It's going to be end of mine day, however before end I am reading this wonderful paragraph to improve my knowledge.