SQL Server 2005和SQL Server 2008之间是否存在冲突？ [英] Are there conflicts between SQL Server 2005 and SQL Server 2008?
问题描述
有人告诉我，使用BI工具安装SQL Server 2005和使用BI工具安装SQL Server 2008不能在同一台计算机上一起工作。显然，某些事情停止了工作。这是我的一位团队成员告诉我的。由于我是SQL BI的新手，所以我不能完全拒绝他所说的话，也不想将它们都安装在我的开发箱中，以后再发现有问题。
I am told that SQL Server 2005 installation with BI tools and SQL Server 2008 with BI tools can't work together on the same computer. Apparently "some" things stop working. This was told to me by one of my team members. Since I'm new to SQL BI, I cant discount what he has said altogether and I dont want to install them both on my dev box and find out later that there is problem.
这里有没有人把它们都安装好了，都用得很好？
Has anyone here installed them both, used both sufficiently well and found it to be working fine?
谢谢。
推荐答案
我不确定这是您的开发系统还是服务器...如果是服务器，则可以在同一服务器上同时报告服务时间（尽管您也会使用两倍的资源）。我不确定你为什么会这么做； Reporting Services 2008的优势非常强大，它可以报告sql 2005实例中的数据。如果您担心缺少sql 2008的Service Pack，则可以从报表服务2005（ http://msdn.microsoft.com/en-us/library/ms143736.aspx ）
I'm not sure if this is your development system or the server... If its the server you can have side by side reporting services on the same server at the same time (though you use double the resources too). I am not sure why you would though; the reporting services 2008 is vastly superior and can report on data from the sql 2005 instance. If you are worried about the lack of a service pack for sql 2008 you can report on data in sql 2008 from reporting services 2005 (http://msdn.microsoft.com/en-us/library/ms143736.aspx)
如果您可以在本地PC上同时安装两个开发工具（ http://msdn.microsoft.com/en-us/library/bb500441.aspx ）；尽管在这种情况下，仅当您要迁移到sql 2008时才使用sql 2005工具，因为SQL 2005代码可在2008上运行，但不一定相反。
If its local on your own pc you can have the development tools both installed at the same time (http://msdn.microsoft.com/en-us/library/bb500441.aspx); though in this case i would use the sql 2005 tools only if you are migrating to sql 2008 as SQL 2005 code works on 2008 but not necessarily the other way around.
如果您具有报告服务模型，请确保您检出了ms于本周启动的报告生成器2。它比报表生成器1更好的用户体验。
If you have reporting services models make sure you check out report builder 2 which ms launched this week. Its a much better user experience than report builder 1.
这篇关于SQL Server 2005和SQL Server 2008之间是否存在冲突？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
