November 30, 2010 at 10:37 am
I already have enterprise version of 2008 but would like have stage server with the same databases like stand alone server where i will be using compression and paritioning but can not spend as much as enterprise. Thinking of Developer edition, can that fit ot my requirement?
November 30, 2010 at 10:41 am
Dev Edition can do anything Enterprise can do. You just can't use it for anything except development and testing.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
November 30, 2010 at 10:50 am
OK, here is what i am going to do with DEveloper edition, please let me know if i am voilating anything.
I have a stage server where in i will pump data from raw files and do all kinds of transaformations and then backup the database and restore on to our production server where i have SQl 2008 enterprise edition.
Currently i am doing the same using 2 SQL 2005 ent editions on prod and stage but i am migrating to 2008 but would like to save money for the stage server. If i have SQL 2005 on stage server i may not be able to use DB Compression option effectively becasue everytime i restore a stage database i may have to compress the database on production. I will be doing the resotres once a month which is our requirement and can not be changed.
Appreciate you thoughts on this process and finally what would be the cost of 2008 dev edition?
November 30, 2010 at 10:53 am
That's part of your production data pipeline. You can't use Dev Edition for that.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
November 30, 2010 at 10:58 am
any other recommendations for my scenario to cut down the cost?
November 30, 2010 at 11:05 am
Not really. Since you need data compression at both points, you're pretty limited on your options.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
November 30, 2010 at 11:14 am
what are the limitations i have to observe if i want to use developer edition on my stage for my purpose and what is the cost of Dev edition?
November 30, 2010 at 12:48 pm
The limitations are you cannot use Dev Edition to do anything except develop and test databases and software. If you use it in a production environment at all, which is what you are talking about doing (a staging server to a production server is a production environment), you will be violating the license for Dev Edition. If you're going to break the law that way, why bother buying a copy in the first place, just use a second copy of your Enterprise Edition installation, and hope nobody ever catches you at it. The fines can be pretty heavy duty for that.
Dev Edition generally costs about $50 (US). I recommend NOT using it this way. It's illegal. Make sure the managers at your company understand the legal ramifications before you do something illegal for their company. Then, if they still want you to do it, get ready to leave the company, because if they'll break the law to save money on software, they obviously have very low standards, and one day, they will break the law to save money on something like your salary, your insurance, or something like that. Working for criminals is working for criminals.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
November 30, 2010 at 1:43 pm
You need to also realize that the developer edition is licensed by individual - not by server. So, if you install developer edition on a server and have 5 developers accessing that system for development work - you need 5 licenses, one for each developer.
If you have any end-users accessing the system, at all - then it would be considered a production system and you would be in violation of the license.
Since you need Enterprise features for your staging system - then your only option is to purchase the Enterprise Edition for that server. I would evaluate the cost of the licensing your staging server by device and/or user CAL's and compare that to the processor license. If you have a controlled number of devices and/or users accessing that system it might be a lot less expensive.
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
November 30, 2010 at 1:49 pm
she could install Enterprise edition again on the production server as a new instance, and not be out of compliance with the license, right?
if the server was beefy enough to handle two instances, then she'd have her staging server for no extra cost, i believe.
Lowell
November 30, 2010 at 3:10 pm
Lowell (11/30/2010)
she could install Enterprise edition again on the production server as a new instance, and not be out of compliance with the license, right?if the server was beefy enough to handle two instances, then she'd have her staging server for no extra cost, i believe.
Depends on the licensing. Per processor licensing allows multiple instances.
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
November 30, 2010 at 3:13 pm
Lowell (11/30/2010)
she could install Enterprise edition again on the production server as a new instance, and not be out of compliance with the license, right?if the server was beefy enough to handle two instances, then she'd have her staging server for no extra cost, i believe.
If it's on the same hardware, either virtualized or instances, yes. If it's not on the same CPUs, no.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
November 30, 2010 at 5:52 pm
I dont want to do on multiple instances, to get better performance we have isolated these servers. Looks like there is no other go,i may have to get another ent edition.
thanks for all your inputs.
December 1, 2010 at 6:11 am
You're welcome.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 14 posts - 1 through 14 (of 14 total)
You must be logged in to reply to this topic. Login to reply