Reports Deployment to different Servers

Question

Post reply

Reports Deployment to different Servers

kevaburg

SSCoach

Points: 18131
More actions
January 19, 2015 at 6:30 am

#397894

Hi everyone!
My Problem is a relatively simple one. I have a test Report Server on which reports are developed, deployed and tested. Once the Report has been successfully built we want to alter the Destination Report Server to Point at the production evnironment.
The only way we have found to do this is to Change the Destination deployment Server in the deployment Settings and this isn't desireable.
Does anyone know of an easier way to Change the deployment Destination without having to alter global Settings?
Many thanks in advance.
Regards,
Kev

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

David Burrows SSC Guru Points: 65142 More actions · Answer 1

I'm on 2008R2 and I set my project properties for Debug/Release configurations for dev and prod respectively.

When I want to deploy I select Build/Configuration Manager from the menu and select Debug or Release for dev or prod.

Far away is close at hand in the images of elsewhere.
Anon.

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 2

David Burrows (1/19/2015)
I'm on 2008R2 and I set my project properties for Debug/Release configurations for dev and prod respectively.
When I want to deploy I select Build/Configuration Manager from the menu and select Debug or Release for dev or prod.

+1

Scripting SSRS deployments is a nightmare.

You're better off with Visual Studio environments/configurations.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

kevaburg SSCoach Points: 18131 More actions · Answer 3

Koen Verbeeck (1/19/2015)
David Burrows (1/19/2015)
I'm on 2008R2 and I set my project properties for Debug/Release configurations for dev and prod respectively.
When I want to deploy I select Build/Configuration Manager from the menu and select Debug or Release for dev or prod.
+1
Scripting SSRS deployments is a nightmare.
You're better off with Visual Studio environments/configurations.

We are working with Visual Studio in a BIDS Environment. We quite simply can't find the place to configure the two Servers!

Regards,

Kev

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 4

kevaburg (1/19/2015)
Koen Verbeeck (1/19/2015)
David Burrows (1/19/2015)
I'm on 2008R2 and I set my project properties for Debug/Release configurations for dev and prod respectively.
When I want to deploy I select Build/Configuration Manager from the menu and select Debug or Release for dev or prod.
+1
Scripting SSRS deployments is a nightmare.
You're better off with Visual Studio environments/configurations.
We are working with Visual Studio in a BIDS Environment. We quite simply can't find the place to configure the two Servers!
Regards,
Kev

I think the idea is to use build configurations.

How to: Create and Edit Configurations

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

kevaburg SSCoach Points: 18131 More actions · Answer 5

Koen Verbeeck (1/19/2015)
kevaburg (1/19/2015)
Koen Verbeeck (1/19/2015)
David Burrows (1/19/2015)
I'm on 2008R2 and I set my project properties for Debug/Release configurations for dev and prod respectively.
When I want to deploy I select Build/Configuration Manager from the menu and select Debug or Release for dev or prod.
+1
Scripting SSRS deployments is a nightmare.
You're better off with Visual Studio environments/configurations.
We are working with Visual Studio in a BIDS Environment. We quite simply can't find the place to configure the two Servers!
Regards,
Kev
I think the idea is to use build configurations.
Could you expand on that please? Does it mean that in the development Phase one build configuration could Point at the Dev Deployment Server and a second build configuration for the same Report would Point at the production?
How to: Create and Edit Configurations

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 6

Yeah, that is correct.

You should create some configurations and assign values to them.

In VS, you can switch between configurations using the dropdown.

To be honest, I haven't done this for SSRS though, I have only configured this for SSIS projects.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

kevaburg SSCoach Points: 18131 More actions · Answer 7

Sorry for the delay in answering....

Thanks for the answers! The Problem is solved! 🙂