sql record counts: lifecyle

Hi
Could someone tell me whether I need to use the same edition of Sql Server
in Dev, UAT & Prod. I need Enterprise Edition in PROD but wonder if I need to
develop and then test it in UAT on Enterprise Edition and thereby
consequently buy 3 Enterprise Edition licenses.
--
Cheers
BilHello, Bil
Here is a quote from http://www.microsoft.com/sql/editions/developer/default.mspx:
"[...] Developer Edition includes all of the functionality of
Enterprise Edition, but is licensed only for development, test, and
demo use. [...] Each license of SQL Server 2005 Developer Edition
entitles one developer to use the software [...]"
So you can buy only one Enterprise Edition license and a number of
Developer Edition licenses equal to the number of developers and
testers involved in your project.
Razvan|||Hi Razvan
I'm going to be using Sql Server 2000 rather than 2005. Do you know if this
is the same. Also do you know how much each license for Developer Edition
costs ?
To clarify do you mean that instead of having to buy 3 Enterprise Edition
licenses ( each for 4 CPU's ) I would only have to buy 1 Enterprise Edition
license for PROD ( 4 CPU's ) and enough Dev Edition licenses to cover
developpers and testers ( approx 50 ). It will depend on the cost of the
approx 50 licenses for Dev Edition against the 2 extra Enterprise Edition
licenses ( 4 CPU's ).
--
Cheers
Bil
"Razvan Socol" wrote:
> Hello, Bil
> Here is a quote from http://www.microsoft.com/sql/editions/developer/default.mspx:
> "[...] Developer Edition includes all of the functionality of
> Enterprise Edition, but is licensed only for development, test, and
> demo use. [...] Each license of SQL Server 2005 Developer Edition
> entitles one developer to use the software [...]"
> So you can buy only one Enterprise Edition license and a number of
> Developer Edition licenses equal to the number of developers and
> testers involved in your project.
> Razvan
>|||Dev feature matrix is same as Enterprise edition in both 2000 and 2005 IIRC.
However, if you intend/need (you SHOULD) do scalability testing you should
probably get an Enterprise license for your test box. The feature set is
the same, but I believe (but cannot find a link to at the moment darn it)
the internal engine has some differences as to how much work it can do how
well per unit time. Could be wrong on that tho.
--
TheSQLGuru
President
Indicium Resources, Inc.
"Bil" <Bil@.discussions.microsoft.com> wrote in message
news:F314CDD4-FA72-444E-AB48-7FA9FDDCDFD2@.microsoft.com...
> Hi Razvan
> I'm going to be using Sql Server 2000 rather than 2005. Do you know if
> this
> is the same. Also do you know how much each license for Developer Edition
> costs ?
> To clarify do you mean that instead of having to buy 3 Enterprise Edition
> licenses ( each for 4 CPU's ) I would only have to buy 1 Enterprise
> Edition
> license for PROD ( 4 CPU's ) and enough Dev Edition licenses to cover
> developpers and testers ( approx 50 ). It will depend on the cost of the
> approx 50 licenses for Dev Edition against the 2 extra Enterprise Edition
> licenses ( 4 CPU's ).
> --
> Cheers
> Bil
>
> "Razvan Socol" wrote:
>> Hello, Bil
>> Here is a quote from
>> http://www.microsoft.com/sql/editions/developer/default.mspx:
>> "[...] Developer Edition includes all of the functionality of
>> Enterprise Edition, but is licensed only for development, test, and
>> demo use. [...] Each license of SQL Server 2005 Developer Edition
>> entitles one developer to use the software [...]"
>> So you can buy only one Enterprise Edition license and a number of
>> Developer Edition licenses equal to the number of developers and
>> testers involved in your project.
>> Razvan
>>|||The only difference between the Development and Enterprise editions is
licensing. I don't see any problem with performance testing using the
Developer Edition as long as Enterprise will used in production.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"TheSQLGuru" <kgboles@.earthlink.net> wrote in message
news:O2usoLroHHA.4772@.TK2MSFTNGP05.phx.gbl...
> Dev feature matrix is same as Enterprise edition in both 2000 and 2005
> IIRC. However, if you intend/need (you SHOULD) do scalability testing you
> should probably get an Enterprise license for your test box. The feature
> set is the same, but I believe (but cannot find a link to at the moment
> darn it) the internal engine has some differences as to how much work it
> can do how well per unit time. Could be wrong on that tho.
> --
> TheSQLGuru
> President
> Indicium Resources, Inc.
> "Bil" <Bil@.discussions.microsoft.com> wrote in message
> news:F314CDD4-FA72-444E-AB48-7FA9FDDCDFD2@.microsoft.com...
>> Hi Razvan
>> I'm going to be using Sql Server 2000 rather than 2005. Do you know if
>> this
>> is the same. Also do you know how much each license for Developer
>> Edition
>> costs ?
>> To clarify do you mean that instead of having to buy 3 Enterprise Edition
>> licenses ( each for 4 CPU's ) I would only have to buy 1 Enterprise
>> Edition
>> license for PROD ( 4 CPU's ) and enough Dev Edition licenses to cover
>> developpers and testers ( approx 50 ). It will depend on the cost of the
>> approx 50 licenses for Dev Edition against the 2 extra Enterprise Edition
>> licenses ( 4 CPU's ).
>> --
>> Cheers
>> Bil
>>
>> "Razvan Socol" wrote:
>> Hello, Bil
>> Here is a quote from
>> http://www.microsoft.com/sql/editions/developer/default.mspx:
>> "[...] Developer Edition includes all of the functionality of
>> Enterprise Edition, but is licensed only for development, test, and
>> demo use. [...] Each license of SQL Server 2005 Developer Edition
>> entitles one developer to use the software [...]"
>> So you can buy only one Enterprise Edition license and a number of
>> Developer Edition licenses equal to the number of developers and
>> testers involved in your project.
>> Razvan
>>
>|||Thanks Dan / All
How much do the Dev Edition Licenses cost ? As per my usage as listed in the
email what are the cost advantages of going with Dev Edition instead of Ent
Edition. Ball park how much cheaper would going the Dev Edition route be ?
--
Cheers
Bil
"Dan Guzman" wrote:
> The only difference between the Development and Enterprise editions is
> licensing. I don't see any problem with performance testing using the
> Developer Edition as long as Enterprise will used in production.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "TheSQLGuru" <kgboles@.earthlink.net> wrote in message
> news:O2usoLroHHA.4772@.TK2MSFTNGP05.phx.gbl...
> > Dev feature matrix is same as Enterprise edition in both 2000 and 2005
> > IIRC. However, if you intend/need (you SHOULD) do scalability testing you
> > should probably get an Enterprise license for your test box. The feature
> > set is the same, but I believe (but cannot find a link to at the moment
> > darn it) the internal engine has some differences as to how much work it
> > can do how well per unit time. Could be wrong on that tho.
> >
> > --
> > TheSQLGuru
> > President
> > Indicium Resources, Inc.
> >
> > "Bil" <Bil@.discussions.microsoft.com> wrote in message
> > news:F314CDD4-FA72-444E-AB48-7FA9FDDCDFD2@.microsoft.com...
> >> Hi Razvan
> >>
> >> I'm going to be using Sql Server 2000 rather than 2005. Do you know if
> >> this
> >> is the same. Also do you know how much each license for Developer
> >> Edition
> >> costs ?
> >>
> >> To clarify do you mean that instead of having to buy 3 Enterprise Edition
> >> licenses ( each for 4 CPU's ) I would only have to buy 1 Enterprise
> >> Edition
> >> license for PROD ( 4 CPU's ) and enough Dev Edition licenses to cover
> >> developpers and testers ( approx 50 ). It will depend on the cost of the
> >> approx 50 licenses for Dev Edition against the 2 extra Enterprise Edition
> >> licenses ( 4 CPU's ).
> >> --
> >> Cheers
> >> Bil
> >>
> >>
> >> "Razvan Socol" wrote:
> >>
> >> Hello, Bil
> >>
> >> Here is a quote from
> >> http://www.microsoft.com/sql/editions/developer/default.mspx:
> >>
> >> "[...] Developer Edition includes all of the functionality of
> >> Enterprise Edition, but is licensed only for development, test, and
> >> demo use. [...] Each license of SQL Server 2005 Developer Edition
> >> entitles one developer to use the software [...]"
> >>
> >> So you can buy only one Enterprise Edition license and a number of
> >> Developer Edition licenses equal to the number of developers and
> >> testers involved in your project.
> >>
> >> Razvan
> >>
> >>
> >
> >
>|||http://www.amazon.com/Microsoft-SQL-Server-2000-Developer/dp/B000050AVL
I can't find it on Microsoft's site... They're already hyping SQL
Server Code-Named 'Katmai'. You'll have to contact Microsoft to see.
Developer Edition of 2005 is $49.95
Cheers,
Jason Lepack
On May 30, 8:48 am, Bil <B...@.discussions.microsoft.com> wrote:
> Thanks Dan / All
> How much do the Dev Edition Licenses cost ? As per my usage as listed in the
> email what are the cost advantages of going with Dev Edition instead of Ent
> Edition. Ball park how much cheaper would going the Dev Edition route be ?
> --
> Cheers
> Bil
>
> "Dan Guzman" wrote:
> > The only difference between the Development and Enterprise editions is
> > licensing. I don't see any problem with performance testing using the
> > Developer Edition as long as Enterprise will used in production.
> > --
> > Hope this helps.
> > Dan Guzman
> > SQL Server MVP
> > "TheSQLGuru" <kgbo...@.earthlink.net> wrote in message
> >news:O2usoLroHHA.4772@.TK2MSFTNGP05.phx.gbl...
> > > Dev feature matrix is same as Enterprise edition in both 2000 and 2005
> > > IIRC. However, if you intend/need (you SHOULD) do scalability testing you
> > > should probably get an Enterprise license for your test box. The feature
> > > set is the same, but I believe (but cannot find a link to at the moment
> > > darn it) the internal engine has some differences as to how much work it
> > > can do how well per unit time. Could be wrong on that tho.
> > > --
> > > TheSQLGuru
> > > President
> > > Indicium Resources, Inc.
> > > "Bil" <B...@.discussions.microsoft.com> wrote in message
> > >news:F314CDD4-FA72-444E-AB48-7FA9FDDCDFD2@.microsoft.com...
> > >> Hi Razvan
> > >> I'm going to be using Sql Server 2000 rather than 2005. Do you know if
> > >> this
> > >> is the same. Also do you know how much each license for Developer
> > >> Edition
> > >> costs ?
> > >> To clarify do you mean that instead of having to buy 3 Enterprise Edition
> > >> licenses ( each for 4 CPU's ) I would only have to buy 1 Enterprise
> > >> Edition
> > >> license for PROD ( 4 CPU's ) and enough Dev Edition licenses to cover
> > >> developpers and testers ( approx 50 ). It will depend on the cost of the
> > >> approx 50 licenses for Dev Edition against the 2 extra Enterprise Edition
> > >> licenses ( 4 CPU's ).
> > >> --
> > >> Cheers
> > >> Bil
> > >> "Razvan Socol" wrote:
> > >> Hello, Bil
> > >> Here is a quote from
> > >>http://www.microsoft.com/sql/editions/developer/default.mspx:
> > >> "[...] Developer Edition includes all of the functionality of
> > >> Enterprise Edition, but is licensed only for development, test, and
> > >> demo use. [...] Each license of SQL Server 2005 Developer Edition
> > >> entitles one developer to use the software [...]"
> > >> So you can buy only one Enterprise Edition license and a number of
> > >> Developer Edition licenses equal to the number of developers and
> > >> testers involved in your project.
> > >> Razvan- Hide quoted text -
> - Show quoted text -|||As Jason mentioned, Developer Edition is about $50 USD. It's also included
with MSDN subscriptions. Standard and Enterprise cost thousands of dollars
so it's a no-brainer to go with Developer for development.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Bil" <Bil@.discussions.microsoft.com> wrote in message
news:FA8E188F-AC87-4B00-8729-62A4CAD4C26D@.microsoft.com...
> Thanks Dan / All
> How much do the Dev Edition Licenses cost ? As per my usage as listed in
> the
> email what are the cost advantages of going with Dev Edition instead of
> Ent
> Edition. Ball park how much cheaper would going the Dev Edition route be ?
> --
> Cheers
> Bil
>
> "Dan Guzman" wrote:
>> The only difference between the Development and Enterprise editions is
>> licensing. I don't see any problem with performance testing using the
>> Developer Edition as long as Enterprise will used in production.
>> --
>> Hope this helps.
>> Dan Guzman
>> SQL Server MVP
>> "TheSQLGuru" <kgboles@.earthlink.net> wrote in message
>> news:O2usoLroHHA.4772@.TK2MSFTNGP05.phx.gbl...
>> > Dev feature matrix is same as Enterprise edition in both 2000 and 2005
>> > IIRC. However, if you intend/need (you SHOULD) do scalability testing
>> > you
>> > should probably get an Enterprise license for your test box. The
>> > feature
>> > set is the same, but I believe (but cannot find a link to at the moment
>> > darn it) the internal engine has some differences as to how much work
>> > it
>> > can do how well per unit time. Could be wrong on that tho.
>> >
>> > --
>> > TheSQLGuru
>> > President
>> > Indicium Resources, Inc.
>> >
>> > "Bil" <Bil@.discussions.microsoft.com> wrote in message
>> > news:F314CDD4-FA72-444E-AB48-7FA9FDDCDFD2@.microsoft.com...
>> >> Hi Razvan
>> >>
>> >> I'm going to be using Sql Server 2000 rather than 2005. Do you know if
>> >> this
>> >> is the same. Also do you know how much each license for Developer
>> >> Edition
>> >> costs ?
>> >>
>> >> To clarify do you mean that instead of having to buy 3 Enterprise
>> >> Edition
>> >> licenses ( each for 4 CPU's ) I would only have to buy 1 Enterprise
>> >> Edition
>> >> license for PROD ( 4 CPU's ) and enough Dev Edition licenses to cover
>> >> developpers and testers ( approx 50 ). It will depend on the cost of
>> >> the
>> >> approx 50 licenses for Dev Edition against the 2 extra Enterprise
>> >> Edition
>> >> licenses ( 4 CPU's ).
>> >> --
>> >> Cheers
>> >> Bil
>> >>
>> >>
>> >> "Razvan Socol" wrote:
>> >>
>> >> Hello, Bil
>> >>
>> >> Here is a quote from
>> >> http://www.microsoft.com/sql/editions/developer/default.mspx:
>> >>
>> >> "[...] Developer Edition includes all of the functionality of
>> >> Enterprise Edition, but is licensed only for development, test, and
>> >> demo use. [...] Each license of SQL Server 2005 Developer Edition
>> >> entitles one developer to use the software [...]"
>> >>
>> >> So you can buy only one Enterprise Edition license and a number of
>> >> Developer Edition licenses equal to the number of developers and
>> >> testers involved in your project.
>> >>
>> >> Razvan
>> >>
>> >>
>> >
>> >|||Thanks Jason
So basically 50 devloppers / testers * approx 50 bucks is a damn site
cheaper than having to buy 2 Ent Edition licenses that's for sure. Unless
anyone has anything else to say then this is the route I will take :-
50 Dev Edition Licenses to cover Dev and Testing Environments. I'm presuming
as it's just 1 license per Developper I can split the Dev and Testing across
lots of Dev Edition Instances
This seems much better than paying a whole heap more for only being able to
have 1 Instance of Ent Edition in Dev and 1 Ent Edition in UAT
--
Cheers
Bil
"Jason Lepack" wrote:
> http://www.amazon.com/Microsoft-SQL-Server-2000-Developer/dp/B000050AVL
> I can't find it on Microsoft's site... They're already hyping SQL
> Server Code-Named 'Katmai'. You'll have to contact Microsoft to see.
> Developer Edition of 2005 is $49.95
> Cheers,
> Jason Lepack
> On May 30, 8:48 am, Bil <B...@.discussions.microsoft.com> wrote:
> > Thanks Dan / All
> >
> > How much do the Dev Edition Licenses cost ? As per my usage as listed in the
> > email what are the cost advantages of going with Dev Edition instead of Ent
> > Edition. Ball park how much cheaper would going the Dev Edition route be ?
> > --
> > Cheers
> > Bil
> >
> >
> >
> > "Dan Guzman" wrote:
> > > The only difference between the Development and Enterprise editions is
> > > licensing. I don't see any problem with performance testing using the
> > > Developer Edition as long as Enterprise will used in production.
> >
> > > --
> > > Hope this helps.
> >
> > > Dan Guzman
> > > SQL Server MVP
> >
> > > "TheSQLGuru" <kgbo...@.earthlink.net> wrote in message
> > >news:O2usoLroHHA.4772@.TK2MSFTNGP05.phx.gbl...
> > > > Dev feature matrix is same as Enterprise edition in both 2000 and 2005
> > > > IIRC. However, if you intend/need (you SHOULD) do scalability testing you
> > > > should probably get an Enterprise license for your test box. The feature
> > > > set is the same, but I believe (but cannot find a link to at the moment
> > > > darn it) the internal engine has some differences as to how much work it
> > > > can do how well per unit time. Could be wrong on that tho.
> >
> > > > --
> > > > TheSQLGuru
> > > > President
> > > > Indicium Resources, Inc.
> >
> > > > "Bil" <B...@.discussions.microsoft.com> wrote in message
> > > >news:F314CDD4-FA72-444E-AB48-7FA9FDDCDFD2@.microsoft.com...
> > > >> Hi Razvan
> >
> > > >> I'm going to be using Sql Server 2000 rather than 2005. Do you know if
> > > >> this
> > > >> is the same. Also do you know how much each license for Developer
> > > >> Edition
> > > >> costs ?
> >
> > > >> To clarify do you mean that instead of having to buy 3 Enterprise Edition
> > > >> licenses ( each for 4 CPU's ) I would only have to buy 1 Enterprise
> > > >> Edition
> > > >> license for PROD ( 4 CPU's ) and enough Dev Edition licenses to cover
> > > >> developpers and testers ( approx 50 ). It will depend on the cost of the
> > > >> approx 50 licenses for Dev Edition against the 2 extra Enterprise Edition
> > > >> licenses ( 4 CPU's ).
> > > >> --
> > > >> Cheers
> > > >> Bil
> >
> > > >> "Razvan Socol" wrote:
> >
> > > >> Hello, Bil
> >
> > > >> Here is a quote from
> > > >>http://www.microsoft.com/sql/editions/developer/default.mspx:
> >
> > > >> "[...] Developer Edition includes all of the functionality of
> > > >> Enterprise Edition, but is licensed only for development, test, and
> > > >> demo use. [...] Each license of SQL Server 2005 Developer Edition
> > > >> entitles one developer to use the software [...]"
> >
> > > >> So you can buy only one Enterprise Edition license and a number of
> > > >> Developer Edition licenses equal to the number of developers and
> > > >> testers involved in your project.
> >
> > > >> Razvan- Hide quoted text -
> >
> > - Show quoted text -
>
>

Friday, February 17, 2012

Dev Sql Server Edition same thru project lifecyle ?

Dev Sql Server Edition same thru project lifecyle ?

sql record counts

Blog Archive

About Me