Dev and Deployment data sources in Sql Server Reporting Services

Question

0.00/5 (No votes)

See more:

Hey, guys.

I'm working on reports locally, pointing to one Sql Server database. However, when I deploy the reports, they need to point to a different db.

With a .net website, I can specify a ConnectionStrings.config file in web.config, which is an easy way to point to different databases. I'd love to find a similar method for report data sources, or any other solution to the problem.

Currently, when I deploy, the guy on the other end has to remember that he must go into the datasource and change it to point to his db (and this doesn't always happen).

Any suggestions on how to solve this problem?

Thanks,

Chris

Posted 14-Jul-10 4:00am

Christopher Duncan

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sandeep Mewara · Answer 1 · 2010-07-14T04:45:00

Solution 1

Well, use a shared datasource that will be configured on the report server.

This way it would be something equivalent to the .NET website config connectionstring scenario.

One would just need to go ahead and change the connection property of the shared datasource hosted on reportserver. Use the shared datasource in all the report. Thus no change would be required in your reports. One change and it will work.

Posted 14-Jul-10 4:45am

Sandeep Mewara

Comments

Christopher Duncan 14-Jul-10 11:04am

Reason for my vote of 1
Databases are not in common environment, but thanks!

Sandeep Mewara 14-Jul-10 14:48pm

Thanks for the 1 vote. But I think, based on what you said my point/direction was not wrong. If you forget/neglect to mention certain things then how we are suppose to know them?
But thanks!

Christopher Duncan · Answer 2 · 2010-07-14T05:05:00

Solution 2

Thanks for the help, but I neglected to mention that my dev database and the production database are not in the same environment. Mine is on the Internet via my ISP, the production db is inside a corporate intranet not accessible to the outside world.

Posted 14-Jul-10 5:05am

Christopher Duncan

Comments

Sandeep Mewara 14-Jul-10 14:47pm

Reason for my vote of 1
Well, this is not an answer! You should use 'Improve Question' link to edit/update your question with more details.