SQL Server Reporting Services中的开发和部署数据源 [英] Dev and Deployment data sources in Sql Server Reporting Services

问题描述

嘿，伙计们.

我正在本地处理报表，指向一个Sql Server数据库.但是，当我部署报告时，它们需要指向不同的数据库.

在.net网站上，我可以在web.config中指定一个ConnectionStrings.config文件，这是指向不同数据库的简便方法.我很想找到一种类似的方法来处理报告数据源或其他任何解决问题的方法.

当前，当我部署时，另一端的人必须记住他必须进入数据源并将其更改为指向他的数据库(这并不总是发生).

有关如何解决此问题的任何建议?

谢谢，

克里斯

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

推荐答案

好，使用将在报表服务器上配置的共享数据源.

这样，就相当于.NET网站配置连接字符串方案.

一个人只需要继续操作，即可更改报表服务器上托管的共享数据源的连接属性.在所有报告中使用共享数据源.因此，您的报告中无需进行任何更改.一次更改就可以了.

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.

感谢您的帮助，但是我忽略了提及我的dev数据库和生产数据库不在同一环境中的情况.我的矿山通过我的ISP在Internet上，生产数据库在公司内部网内部，外界无法访问.

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.

这篇关于SQL Server Reporting Services中的开发和部署数据源的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！