Friday, January 18, 2013 5:38 PM
We are using Sqlserver 2008 R2 for all development activities. i have few questions below to be answered. Help is much appriciated...
1. Is it possbile to migrate MSBI stack (SSIS, SSRS and SSAS) to SQLSERVER 2012 and maintaining source database in SQLServer 2008 R2. Please let me know the impact on project and compatibility issues.
2. Can i deploy SSAS (OLAP model), SSRS and SSIS developed from sqlserver 2012 SSDT to SQL server 2008 R2.
3. What is the impact and challenges if i migrate SSIS, SSAS and SSRS 2008 to 2012.
Do anyone foresee any issues by keeping database engine in 2008 R2 and using SSDT 2012 for SSIS, SSRS and SSAS
Saturday, January 19, 2013 8:34 PM
I will describe what I did and you can try that route to find the answer.
I will give you one answer. SSIS package can be developed using data on SQL Server 2008 R2 but it cannot be deployed to SQL Server 2008 R2
I exported a table from SQL Server 2012 to SQL Server 2008 R2 using Export/import
I created a simple package to transfer the above table from SQL Server 2008 R2 to SQL Server 2012. This works.
I tried to deploy it to SQL Server 2008 R2 and it is not supported.
I will give you one answer. Deploying to SSRS 2008 R2 not supported.