Post reply

Moving SRS to a new server and changing data sources

  • June 18, 2014 at 6:39 am

    #308268

    I have a project where I am creating a test environment. My objective is to give the client staff a set of instructions to follow to make sure the test mirrors production. I have migrated the SRS databases over to the new test server. All of the reports are there as is the security but where I run into an issue is the data sources for SRS. They are all pointed at the production servers. Is there an easy way to make the change possibly using a SQL update statement or exporting all the reports to XML and doing a find and replace. The shared data sources I went through manually and changed but there were 40 data sources. Now I realized some of the reports have embedded data connections. There are hundreds of reports to go through.

    Any thoughts would be appreciated on shared or embedded data sources.

  • June 18, 2014 at 7:02 am

    #1722766

    How many different production server names are going to need to be changed in the reports and data sources? The reason I ask is that you could use the SQL Server Client Network Utility (c:\Windows\System32\cliconfg.exe) to create aliases for each server instead. That way you would not need to change any of the reports or data sources .

  • June 18, 2014 at 7:15 am

    #1722773

    I am pretty sure it is just one but I did not write all the reports. Great suggestion and I will look into it. I understand the concept just never utilized that utility before.

  • June 18, 2014 at 7:21 am

    #1722779

    It's quite easy to set up. Switch to the Alias tab and then click Add. The entry for "Server alias:" will be the Production server name, the entry for server name in the Connection Parameters section will be the name of the test server you are using instead of the production server. I always set it to use the TCP\IP network library too.

    Here are some instructions from MSDN:

    http://msdn.microsoft.com/en-gb/library/ms190445%28v=sql.110%29.aspx

  • June 18, 2014 at 7:29 am

    #1722786

    tripleaxe thanks for being on the forum today. That was a great answer. Simple and quick.

  • June 18, 2014 at 7:31 am

    #1722788

    Happy to help. I'm glad it worked out for you.

Viewing 6 posts - 1 through 5 (of 5 total)

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