 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / Services / Reporting Services / April 2006Datasource Change HELP!!!!
I am working in a dev environment. My report uses 20 different datasets but they all point to the same datasource. I am moving from Dev to a UAT environment which points to a different DB. Is there a way to change the datasource for all 20 datasets from DevDB to UATDB at once or am I stuck with going in and changing all the datasources for each of the datasets one by one? Thanks in advance OS Try opening XML <F7> and doing a find/replace on the DB name. This is assuming that the new datasource is already defined in the solution and the table names are the same. > I am working in a dev environment. My report uses 20 different datasets but > they all point to the same datasource. I am moving from Dev to a UAT [quoted text clipped - 4 lines] > Thanks in advance > OS William, This really helped me! Thanx a bunch! OS > Try opening XML <F7> and doing a find/replace on the DB name. This is > assuming that the new datasource is already defined in the solution and the [quoted text clipped - 8 lines] > > Thanks in advance > > OS Hi, Have you used as a "shared resources" for all your reports? then it should not be a problem since you need to just change the database and user name/password etc.. details at your datasource and you will be up and running. Amarnath > I am working in a dev environment. My report uses 20 different datasets but > they all point to the same datasource. I am moving from Dev to a UAT [quoted text clipped - 4 lines] > Thanks in advance > OS How can we programatically change the DB name? Or Change them dynamically in the URL? Prad > Hi, > Have you used as a "shared resources" for all your reports? then it should [quoted text clipped - 12 lines] > > Thanks in advance > > OS What you should be doing is to have a shared datasource. The first time you deploy the datasource is deployed too. Then you go to the Report Manager and change the datasource to point to the production data. From then on when you deploy the default is that the datasource is not overwritten so you only need to do this once. So there should only be one datasource that you have to change once in this process.  SignatureBruce Loehle-Conger MVP SQL Server Reporting Services > How can we programatically change the DB name? > Or [quoted text clipped - 23 lines] >> > Thanks in advance >> > OS Is there any way to change the datasource for a report on an execution-by-exection basis? I have a situation where there are a large numbre of databases and users need to be able to execute a single report against any of the databases. Is there a way to supply the database connection string to the report when it is executed? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.