Changing Data Sources programmatically

• SW_Lindsay

  SSCommitted

  Points: 1983

  More actions

  August 26, 2008 at 8:46 am

  #191658

  Where are the Data Sources stored? If I activate my Log shipping site I need to change the server from the production to my Log Shipping site. We do not change the server name or IP address to the production name and IP address. So I would like to programmatically change the data sources to the server name. For example, the Production server is SS001 and the Log Shipping server is SS201, so I would like to change the reference to SS001 to SS201. Can this only be done via the GUI?

  Steve

• Ian Massi

  SSCertifiable

  Points: 5931

  More actions

  August 26, 2008 at 1:39 pm

  #863363

  I'm a Reporting Services beginner, but I stumbled across the following article while looking for something else:

  http://www.sqlservercentral.com/articles/Development/2945/%5B/url%5D

  It goes into detail about how to achieve what you are looking for if I'm not mistaken.

  Good luck!