Difference between SQL Server Standard and Enterprise Edition 2012

Question

We are working on a project migration from SQL Server 2008 R2 to SQL Server 2012. When we contacted the customer they have asked us to list us the advanced features in SQL Server 2012. The customer system is in Enterprise Edition. But the development environment is in Standard Edition.

When we were trying to apply many new features like Columnstore Index, it says this can be applied only on Enterprise Edition. Can you please help me to list out such features in SQL Server 2012?

Thank you very much in advance.

Answer 1

This page is a really good breakdown of the key differences between Standard and Enterprise editions. Also, rather than using Standard Edition, use the Developer Edition to develop in - it's free to use, and contains the same features as Enterprise Edition.