We would be happy to upgrade our SQL Server environments to 2014, but we have a tight budget for next year.
Our BI server (SQL Server 2008 Standard Edition, that is used only for BI purposes) is located separately from the Production Database server (SQL Server 2008 Enterprise Edition). The BI server contains our SSIS and SSRS packages and reports.
I was wandering whether it's possible to have a configuration where the BI server will have SQL Server 2014 (Standard of Business Intelligence) but the database server itself will remain on 2008.
Thanks for your answers,
Roni.
Best Answer
But of course. I suspect that you want to upgrade to the SQL Server 2014 Business Intelligence edition, since that is more frugal than Enterprise. But the BI edition does include the SQL Server database also in the license.
Are you wanting to upgrade the BI server in order to get the latest BI features?
SQL Server 2014 can certainly pull information from earlier editions of SQL Server for processing locally. Or the tools can read directly from the 2008 server.