Dear all,
if i want to install a sql 2005 into windows 2003 server for the testing
purpose, what edition of sql 2005 should i use, the testing db server is used
for developers and end users to test the application, which edition should i
useThis is a multi-part message in MIME format.
--010009070008040902090402
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
If it's for testing what will be going into production (i.e. UAT - user
acceptance testing) then you should use whatever edition you plan to use
in production, otherwise you might find that some app/code works in your
test environment but not in your production environment.
You should talk to Microsoft about licensing
<http://www.microsoft.com/licensing/default.mspx>. I know in some cases
you can implement SQL Server on a server cost-free (ie. without
licensing it), like when the server is a disaster recovery server and
will never get used except in case of DR, but I don't believe a "test"
server will qualify for free software (I know ours don't).
--
*mike hodgson*
blog: http://sqlnerd.blogspot.com
Joe wrote:
>Dear all,
>if i want to install a sql 2005 into windows 2003 server for the testing
>purpose, what edition of sql 2005 should i use, the testing db server is used
>for developers and end users to test the application, which edition should i
>use
>
--010009070008040902090402
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>If it's for testing what will be going into production (i.e. UAT -
user acceptance testing) then you should use whatever edition you plan
to use in production, otherwise you might find that some app/code works
in your test environment but not in your production environment.<br>
<br>
You should <a href="http://links.10026.com/?link=talk">http://www.microsoft.com/licensing/default.mspx">talk
to Microsoft about licensing</a>. I know in some cases you can
implement SQL Server on a server cost-free (ie. without </tt><tt>licensing
it), like when the server is a disaster recovery server and will never
get used except in case of DR, but I don't believe a "test" server will
qualify for free software (I know ours don't).<br>
</tt>
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
<p><span lang="en-au"><font face="Tahoma" size="2">--<br>
</font></span> <b><span lang="en-au"><font face="Tahoma" size="2">mike
hodgson</font></span></b><span lang="en-au"><br>
<font face="Tahoma" size="2">blog:</font><font face="Tahoma" size="2"> <a
href="http://links.10026.com/?link=http://sqlnerd.blogspot.com</a></font></span>">http://sqlnerd.blogspot.com">http://sqlnerd.blogspot.com</a></font></span>
</p>
</div>
<br>
<br>
Joe wrote:
<blockquote cite="midC0C84BC7-E2E2-435B-AC9D-3472F71F3FE8@.microsoft.com"
type="cite">
<pre wrap="">Dear all,
if i want to install a sql 2005 into windows 2003 server for the testing
purpose, what edition of sql 2005 should i use, the testing db server is used
for developers and end users to test the application, which edition should i
use
</pre>
</blockquote>
</body>
</html>
--010009070008040902090402--|||this mean if i use standard edition in production server
then i need to use standard edition also to testing server?
"Mike Hodgson" wrote:
> If it's for testing what will be going into production (i.e. UAT - user
> acceptance testing) then you should use whatever edition you plan to use
> in production, otherwise you might find that some app/code works in your
> test environment but not in your production environment.
> You should talk to Microsoft about licensing
> <http://www.microsoft.com/licensing/default.mspx>. I know in some cases
> you can implement SQL Server on a server cost-free (ie. without
> licensing it), like when the server is a disaster recovery server and
> will never get used except in case of DR, but I don't believe a "test"
> server will qualify for free software (I know ours don't).
> --
> *mike hodgson*
> blog: http://sqlnerd.blogspot.com
>
> Joe wrote:
> >Dear all,
> >if i want to install a sql 2005 into windows 2003 server for the testing
> >purpose, what edition of sql 2005 should i use, the testing db server is used
> >for developers and end users to test the application, which edition should i
> >use
> >
> >
>|||Hi
It is best to mach the versions between Test (UAT) and Production, otherwise
you are not really simulating production, and you might get some surprises
when you promote code to production if it was making use of performance
benefits it can get from Enterprise Edition.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Joe" <Joe@.discussions.microsoft.com> wrote in message
news:52A3EA45-D91D-43F8-95AF-942DC6A3E48B@.microsoft.com...
> this mean if i use standard edition in production server
> then i need to use standard edition also to testing server?
> "Mike Hodgson" wrote:
>> If it's for testing what will be going into production (i.e. UAT - user
>> acceptance testing) then you should use whatever edition you plan to use
>> in production, otherwise you might find that some app/code works in your
>> test environment but not in your production environment.
>> You should talk to Microsoft about licensing
>> <http://www.microsoft.com/licensing/default.mspx>. I know in some cases
>> you can implement SQL Server on a server cost-free (ie. without
>> licensing it), like when the server is a disaster recovery server and
>> will never get used except in case of DR, but I don't believe a "test"
>> server will qualify for free software (I know ours don't).
>> --
>> *mike hodgson*
>> blog: http://sqlnerd.blogspot.com
>>
>> Joe wrote:
>> >Dear all,
>> >if i want to install a sql 2005 into windows 2003 server for the testing
>> >purpose, what edition of sql 2005 should i use, the testing db server is
>> >used
>> >for developers and end users to test the application, which edition
>> >should i
>> >use
>> >
>> >|||Can i use developer edition to testing server for testing
"Mike Epprecht (SQL MVP)" wrote:
> Hi
> It is best to mach the versions between Test (UAT) and Production, otherwise
> you are not really simulating production, and you might get some surprises
> when you promote code to production if it was making use of performance
> benefits it can get from Enterprise Edition.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Joe" <Joe@.discussions.microsoft.com> wrote in message
> news:52A3EA45-D91D-43F8-95AF-942DC6A3E48B@.microsoft.com...
> > this mean if i use standard edition in production server
> > then i need to use standard edition also to testing server?
> >
> > "Mike Hodgson" wrote:
> >
> >> If it's for testing what will be going into production (i.e. UAT - user
> >> acceptance testing) then you should use whatever edition you plan to use
> >> in production, otherwise you might find that some app/code works in your
> >> test environment but not in your production environment.
> >>
> >> You should talk to Microsoft about licensing
> >> <http://www.microsoft.com/licensing/default.mspx>. I know in some cases
> >> you can implement SQL Server on a server cost-free (ie. without
> >> licensing it), like when the server is a disaster recovery server and
> >> will never get used except in case of DR, but I don't believe a "test"
> >> server will qualify for free software (I know ours don't).
> >>
> >> --
> >> *mike hodgson*
> >> blog: http://sqlnerd.blogspot.com
> >>
> >>
> >>
> >> Joe wrote:
> >>
> >> >Dear all,
> >> >if i want to install a sql 2005 into windows 2003 server for the testing
> >> >purpose, what edition of sql 2005 should i use, the testing db server is
> >> >used
> >> >for developers and end users to test the application, which edition
> >> >should i
> >> >use
> >> >
> >> >
> >>
>
>|||This is a multi-part message in MIME format.
--020901070308000101090808
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Developer Edition is basically the same as Enterprise Edition except
licensed differently. Therefore, if your "test" server is Developer
Edition it may take advantage of some Enterprise/Developer Edition
feature or optimisation that isn't supported by Standard Edition, which
will mean that that particular part of the application you are testing
may either not work in production or behave differently (eg. return slower).
It's not an accurate test if the test & production instances of SQL
server are not the same /edition/ and /product level /(service pack &
patch level). Then again, how many UAT tests are performed under a
realistic production load...?
--
*mike hodgson*
blog: http://sqlnerd.blogspot.com
Joe wrote:
>Can i use developer edition to testing server for testing
>"Mike Epprecht (SQL MVP)" wrote:
>
>>Hi
>>It is best to mach the versions between Test (UAT) and Production, otherwise
>>you are not really simulating production, and you might get some surprises
>>when you promote code to production if it was making use of performance
>>benefits it can get from Enterprise Edition.
>>Regards
>>--
>>Mike Epprecht, Microsoft SQL Server MVP
>>Zurich, Switzerland
>>IM: mike@.epprecht.net
>>MVP Program: http://www.microsoft.com/mvp
>>Blog: http://www.msmvps.com/epprecht/
>>"Joe" <Joe@.discussions.microsoft.com> wrote in message
>>news:52A3EA45-D91D-43F8-95AF-942DC6A3E48B@.microsoft.com...
>>
>>this mean if i use standard edition in production server
>>then i need to use standard edition also to testing server?
>>"Mike Hodgson" wrote:
>>
>>If it's for testing what will be going into production (i.e. UAT - user
>>acceptance testing) then you should use whatever edition you plan to use
>>in production, otherwise you might find that some app/code works in your
>>test environment but not in your production environment.
>>You should talk to Microsoft about licensing
>><http://www.microsoft.com/licensing/default.mspx>. I know in some cases
>>you can implement SQL Server on a server cost-free (ie. without
>>licensing it), like when the server is a disaster recovery server and
>>will never get used except in case of DR, but I don't believe a "test"
>>server will qualify for free software (I know ours don't).
>>--
>>*mike hodgson*
>>blog: http://sqlnerd.blogspot.com
>>
>>Joe wrote:
>>
>>Dear all,
>>if i want to install a sql 2005 into windows 2003 server for the testing
>>purpose, what edition of sql 2005 should i use, the testing db server is
>>used
>>for developers and end users to test the application, which edition
>>should i
>>use
>>
>>
>>
--020901070308000101090808
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=UTF-8" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>Developer Edition is basically the same as Enterprise Edition
except licensed differently. Therefore, if your "test" server is
Developer Edition it may take advantage of some Enterprise/Developer
Edition feature or optimisation that isn't supported by Standard
Edition, which will mean that that particular part of the application
you are testing may either not work in production or behave differently
(eg. return slower).<br>
<br>
It's not an accurate test if the test & production instances of SQL
server are not the same <i>edition</i> and <i>product level </i>(service
pack & patch level). Then again, how many UAT tests are performed
under a realistic production load...?</tt><br>
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
<p><span lang="en-au"><font face="Tahoma" size="2">--<br>
</font></span> <b><span lang="en-au"><font face="Tahoma" size="2">mike
hodgson</font></span></b><span lang="en-au"><br>
<font face="Tahoma" size="2">blog:</font><font face="Tahoma" size="2"> <a
href="http://links.10026.com/?link=http://sqlnerd.blogspot.com</a></font></span>">http://sqlnerd.blogspot.com">http://sqlnerd.blogspot.com</a></font></span>
</p>
</div>
<br>
<br>
Joe wrote:
<blockquote cite="midE0BB56A1-00C8-40CC-9A3B-B98939A5807B@.microsoft.com"
type="cite">
<pre wrap="">Can i use developer edition to testing server for testing
"Mike Epprecht (SQL MVP)" wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Hi
It is best to mach the versions between Test (UAT) and Production, otherwise
you are not really simulating production, and you might get some surprises
when you promote code to production if it was making use of performance
benefits it can get from Enterprise Edition.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: <a class="moz-txt-link-abbreviated" href="http://links.10026.com/?link=mailto:mike@.epprecht.net">mike@.epprecht.net</a>
MVP Program: <a class="moz-txt-link-freetext" href="http://links.10026.com/?link=http://www.microsoft.com/mvp</a>">http://www.microsoft.com/mvp">http://www.microsoft.com/mvp</a>
Blog: <a class="moz-txt-link-freetext" href="http://links.10026.com/?link=http://www.msmvps.com/epprecht/</a>">http://www.msmvps.com/epprecht/">http://www.msmvps.com/epprecht/</a>
"Joe" <a class="moz-txt-link-rfc2396E" href="http://links.10026.com/?link=mailto:Joe@.discussions.microsoft.com"><Joe@.discussions.microsoft.com></a> wrote in message
<a class="moz-txt-link-freetext" href="http://links.10026.com/?link=news:52A3EA45-D91D-43F8-95AF-942DC6A3E48B@.microsoft.com">news:52A3EA45-D91D-43F8-95AF-942DC6A3E48B@.microsoft.com</a>...
</pre>
<blockquote type="cite">
<pre wrap="">this mean if i use standard edition in production server
then i need to use standard edition also to testing server?
"Mike Hodgson" wrote:
</pre>
<blockquote type="cite">
<pre wrap="">If it's for testing what will be going into production (i.e. UAT - user
acceptance testing) then you should use whatever edition you plan to use
in production, otherwise you might find that some app/code works in your
test environment but not in your production environment.
You should talk to Microsoft about licensing
<a class="moz-txt-link-rfc2396E" href="http://links.10026.com/?link=<http://www.microsoft.com/licensing/default.mspx></a>.">http://www.microsoft.com/licensing/default.mspx"><http://www.microsoft.com/licensing/default.mspx></a>. I know in some cases
you can implement SQL Server on a server cost-free (ie. without
licensing it), like when the server is a disaster recovery server and
will never get used except in case of DR, but I don't believe a "test"
server will qualify for free software (I know ours don't).
--
*mike hodgson*
blog: <a class="moz-txt-link-freetext" href="http://links.10026.com/?link=http://sqlnerd.blogspot.com</a>">http://sqlnerd.blogspot.com">http://sqlnerd.blogspot.com</a>
Joe wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Dear all,
if i want to install a sql 2005 into windows 2003 server for the testing
purpose, what edition of sql 2005 should i use, the testing db server is
used
for developers and end users to test the application, which edition
should i
use
</pre>
</blockquote>
</blockquote>
</blockquote>
<pre wrap="">
</pre>
</blockquote>
</blockquote>
</body>
</html>
--020901070308000101090808--|||I want to know that does the license of developer edition permit to install
into the testing server for developers and end users to test the application.
Since i just want to test for UAT. It doesn't matter how the performance or
workload characteristics of the developer edition
Once the application and the database schema are fully tested, it can deploy
into the production server with licensed enterprise or standard edition sql
server.
Does the license concept of the abouve is OK?
"Mike Hodgson" wrote:
> Developer Edition is basically the same as Enterprise Edition except
> licensed differently. Therefore, if your "test" server is Developer
> Edition it may take advantage of some Enterprise/Developer Edition
> feature or optimisation that isn't supported by Standard Edition, which
> will mean that that particular part of the application you are testing
> may either not work in production or behave differently (eg. return slower).
> It's not an accurate test if the test & production instances of SQL
> server are not the same /edition/ and /product level /(service pack &
> patch level). Then again, how many UAT tests are performed under a
> realistic production load...?
> --
> *mike hodgson*
> blog: http://sqlnerd.blogspot.com
>
> Joe wrote:
> >Can i use developer edition to testing server for testing
> >
> >"Mike Epprecht (SQL MVP)" wrote:
> >
> >
> >
> >>Hi
> >>
> >>It is best to mach the versions between Test (UAT) and Production, otherwise
> >>you are not really simulating production, and you might get some surprises
> >>when you promote code to production if it was making use of performance
> >>benefits it can get from Enterprise Edition.
> >>
> >>Regards
> >>--
> >>Mike Epprecht, Microsoft SQL Server MVP
> >>Zurich, Switzerland
> >>
> >>IM: mike@.epprecht.net
> >>
> >>MVP Program: http://www.microsoft.com/mvp
> >>
> >>Blog: http://www.msmvps.com/epprecht/
> >>
> >>"Joe" <Joe@.discussions.microsoft.com> wrote in message
> >>news:52A3EA45-D91D-43F8-95AF-942DC6A3E48B@.microsoft.com...
> >>
> >>
> >>this mean if i use standard edition in production server
> >>then i need to use standard edition also to testing server?
> >>
> >>"Mike Hodgson" wrote:
> >>
> >>
> >>
> >>If it's for testing what will be going into production (i.e. UAT - user
> >>acceptance testing) then you should use whatever edition you plan to use
> >>in production, otherwise you might find that some app/code works in your
> >>test environment but not in your production environment.
> >>
> >>You should talk to Microsoft about licensing
> >><http://www.microsoft.com/licensing/default.mspx>. I know in some cases
> >>you can implement SQL Server on a server cost-free (ie. without
> >>licensing it), like when the server is a disaster recovery server and
> >>will never get used except in case of DR, but I don't believe a "test"
> >>server will qualify for free software (I know ours don't).
> >>
> >>--
> >>*mike hodgson*
> >>blog: http://sqlnerd.blogspot.com
> >>
> >>
> >>
> >>Joe wrote:
> >>
> >>
> >>
> >>Dear all,
> >>if i want to install a sql 2005 into windows 2003 server for the testing
> >>purpose, what edition of sql 2005 should i use, the testing db server is
> >>used
> >>for developers and end users to test the application, which edition
> >>should i
> >>use
> >>
> >>
> >>
> >>
> >>
> >>
> >>
>|||This is a multi-part message in MIME format.
--010504050200090604040107
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Well, given that you understand the capabilities
<http://msdn2.microsoft.com/en-us/library/ms143761.aspx> (not just the
performance) of Developer Edition are greater than the capabilities of
Standard Edition (eg. online indexing, updateable partitioned views, a
swag of data mining algorithms, SSIS transformations, etc.), then my
understanding of the licensing model for Developer Edition is as follows
(from the SQL Licensing FAQ
<http://www.microsoft.com/sql/howtobuy/faq.mspx> and the SQL Licensing &
Pricing Whitepaper
<http://www.microsoft.com/sql/howtobuy/sqlserverlicensing.mspx>):
* It can only be used for development & testing purposes
* It's licensed per developer/tester
* It's not free (but it is very cheap) - costs about USD$50 per
license <http://www.microsoft.com/sql/howtobuy/default.mspx>. Of
course, that's just the standard public pricing; there are other
pricing programs which change matters slightly, like Volume
Licensing
<http://www.microsoft.com/licensing/resources/default.mspx>, Open
License
<http://www.microsoft.com/licensing/programs/open/default.mspx>,
Select License
<http://www.microsoft.com/licensing/programs/sel/default.mspx>, etc.
So, for example, if you plan to have 5 developers and 3 testers using
it, you'd have to buy 8 licenses, which would cost you about $400 US.
That's how I interpret the arrangement. However bear in mind, I don't
work for Microsoft and I could have misinterpreted the licensing
documentation. You'd be best to confirm this with your local Microsoft
rep (see the "Obtain SQL Server 2005" section at the bottom of the How
To Buy <http://www.microsoft.com/sql/howtobuy/default.mspx> page).
--
*mike hodgson*
blog: http://sqlnerd.blogspot.com
Joe wrote:
>I want to know that does the license of developer edition permit to install
>into the testing server for developers and end users to test the application.
>Since i just want to test for UAT. It doesn't matter how the performance or
>workload characteristics of the developer edition
>Once the application and the database schema are fully tested, it can deploy
>into the production server with licensed enterprise or standard edition sql
>server.
>Does the license concept of the abouve is OK?
>"Mike Hodgson" wrote:
>
>>Developer Edition is basically the same as Enterprise Edition except
>>licensed differently. Therefore, if your "test" server is Developer
>>Edition it may take advantage of some Enterprise/Developer Edition
>>feature or optimisation that isn't supported by Standard Edition, which
>>will mean that that particular part of the application you are testing
>>may either not work in production or behave differently (eg. return slower).
>>It's not an accurate test if the test & production instances of SQL
>>server are not the same /edition/ and /product level /(service pack &
>>patch level). Then again, how many UAT tests are performed under a
>>realistic production load...?
>>--
>>*mike hodgson*
>>blog: http://sqlnerd.blogspot.com
>>
>>Joe wrote:
>>
>>Can i use developer edition to testing server for testing
>>"Mike Epprecht (SQL MVP)" wrote:
>>
>>
>>Hi
>>It is best to mach the versions between Test (UAT) and Production, otherwise
>>you are not really simulating production, and you might get some surprises
>>when you promote code to production if it was making use of performance
>>benefits it can get from Enterprise Edition.
>>Regards
>>--
>>Mike Epprecht, Microsoft SQL Server MVP
>>Zurich, Switzerland
>>IM: mike@.epprecht.net
>>MVP Program: http://www.microsoft.com/mvp
>>Blog: http://www.msmvps.com/epprecht/
>>"Joe" <Joe@.discussions.microsoft.com> wrote in message
>>news:52A3EA45-D91D-43F8-95AF-942DC6A3E48B@.microsoft.com...
>>
>>
>>this mean if i use standard edition in production server
>>then i need to use standard edition also to testing server?
>>"Mike Hodgson" wrote:
>>
>>
>>If it's for testing what will be going into production (i.e. UAT - user
>>acceptance testing) then you should use whatever edition you plan to use
>>in production, otherwise you might find that some app/code works in your
>>test environment but not in your production environment.
>>You should talk to Microsoft about licensing
>><http://www.microsoft.com/licensing/default.mspx>. I know in some cases
>>you can implement SQL Server on a server cost-free (ie. without
>>licensing it), like when the server is a disaster recovery server and
>>will never get used except in case of DR, but I don't believe a "test"
>>server will qualify for free software (I know ours don't).
>>--
>>*mike hodgson*
>>blog: http://sqlnerd.blogspot.com
>>
>>Joe wrote:
>>
>>
>>>Dear all,
>>>if i want to install a sql 2005 into windows 2003 server for the testing
>>>purpose, what edition of sql 2005 should i use, the testing db server is
>>>used
>>>for developers and end users to test the application, which edition
>>>should i
>>>use
>>>
>>>
>>>
>>>
>>>
>>>
>>
>>
--010504050200090604040107
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=UTF-8" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>Well, given that you understand the <a
href="http://links.10026.com/?link=capabilities</a>">http://msdn2.microsoft.com/en-us/library/ms143761.aspx">capabilities</a>
(not just the performance) of Developer Edition are greater than the
capabilities of Standard Edition (eg. online indexing, updateable
partitioned views, a swag of data mining algorithms, SSIS
transformations, etc.), then my understanding of the licensing model
for Developer Edition is as follows (from the <a
href="http://links.10026.com/?link=SQL">http://www.microsoft.com/sql/howtobuy/faq.mspx">SQL Licensing FAQ</a>
and the <a
href="http://links.10026.com/?link=SQL">http://www.microsoft.com/sql/howtobuy/sqlserverlicensing.mspx">SQL
Licensing & Pricing Whitepaper</a>):<br>
</tt>
<ul>
<li><tt>It can only be used for development & testing purposes<br>
</tt></li>
<li><tt>It's licensed per developer/tester</tt></li>
<li><tt>It's not free (but it is very cheap) - <a
href="http://links.10026.com/?link=costs">http://www.microsoft.com/sql/howtobuy/default.mspx">costs about
USD$50 per license</a>. Of course, that's just the standard public
pricing; there are other pricing programs which change matters
slightly, like <a
href="http://links.10026.com/?link=Volume">http://www.microsoft.com/licensing/resources/default.mspx">Volume
Licensing</a>, <a
href="http://links.10026.com/?link=Open">http://www.microsoft.com/licensing/programs/open/default.mspx">Open
License</a>, <a
href="http://links.10026.com/?link=Select">http://www.microsoft.com/licensing/programs/sel/default.mspx">Select
License</a>, etc.</tt></li>
</ul>
<tt>So, for example, if you plan to have 5 developers and 3 testers
using it, you'd have to buy 8 licenses, which would cost you about $400
US. That's how I interpret the arrangement. However bear in mind, I
don't work for Microsoft and I could have misinterpreted the licensing
documentation. You'd be best to confirm this with your local Microsoft
rep (see the "Obtain SQL Server 2005" section at the bottom of the <a
href="http://links.10026.com/?link=How">http://www.microsoft.com/sql/howtobuy/default.mspx">How To Buy</a>
page).<br>
</tt>
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
<p><span lang="en-au"><font face="Tahoma" size="2">--<br>
</font></span> <b><span lang="en-au"><font face="Tahoma" size="2">mike
hodgson</font></span></b><span lang="en-au"><br>
<font face="Tahoma" size="2">blog:</font><font face="Tahoma" size="2"> <a
href="http://links.10026.com/?link=http://sqlnerd.blogspot.com</a></font></span>">http://sqlnerd.blogspot.com">http://sqlnerd.blogspot.com</a></font></span>
</p>
</div>
<br>
<br>
Joe wrote:
<blockquote cite="midA1899FE1-9F94-4787-B27D-9F8E33D8141A@.microsoft.com"
type="cite">
<pre wrap="">I want to know that does the license of developer edition permit to install
into the testing server for developers and end users to test the application.
Since i just want to test for UAT. It doesn't matter how the performance or
workload characteristics of the developer edition
Once the application and the database schema are fully tested, it can deploy
into the production server with licensed enterprise or standard edition sql
server.
Does the license concept of the abouve is OK?
"Mike Hodgson" wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Developer Edition is basically the same as Enterprise Edition except
licensed differently. Therefore, if your "test" server is Developer
Edition it may take advantage of some Enterprise/Developer Edition
feature or optimisation that isn't supported by Standard Edition, which
will mean that that particular part of the application you are testing
may either not work in production or behave differently (eg. return slower).
It's not an accurate test if the test & production instances of SQL
server are not the same /edition/ and /product level /(service pack &
patch level). Then again, how many UAT tests are performed under a
realistic production load...?
--
*mike hodgson*
blog: <a class="moz-txt-link-freetext" href="http://links.10026.com/?link=http://sqlnerd.blogspot.com</a>">http://sqlnerd.blogspot.com">http://sqlnerd.blogspot.com</a>
Joe wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Can i use developer edition to testing server for testing
"Mike Epprecht (SQL MVP)" wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Hi
It is best to mach the versions between Test (UAT) and Production, otherwise
you are not really simulating production, and you might get some surprises
when you promote code to production if it was making use of performance
benefits it can get from Enterprise Edition.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: <a class="moz-txt-link-abbreviated" href="http://links.10026.com/?link=mailto:mike@.epprecht.net">mike@.epprecht.net</a>
MVP Program: <a class="moz-txt-link-freetext" href="http://links.10026.com/?link=http://www.microsoft.com/mvp</a>">http://www.microsoft.com/mvp">http://www.microsoft.com/mvp</a>
Blog: <a class="moz-txt-link-freetext" href="http://links.10026.com/?link=http://www.msmvps.com/epprecht/</a>">http://www.msmvps.com/epprecht/">http://www.msmvps.com/epprecht/</a>
"Joe" <a class="moz-txt-link-rfc2396E" href="http://links.10026.com/?link=mailto:Joe@.discussions.microsoft.com"><Joe@.discussions.microsoft.com></a> wrote in message
<a class="moz-txt-link-freetext" href="http://links.10026.com/?link=news:52A3EA45-D91D-43F8-95AF-942DC6A3E48B@.microsoft.com">news:52A3EA45-D91D-43F8-95AF-942DC6A3E48B@.microsoft.com</a>...
</pre>
<blockquote type="cite">
<pre wrap="">this mean if i use standard edition in production server
then i need to use standard edition also to testing server?
"Mike Hodgson" wrote:
</pre>
<blockquote type="cite">
<pre wrap="">If it's for testing what will be going into production (i.e. UAT - user
acceptance testing) then you should use whatever edition you plan to use
in production, otherwise you might find that some app/code works in your
test environment but not in your production environment.
You should talk to Microsoft about licensing
<a class="moz-txt-link-rfc2396E" href="http://links.10026.com/?link=<http://www.microsoft.com/licensing/default.mspx></a>.">http://www.microsoft.com/licensing/default.mspx"><http://www.microsoft.com/licensing/default.mspx></a>. I know in some cases
you can implement SQL Server on a server cost-free (ie. without
licensing it), like when the server is a disaster recovery server and
will never get used except in case of DR, but I don't believe a "test"
server will qualify for free software (I know ours don't).
--
*mike hodgson*
blog: <a class="moz-txt-link-freetext" href="http://links.10026.com/?link=http://sqlnerd.blogspot.com</a>">http://sqlnerd.blogspot.com">http://sqlnerd.blogspot.com</a>
Joe wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Dear all,
if i want to install a sql 2005 into windows 2003 server for the testing
purpose, what edition of sql 2005 should i use, the testing db server is
used
for developers and end users to test the application, which edition
should i
use
</pre>
</blockquote>
</blockquote>
</blockquote>
<pre wrap="">
</pre>
</blockquote>
</blockquote>
</blockquote>
</blockquote>
</body>
</html>
--010504050200090604040107--
