SQL Report Services 报告版本比较
我遗传了头痛！ 我有两台 SQL Reporting Services 服务器。 一台是生产服务器，另一台是测试服务器。 我知道一些报告已直接部署到生产中。 我知道一些报告不同步，这意味着测试版本与生产版本不同，反之亦然。
我想从服务器上拉取所有 rdl 文件，然后对它们运行差异以查看哪些报告不同。 有谁知道如何提取 rdl 文件，或者对如何比较这两组报告有更好的建议？ 它们的数量超过 100 个，所以如果可能的话，我会尽量避免一次一个的方法。
I've inherited a headache! I have two SQL Reporting Services servers. One is a production server, the other is a test server. I know for a fact that some of the reports were deployed directly to production. I know for a fact that some reports are out of sync, meaning the version on Test isn't the same as the version on Prod and vice-versa.
I want to pull all of the rdl files down from the servers and just run a diff against them to see which reports are different. Does anybody know of a way to pull the rdl files down or have a better suggestion about how to compare these two sets of reports? They number over 100 so I'm trying to avoid a one at a time approach if possible.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
您无法执行此操作，因为这些文件基本上是由 SQL Server 动态生成的。
但是，您可以使用以下工具从 SQL Server 中提取 RDL 文件：
RS Scripter
我希望这会有所帮助。
You cannot do this as the files are basically generated on the fly by the SQL Server.
You can, however, use the following tool to extract the RDL files from the SQL Server:
RS Scripter
I hope this helps.