Sql或报告的验收测试
我负责一个包含数百个Sql报告（SSRS）的项目的开发和维护。我真的很想添加验收测试。 是否有报告验收测试的最佳实践？
我们目前正在为 .net 项目使用多个测试框架，因此熟悉 TDD、BDD - 用户故事等。 人们是否使用类似的方法进行报告验收测试，例如
Given customer 123456 When I run Report "CustomerOrders" Then I should see 5 rows in the output
某些报告需要很长时间才能运行，人们是否使用专用的验收测试数据库？
有人在 SSRS 中使用像 watir 这样的跑步者吗？
非常感谢该领域的任何见解！
I am responsible for the development and maintenance of a project containing several hundred Sql Reports (SSRS). I would really like to add acceptance testing.
Is there best practices for Report Acceptance tests??
We are currently using several testing frameworks for .net projects so are comfortable with TDD, BDD - User Stories etc.
Are people using similar approaches with report acceptance testing e.g
Given customer 123456 When I run Report "CustomerOrders" Then I should see 5 rows in the output
Some reports take a long time to run, are people using dedicated acceptance testing databases?
Is anyone using runners like watir with SSRS??
Any insight in this area greatly appreciated!
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
我致力于开发实时应用报告。我使用SSIS/RS。我的例子中没有使用 SSAS。我曾经在 OLTP 系统中运行 SQL 查询
这是一年前的事。最近我发现了 codeplex 工具和一些与 MSBI / SSRS 测试相关的帖子，
请参考下面的帖子和工具。
Reporting Services 单元测试框架 - http://rsunit.codeplex.com/
Microsoft 文章 - 测试冒险BI/DW 应用：远征找到圣杯 - http://msdn.microsoft.com/en-us/ Library/gg248101.aspx
使用 Visual Studio 2005 在 SQL Server 2005 Reporting Services 报表服务器上执行负载测试 - http://msdn.microsoft.com/en-us/library/ aa964139(SQL.90).aspx
Reporting Services 中的单元测试报告：我的理论 - http://consultingblogs.emc.com/stevewright/archive/2009/08/27/unit-testing-report-within-reporting-services-my-theory.aspx
希望有帮助
I worked on developing a report for real time application. I used SSIS/RS. I didn't use SSAS in my case. I used to run SQL query in
This was a year ago. Recently I found codeplex tools and few posts related to MSBI / SSRS testing
Please refer below posts and tools.
Reporting Services Unit Testing Framework - http://rsunit.codeplex.com/
Microsoft Article - Adventures with Testing BI/DW Application:On a crusade to find the Holy Grail - http://msdn.microsoft.com/en-us/library/gg248101.aspx
Using Visual Studio 2005 to Perform Load Testing on a SQL Server 2005 Reporting Services Report Server - http://msdn.microsoft.com/en-us/library/aa964139(SQL.90).aspx
Unit Testing Report within Reporting Services: My Theory - http://consultingblogs.emc.com/stevewright/archive/2009/08/27/unit-testing-report-within-reporting-services-my-theory.aspx
Hope it Helps