visual studio 2017 sql server data tools

My second thought was “WTH”? How is it that SSDT 2012 does NOT allow for me to connect to an instance of SQL 2012? That makes absolutely no sense! My first thought was “What do you mean that ‘Data information could not be retrieved because of the following error: SQL Server versions later than 2008 R2 are not supported'” ? That is when I was greeted with this lovely message: So I opened up SSDT and tried to do a data compare between an instance of SQL 2008R2 and SQL 2012. The one item I decided to test was going to be a simple data compare between two AdventureWorks databases. Having used previous versions of SSDT (yes, I’m old enough to recall the Business Intelligence Development Studio, now GET OFF MY LAWN) I was familiar with some of the basic functionality available throughout the years.

I think the installer placed a shortcut in my Start Menu and that’s about it. To be honest I’m still not sure what was installed on my laptop as a result of my checking this box. I already had them installed on my laptop, or so I thought I had them installed because I had checked off the “SQL Server Data Tools” box under the Shared Feature section on the Feature Selection install page as shown in this image: You may click the Cancel button to this dialog-box.Recently while preparing a talk on the new features in SQL 2012 I decided that it would be a good time to explore SQL Server Data Tools (SSDT). Make sure that your selected features (Integration Services, Reporting Services and Analysis Services) are installed. To confirm the installation of SSDT go to File > New > Project… Once installation is completed, click the Restart button to complete setup.Īfter restarting your computer start Microsoft Visual Studio 2017. Wait until the download and installation are completed. Check all the features you want to install. Select ‘Visual Studio Community 2017’ from the drop-down list. Once the setup file SSDT-Setup-ENU.exe is downloaded, double click the file to start installation. You can also download the installation file directly by clicking the button bellow:

You can download the installation file from the Microsoft’s website. In this tutorial, you will learn how to install SQL Server Data Tools (SSDT) for Visual Studio 2017.

Online Store with WooCommerce in WordPress.

Digital Marketing and Social Media for Businesses.

Blockchain and Cryptocurrency for Beginners.

Visual studio 2017 sql server data tools