关于与 SQL Server 2005 捆绑的报告和数据仓库软件的问题
目前，我们对相当大的应用程序使用 SQL Server 2005 Enterprise，该应用程序源于 SQL Server 7.0 之前的版本。这些表主要针对应用程序进行了标准化和设计。大多数开发人员都保留着传统的 SQL Server 思维方式。仅使用 7.0 中存在的 TSQL 部分，不使用 tsql 的任何新功能或与 2005 捆绑的功能。
我们目前正在尝试使用一些蹩脚的第三方软件构建按需报告，并且最终将尝试使用更多相同的蹩脚第三方软件构建数据仓库（名称被删除以保护有罪者，不要问我不会告诉）。这样做的理由是我们不想花更多的钱从微软购买这个额外的软件（这不是我的决定，我没有任何意见，但这是我现在的问题）。但据我所知，Enterprise 包含所有这些工具，还是我遗漏了一些东西？
就报告和数据仓库而言，SQL Server 2005 Enterprise 捆绑了哪些内容？我们还需要购买其他东西吗？在这方面实际上还有什么可以从微软购买的吗？
We currently use SQL Server 2005 Enterprise for our fairly large application, that has its roots in pre SQL Server 7.0. The tables are normalized and designed mainly for the application. The developers for the most part have the legacy SQL Server mindset. Only using the part of TSQL that existed back in 7.0, not using any of the new features of tsql or that are bundled with 2005.
We're currently trying to build on demand reports using some crappy third party software, and will eventually try to build a data warehouse using more of the same crappy third party software (name removed to protect the guilty, don't ask I will not tell). The rationale for this was that we didn't want to spend more money to buy this additional software from Microsoft (this was not my decision, I had no input, but is my problem now). But from what I can tell is that Enterprise includes all of these tools, or am I missing something?
What comes bundled with SQL Server 2005 Enterprise as far as reporting and data warehousing? Will we need to purchase anything else? is there actually anything else that can be purchased from Microsoft in this regard?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（3）
嗯，首先 - 就这一点而言，我会选择 2008 R2，它更适合报告。
2005 年的数据仓储就是这样。 2008 年确实在查询优化器中引入了星型模式的优化。
2005 年，我认为有您可以使用的报告服务 - 尽管他们在 2008 年和 2008 R2（图表等）中得到了很多更好的服务
除了考虑摆脱 SQL 进行分析之外，数据仓库应该加载到 SQL Server Analysis Services 中的多维数据集中并针对这些数据运行报告。
所有这些（报告服务、分析服务）都是您使用的企业版的一部分。除非你有不寻常的需求，否则其他东西几乎没有任何用处。
Well, first - I would go with 2008 R2 for that regard, much better for reporting.
DAta warehousing in 2005 is just that. 2008 did introduce optimizatoins for star schemata in the query optimizer.
2005 I think has report services that you can use - though they got a LOT better with 2008 and 2008 R2 (graphs etc.)
Besides that think getting rid of SQL for analysis - the data warehouse should get loaded into cubes in SQL Server Analysis Services and run the reports against those.
All that (reporting services, analysis services) is part of the enterprise edition you use. There is hardly any use for something else unless you have unusual needs.
企业版包含您可以安装的 Reporting Services。这是一项强大的报告服务。
Enterprise edition contains Reporting Services that you can install that. It is a powerful service for reporting.
如果您发现自己对 Reporting Services 不满意（对于大约 35% 的尝试者来说似乎效果不佳），请查看 迎风报告。话虽如此，我希望它确实适合您，因为这是您最便宜且最快的前进路线。
If you find you're unhappy with Reporting Services (seems to not work well for about 35% of the people who try it), please take a look at Windward Reports. With that said, I hope it does work well for you as that is your least expensive and quickest route forward.