Enterprises and express edition

Question

Enterprises and express edition

pallavi.unde

SSCommitted

Points: 1987
More actions
March 17, 2012 at 1:10 am

#253299

I am confused here.. about MSSQL server editions..
may i know for what purpose Enterprises and express edition are used.
if i need to use MSSQL server then which edition will be better to use?
Hope positive reply
Thanks & Regards,
Pallavi

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Jayanth_Kurup SSC-Insane Points: 22967 More actions · Answer 1

The 2 editions are worlds apart. Express edition is the free downloadable version and enterprise editions is the fully functional ( all bells and whistles) version.

Depending of what your trying to achieve you may be able use sql express but its generally not used for any kind of production system.

http://www.microsoft.com/sqlserver/en/us/editions.aspx

Jayanth Kurup[/url]

pallavi.unde SSCommitted Points: 1987 More actions · Answer 2

Currently i am using express edition

but if i want to switch it then will express edition backup get restore in enterprises edition?

Thanks & Regards,
Pallavi

Jayanth_Kurup SSC-Insane Points: 22967 More actions · Answer 3

Jayanth_Kurup

SSC-Insane

Points: 22967

March 17, 2012 at 1:54 am

#1460842

Yes

Jayanth Kurup[/url]

CapnHector SSCoach Points: 16143 More actions · Answer 4

pallavi.unde (3/17/2012)
Currently i am using express edition
but if i want to switch it then will express edition backup get restore in enterprises edition?

best analogy of enterprise and express would be windows 7 basic and windows 7 ultimate (or whatever they are calling it.)

Every think works the same at the core but when you try to do something like change the desktop background in windows basic you cant. still works its just annoying.

For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]

Elliott Whitlow SSC Guru Points: 102402 More actions · Answer 5

The windows 7 analogy is a good one. An additional point still using that analogy would be that you wanted to use bitlocker but basic doesn't have that..

There are features in Enterprise that many companies would like but aren't enough to spend the higher costs on enterprise, so a lower edition is chosen. Things such as table partitioning, SQL Auditing, Transparent Data Encryption, and SQL Clustering (with more than 2 nodes) are Enterprise edition features of SQL. Things like data driven subscriptions are a feature not available in SSRS standard.

Express is most often used as an option with applications that need a database but aren't big enough to require a higher edition. Most of these apps prefer to run on a higher edition but as a selling point if you are a small company you don't have to buy a full blown SQL license.

I generally design with the expectation being that it can run on ANY edition of SQL. However sometimes that cannot be achieved, database size, memory requirements, and processing needs will sometimes demand more resources than Express is allowed to deliver..

CEWII