Solved

Upgrading SQL Server 2008 180-day Evaluation to *STANDARD*

Posted on 2009-07-10
3
1,658 Views
Last Modified: 2012-05-07
Hi,

I noticed that the 180-day Evaluation version of SQL Server 2008 is the
Enterprise version .

Is there a *STANDARD* evaluation version that I can download?  If not,
is there going to be any problem "upgrading" the Evaluation Enterprise
version to a *STANDARD* version (and how much additional stuff is going to be
left inactive on my disk and, more importantly, in my registry, etc. if I do
so)?

Regards,
Rajesh
0
Comment
Question by:rajeshmarappan
  • 2
3 Comments
 
LVL 51

Expert Comment

by:Mark Wills
ID: 24825285
You can upgrade your eval version to standard :  http://msdn.microsoft.com/en-us/library/ms143393.aspx  scroll down and look on the left for the Eval version...


And to do the upgrade, use the commandline setup specifying ACTION=editionupgrade : http://msdn.microsoft.com/en-us/library/ms144259.aspx
0
 
LVL 42

Expert Comment

by:pcelba
ID: 24825346
Standard evaluation version does not exist. I would recommend Developer version having all features of Enterprise for about $50 (not for production use).

The "inactive" stuff exists, of course. Don't ask how much because nobody knows... To be sure you've uninstalled everything you would need to create the disk partition copy and restore it instead of SQL Server uninstallation.
0
 
LVL 51

Accepted Solution

by:
Mark Wills earned 250 total points
ID: 24825585
Oh, forgot about that "inactive stuff".

There are differences but in all reality the engines are the same, so, really should not have to worry about "inactive stuff" in terms of affecting your machine and installed programs. The difference is more like a list of extensions support by the same programs, so it is more like turning on or off various settings.

More important is if you have used any of the Enterprise features in your database when you do go to upgrade.

Have a look at : http://www.microsoft.com/sqlserver/2008/en/us/compare-std-ent.aspx there is a PDF link under the very brief table showing major areas. There is a more detailed table in Books On Line : http://msdn.microsoft.com/en-us/library/cc645993.aspx

And before you do upgrade, make very sure you have used the SQL Server backup function to take a full SQL backup of your databases so you can recover them if needed, then remove any of the Enterprise only functions that you may have used, and backup again... The last one is what you need to "restore" into the standard version if needed.

You can always run a registry cleaner afterwards if you are so inclined...

0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Audit has been really one of the more interesting, most useful, yet difficult to maintain topics in the history of SQL Server. In earlier versions of SQL people had very few options for auditing in SQL Server. It typically meant using SQL Trace …
Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question