September 11, 2017 at 4:27 am
Hi. I want to use ssdt 2015 to get an early glimpse of ssrs 2016. We don't yet have a sandbox with ssrs 2016. Do I need to install sql 2016 on my local in order for ssdt 2015 to allow development/simulate/preview of an ssrs 2016 report? I'm running windows 7 and am concerned I would need to upgrade to 8 or 10 first.
September 11, 2017 at 5:26 am
You will need Visual Studio 2015 of some edition, go for community if you don't have MSDN / Visual Studio licenses, then download and install SSDT.
You don't need SQL in order to develop a rdl, just Visual Studio with the SSDT plugins installed, that way you can see what the reports look like in preview mode in VS than needing to deploy to SSRS.
Just remember to set your deployment methods to be as high as they can be for the version you need. Think its still 2008R2 or above for 2016.
September 11, 2017 at 6:02 am
anthony.green - Monday, September 11, 2017 5:26 AMYou will need Visual Studio 2015 of some edition, go for community if you don't have MSDN / Visual Studio licenses, then download and install SSDT.
You don't actually need VS 2015. Downloading SSDT (for VS 2015) will install a VS 2015 shell, if you don't already have it installed:
Installing SSDT without Visual Studio pre-installed
If you don't have Visual Studio installed on your machine, installing SSDT for Visual Studio will install a minimal version of Visual Studio. This version of Visual Studio is free to install and use on as many machines as you wish. It gives you all the SQL Server project types, plus SQL Server Object Explorer and other SQL tools experiences.
https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
September 11, 2017 at 6:21 am
Thom A - Monday, September 11, 2017 6:02 AMInstalling SSDT without Visual Studio pre-installed
If you don't have Visual Studio installed on your machine, installing SSDT for Visual Studio will install a minimal version of Visual Studio. This version of Visual Studio is free to install and use on as many machines as you wish. It gives you all the SQL Server project types, plus SQL Server Object Explorer and other SQL tools experiences.
https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt
[/quote]
Well you learn something new every day.
Been to that page many a time but never scrolled to the bottom, only link I needed was at the top.
September 11, 2017 at 8:20 am
stanteitelbaum - Monday, September 11, 2017 4:27 AMHi. I want to use ssdt 2015 to get an early glimpse of ssrs 2016. We don't yet have a sandbox with ssrs 2016. Do I need to install sql 2016 on my local in order for ssdt 2015 to allow development/simulate/preview of an ssrs 2016 report? I'm running windows 7 and am concerned I would need to upgrade to 8 or 10 first.
Just an FYI at this point, but you are correct with regard to your concern about an OS upgrade. In order to install ANY part of SQL Server 2016 locally, you need to have at least Windows 8, as that software will NOT install on Windows 7.
SSDT is a separate piece of software that is not so dependent on the version of your operating system.
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
September 11, 2017 at 8:58 am
sgmunson - Monday, September 11, 2017 8:20 AMJust an FYI at this point, but you are correct with regard to your concern about an OS upgrade. In order to install ANY part of SQL Server 2016 locally, you need to have at least Windows 8, as that software will NOT install on Windows 7.
SSDT is a separate piece of software that is not so dependent on the version of your operating system.
You raise a good point here Steve; Yes, the Data Engine, SSRS, SSIS, etc, all need to run on a minimum of Windows 8.1 or Windows Server 2012 R2. For the client/developer tools, however, that prerequisite does not exist. Not only can you run VS 2015 (and the 2017 preview) on Windows 7, but also SSMS 2016+, and other tools that come with the applications.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply