Migration From SQL Server Enterprise Edition to Standard Edition 2014 64 bit

0
votes

Our Application using SQL Server Enterprise Edition, BI services (SSIS,SSAS,SSRS).My customer is restricted to SQL Server Standard Edition only.

Now i have to migrate everything From EE to SE of SQL Server.

1-While deploying SSAS (Semi-Additive measures are not supported) ? Might be i have fix this using Calculated Measures.

I am not sure about limitation with other services (SSIS, SSRS) could encounter while migration. Can somebody please help here !!!!!! I have to move SSIS jobs,Reports Etc ...

Thanks

Veneet

1
sql-serverreporting-servicesssisssas
What version of SQL Server are you using? 2008/2012/2014? – Paul Andrew
1) Try posting this question on [here](dba.stackexchange.com). 2) For SQL Server Database Engine sys.dm_db_persisted_sku_features could help to find those features specific to Enterprise edition. – Bogdan Sahlean
In't that what parallel testing is for :) – P.Salmon
hey Paul ,SQL Server 2014 – Veneet

1 Answers

0
votes

The best place to start is with the docs. There are separate sections on SSIS, SSAS and SSRS. The headlines are:

SSIS

Standard does not support Change Data Capture Service for Oracle by Attunity and Change Data Capture Designer for Oracle by Attunity.

SSRS

Standard does not support Data driven report subscription, Scale out deployment (Web farms), Alerting and Power View.

SSAS

Standard does not support Scalable Shared Databases, Semi-additive Measures, Perspectives, Writeback dimensions, Linked measures and dimensions, Proactive Caching, Push-mode processing, Direct Writeback and Measure Expressions