Currently, the reports that we have are written using Visual Studio 2012 and SQL Server 2008 R2. We also use the RS.exe utility to automate the deployment of our reports in different environments.
We are looking at moving to Visual Studio 2017 and using the latest SSRS project templates, etc. We can change the target version of SQL Server as part of the project settings and return to the instance of SQL Server 2008 R2 in Visual Studio again.
The problem is that it seems that the automation tool ( RS.exe ) is not able to specify the version of the target server, and therefore we cannot use it to automatically generate reports. This view defeats the goal of even starting to use Visual Studio 2017 until we upgrade our SQL Server to 2016.
Are there any workarounds allowing us to use VS 2017 and continue to automate push reports in old SQL Server 2008 R2? Or this is the only option to deploy directly from VS 2017 using the Target Target SQL Server parameter.
Thanks.
source share