August 5, 2011 at 3:22 pm
I would like to do some testing on a testing box for installation.
Our production server will be enterprise version
For the license issue, can I just use developer version for testing, I suppose it is exactly the same as enterprise issue, correct?
August 5, 2011 at 3:31 pm
August 5, 2011 at 3:39 pm
The situation is, we want to upgrade server from sql 2005 to 2008 on production.
But we want to test this on a testing box first, also test the application, if it works, then we will do the same thing on production.
But for the testing box, because we don't have an additional license for enterprise, so can I just use developer version?
I though developer version is exact as enterprise version, just the license is different.
August 5, 2011 at 3:43 pm
August 5, 2011 at 3:50 pm
Developer is completely equivalent to Enterprise (for 2008) in all features (there's nothing in Enterprise that's not in Developer), it's just not licensed for production usage.
Or you could use the Evaluation edition that's Enterprise with a 180 day kill switch.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 5, 2011 at 4:03 pm
Thank you!
August 7, 2011 at 2:54 pm
sqlfriends (8/5/2011)
I would like to do some testing on a testing box for installation.Our production server will be enterprise version
For the license issue, can I just use developer version for testing, I suppose it is exactly the same as enterprise issue, correct?
To extend what Gail stated, the "Developers" Edition is licensed PER DEVELOPER. It's meant to be used at the desktop of a single Developer. About the only way that you could get someone like the SPA to look the other way during an audit on a Development Server running the Development Edition is if every developer that touched it had a licensed copy of the Development Edition.
--Jeff Moden
Change is inevitable... Change for the better is not.
August 7, 2011 at 3:03 pm
Jeff Moden (8/7/2011)
sqlfriends (8/5/2011)
I would like to do some testing on a testing box for installation.Our production server will be enterprise version
For the license issue, can I just use developer version for testing, I suppose it is exactly the same as enterprise issue, correct?
To extend what Gail stated, the "Developers" Edition is licensed PER DEVELOPER. It's meant to be used at the desktop of a single Developer. About the only way that you could get someone like the SPA to look the other way during an audit on a Development Server running the Development Edition is if every developer that touched it had a licensed copy of the Development Edition.
That is only valid if ONLY DEVELOPERS ever access that system. If you have any end users, analysts, web applications, etc... the licensing is not valid.
To be truly compliant with licensing for a test system - you will need to license it appropriately. Figure out how many users will be accessing the system and determine how much that is going to cost for CAL licenses. If it gets too expensive using CAL's - then you would need to upgrade to processor licenses.
Either way, you can only use the developers Edition on a server when only developers with valid developer licenses are accessing that system. A test system does not qualify...
Besides, you really should have a valid test system to evaluate changes to the application and environment before putting those changes into a production environment. It could save you a lot more than it costs in licensing.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 7, 2011 at 3:12 pm
Jeff Moden (8/7/2011)
sqlfriends (8/5/2011)
I would like to do some testing on a testing box for installation.Our production server will be enterprise version
For the license issue, can I just use developer version for testing, I suppose it is exactly the same as enterprise issue, correct?
To extend what Gail stated, the "Developers" Edition is licensed PER DEVELOPER. It's meant to be used at the desktop of a single Developer. About the only way that you could get someone like the SPA to look the other way during an audit on a Development Server running the Development Edition is if every developer that touched it had a licensed copy of the Development Edition.
As Jeff has stated ... now the Developer Edition of SQL 2008 from Amazon at:
is $149.95 and well worth the price of testing, then testing again before unpgrading your production server.
August 7, 2011 at 4:15 pm
bitbucket-25253 (8/7/2011)
Jeff Moden (8/7/2011)
sqlfriends (8/5/2011)
I would like to do some testing on a testing box for installation.Our production server will be enterprise version
For the license issue, can I just use developer version for testing, I suppose it is exactly the same as enterprise issue, correct?
To extend what Gail stated, the "Developers" Edition is licensed PER DEVELOPER. It's meant to be used at the desktop of a single Developer. About the only way that you could get someone like the SPA to look the other way during an audit on a Development Server running the Development Edition is if every developer that touched it had a licensed copy of the Development Edition.
As Jeff has stated ... now the Developer Edition of SQL 2008 from Amazon at:
is $149.95 and well worth the price of testing, then testing again before unpgrading your production server.
At that price, don't buy it from Amazon!!! I bought it direct from Microsoft, price £40 (including shipping DVD), about $65.73 at exchange rates current at the time; since MS has a UK price markup swindle on all software (princes here are about 140% to 150% of US prices) you should be able to get it in the US for something like $45.
edit: It looks as if in the USA SQL 2008 developer edition costs more than 3 times as much as SQL 2008 R2 Developer edition, in which case $150 is about right; over here they both cost the same (last time I looked).
Tom
August 7, 2011 at 6:35 pm
@SQLFRNDZ (8/5/2011)
You want to test on testing environment and why do you compred to Production?You use developer edition but really depends on what you want test I mean there are some missing features in developer edition than from enterprize.
Since the Developer's Edition is claimed by Microsoft to be the Enterprise Edition with special licensing and the ability to run without Windows Server, please identify what those missing features are. 😉
--Jeff Moden
Change is inevitable... Change for the better is not.
August 7, 2011 at 6:39 pm
bitbucket-25253 (8/7/2011)
Jeff Moden (8/7/2011)
sqlfriends (8/5/2011)
I would like to do some testing on a testing box for installation.Our production server will be enterprise version
For the license issue, can I just use developer version for testing, I suppose it is exactly the same as enterprise issue, correct?
To extend what Gail stated, the "Developers" Edition is licensed PER DEVELOPER. It's meant to be used at the desktop of a single Developer. About the only way that you could get someone like the SPA to look the other way during an audit on a Development Server running the Development Edition is if every developer that touched it had a licensed copy of the Development Edition.
As Jeff has stated ... now the Developer Edition of SQL 2008 from Amazon at:
is $149.95 and well worth the price of testing, then testing again before unpgrading your production server.
Oh, my! I bought a copy for a friend of mine a little over a year ago... it was only $65 including shipping from Amazon.
--Jeff Moden
Change is inevitable... Change for the better is not.
August 8, 2011 at 7:46 am
Jeff Moden (8/7/2011)
bitbucket-25253 (8/7/2011)
Jeff Moden (8/7/2011)
sqlfriends (8/5/2011)
I would like to do some testing on a testing box for installation.Our production server will be enterprise version
For the license issue, can I just use developer version for testing, I suppose it is exactly the same as enterprise issue, correct?
To extend what Gail stated, the "Developers" Edition is licensed PER DEVELOPER. It's meant to be used at the desktop of a single Developer. About the only way that you could get someone like the SPA to look the other way during an audit on a Development Server running the Development Edition is if every developer that touched it had a licensed copy of the Development Edition.
As Jeff has stated ... now the Developer Edition of SQL 2008 from Amazon at:
is $149.95 and well worth the price of testing, then testing again before unpgrading your production server.
Oh, my! I bought a copy for a friend of mine a little over a year ago... it was only $65 including shipping from Amazon.
Jeff checking this morning and yesterday - Amazon showed 3 remaining in stock. Could the Amazon price be based on supply and demand?
August 8, 2011 at 9:11 am
Another question related, if our production is going to be using standard version, can I install first the standard version on my testing box, and then after this, I will uninstall it since I don't have a license?
thanks
August 8, 2011 at 4:07 pm
sqlfriends (8/8/2011)
Another question related, if our production is going to be using standard version, can I install first the standard version on my testing box, and then after this, I will uninstall it since I don't have a license?thanks
First of all I am NOT a lawyer so I can not comment on the above.
What I can point out, is having at least 1 Developer Edition available will allow your developer to test code without tying up your Production system. I always shake at the thought that 1 developer might accidentally run untested code on a server that has something like DELETE * FROM Table1 (note the absence of a WHERE clause). So for myself the $150 investment per developer is a very inexpensive investment (insurance policy). Also on the plus side is the ability to test and optimize new or revised code for performance.
Viewing 15 posts - 1 through 14 (of 14 total)
You must be logged in to reply to this topic. Login to reply