Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Which SQL Server (free/trail) would be good to install, which requires minimum resource and have maximum features. I mean, I can practice mirroring,logshipping and replication. I found this link, but confuse with enterprise and standard edition.

share|improve this question
add comment

closed as not constructive by Mark Storey-Smith, Max Vernon, Aaron Bertrand, dezso, Mat Apr 14 '13 at 10:56

As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, visit the help center for guidance.If this question can be reworded to fit the rules in the help center, please edit the question.

2 Answers

up vote 3 down vote accepted

The 180 day evaluation version from Microsoft is Enterprise Edition. AFAIK there is no ability to "trial" Standard edition from Microsoft outside of a licensing agreement you might have.

From the point of view of overhead between editions, there's negligible difference.

If you want something longer than 180 days, get the developer edition as its feature complete compared to Enterprise but only $50 from Amazon

share|improve this answer
    
My system configuration : OS : WINDOWS 7 CORE 2 DUO with 3 G.B. Memory and 2 G.Hz processor speed. So, it is good to install on my system ? –  jWeaver Apr 13 '13 at 11:55
    
@Kent Amazon sells (this software) only to the US, as far as I can see in that page. –  ypercube Apr 13 '13 at 12:36
1  
I thought other retailers like buy.com might offer it. Buy.com has been taken over by another company, and they only offer 2000 developer edition. Worse, I think there was a data type mismatch somewhere (the decimal place seems to have shifted a couple of places). It's offered for a mere $5000. –  Aaron Bertrand Apr 13 '13 at 19:22
    
Also odd that this page says Developer Edition is available through volume licensing or retail. However when you click on the retail channel you go here - which does not carry SQL Server Developer Edition. –  Aaron Bertrand Apr 13 '13 at 19:26
    
@ypercube having no idea how they operate, does amazon.co.uk ship around Europe or only within UK? –  Aaron Bertrand Apr 13 '13 at 19:35
show 1 more comment

SQL Server Editions
SQL Server 2008 is available in the following editions:

  1. Enterprise Designed for the largest organizations and those needing to leverage the full power of the SQL Server 2008 platform.
  2. Standard Designed for small and midsized organizations that do not need all the capabilities available in SQL Server 2008 Enterprise.
  3. Workgroup Suitable for small departmental projects with a limited set of features.
  4. Express A freely redistributable version of SQL Server that is designed to handle the needs of embedded applications as well as the basic data storage needs for server-based applications, such as Web applications with a small number of users.
  5. Compact Designed as an embedded database.
  6. Developer Designed for use by developers in creating SQL Server applications. SQL Server 2008 Developer has all the features and capabilities as SQL Server 2008 Enterprise, except that it is not allowed to be used in a production environment.
  7. Evaluation Designed to allow organizations to evaluate SQL Server 2008. SQL Server 2008 Evaluation has all the features and capabilities as SQL Server 2008 Enterprise, except that it is not allowed to be used in a production environment and it expires after 180 days.


hardware engine support1 engine support2
Reference: Microsoft SQL Server Implementation and Maintenance (Exam 70-432)

share|improve this answer
    
so, which one would you recommend for my requirement ? –  jWeaver Apr 13 '13 at 13:30
    
i mean it depends, plus its hell of an info, like the most u can get, can't u derive anything yet? –  sarepta Apr 16 '13 at 17:47
add comment

Not the answer you're looking for? Browse other questions tagged or ask your own question.