Login or Sign Up to become a member!
LessThanDot Sit Logo

LessThanDot

Data Management

Less Than Dot is a community of passionate IT professionals and enthusiasts dedicated to sharing technical knowledge, experience, and assistance. Inside you will find reference materials, interesting technical discussions, and expert tips and commentary. Once you register for an account you will have immediate access to the forums and all past articles and commentaries.

LTD Social Sitings

Lessthandot twitter Lessthandot Linkedin Lessthandot friendfeed Lessthandot facebook Lessthandot rss

Note: Watch for social icons on posts by your favorite authors to follow their postings on these and other social sites.

Your profile

    Search

    XML Feeds

    Google Ads

    « Giving users the ability to change a stored procedure without making them db_ownerT-SQL Tuesday #38 – Resolving an SSIS package performance problem »
    comments

    This is the second post in the Database Projects series. The first post was Setting up Source Control.
    So now we have Source Control in place we need to install the Database Projects Template. To do this launch SQL Server Data Tools 2012 (SSDT). In the Start Page, choose for a New Project:

    When you want to create a Database Project for the first time, you'll see a Web Install in the New Project Template screen when you select SQL Server:

    When you click the Web Install, a new pop-up screen will appear telling you you have to install Microsoft SQL Server Data Tools. Off course this is what you want so hit install:

    A web page will open where you can download SQL Server Data Tools for Visual Studio 2010 or for Visual Studio 2012. Since I'm using the SQL Server Data Tools delivered with SQL Server 2012 and this is a Visual Studio 2010 Shell I will download the Visual Studio 2010 version:

    Another screen will show, giving you more details about what's going to happen and give you more options if you need to install SQL Server Data Tools on a machine with no internet access or with other language needs. Since Dutch is not supported and my machine has internet access I just start the download:

    Now you can choose to Save or Run the setup. I'm just going to run it:

    Don't know if you can trust Microsoft Corporation as a Publisher but hitting Don't Run will not help you on getting the software installed. So hit Run:

    Now we need to accept the License Terms to install:

    Now this is why you have to admire sysadmins, allow the software to make changes to your computer:

    Finally you can take a nap while the download runs and the installer starts installing.
    After the Setup finish you can Close the installer:

    Close SQL Server Data Tools and start it again. Because of the new version you might get the question what Default Environment Settings you want. I chose SQL Server Development Settings before starting Visual Studio.

    .
    I still don't understand why the SQL Server Database Project Template isn't delivered with the initial setup of the SQL Server Data Tools but we're almost ready to create our first project.

    About the Author

    User bio imageAxel started his IT career more than a decade ago. After a few months he was the accidental DBA for the SQL Server 6.5 running the Service Desk application. It didn't took long or Axel started to focus on SQL Server and after another year he became the full-time DBA in a large Belgian datacenter managing the SQL Servers for the hosted customers.It's more than five years now since he switched to consulting and teaching SQL Server. Axel is a Microsoft Certified DBA and Trainer.
    Social SitingsTwitterLinkedInLTD RSS Feed
    2276 views
    InstapaperVote on HN

    2 comments

    Comment from: jamiet [Member] Email
    jamiet "I still don't understand why the SQL Server Database Project Template isn't delivered with the initial setup of the SQL Server Data Tools"
    Its due to the fact that the SSDT Database project template is delivered on a much regular cadence than SQL Server itself (i.e. of late its been every month). That's why its delivered via a web download and hence why that's used as the vehicle for the first install too.
    I'm not saying its right, I'm not saying its wrong. But that's the reasoning as far as I am aware.
    01/08/13 @ 07:21
    Comment from: Axel Achten (axel8s) [Member]
    Axel Achten (axel8s) Thanks for the info.
    01/08/13 @ 07:33

    Leave a comment


    Your email address will not be revealed on this site.

    To mislead the spambots.

    Your URL will be displayed.
    (Line breaks become <br />)
    (Name, email & website)
    (Allow users to contact you through a message form (your email will not be revealed.)