Wednesday, April 10, 2013

[SQL Server Data Warehousing] Need some clarifications on Sql Server 2012 QA & Prod environment setup


I think the original question requested information on Licensing as well, which none of the answers contain. I agree on the HW configuration part - they majorly depend on application size including data volume.


With SQL Server 2012 we can use Standard (Core / Server-CAL), BI (Server-CAL) and Enterprise (Core) editions, - among them which edition to choose will depend on what features the solution needs. On high level, if the solution needs canned reporting on moderate sized data, Standard edition will do. If it requires ad-hoc / self-service BI then we need BI or Enterprise edition. If the data volume is high requiring columnstore indexing, we need Enterprise edition.


So far so good, all these are options for the Prod environment.


But for Dev and QA, can we use Developer edition license:


1. Will that license be able to access data from some other SQL Server database (which might be copy of Prod data for Dev and QA)


2. Will that license enable us to move SSIS/RS/AS/PowerView codes to Prod environment without any issues? 


Can some expert from Microsoft answer this question - which I think would answer a good part of the original question as well.



Souvik Banerjee. MSBI Lead, Zensar Technologies



.

social.technet.microsoft.com/Forums

No comments:

Post a Comment

Search This Blog