[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 827
  • Last Modified:

BIDS 2012 - How to deploy SSRS data sources to different servers (dev & prod)

Our development SQL Server is on a different physical server than our test and production servers.  How can I set SSRS up such that we can quickly deploy to the desired server and the data sources are configured correctly for the destination?

We are using BIDS Visual Studio 2012 connecting to a SQL Server 2012 server.
0
canuckconsulting
Asked:
canuckconsulting
1 Solution
 
Ryan McCauleyData and Analytics ManagerCommented:
Can you just deploy the report configured to use an external data source, but without also deploying the data source? If you put data sources in the same location on both the UAT and production servers, called the same thing, but pointing to the proper destinations (UAT and production, respectively), the deployed reports should point to the correct location.
0
 
canuckconsultingAuthor Commented:
Thanks!
0

Featured Post

Take Control of Web Hosting For Your Clients

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now