personnal edition license question...

Hi,
I have a first server with SQL 2000 ent.
Today this server support multiple small datawarehouses + staging DB + copy
of the source DB.
I want to move the copy of the operationnal databases to another server, but
this server will be never used except during the loading process and during
the copy of the operationnal database to the server.
Can I use the personnal edition on this second server?
What is the impact from a licensing point of view? (and price)
Or can I use the developper edition?
Final option is to install a workgroup edition (?)
thanks.
Jerome.Personal Edition just requires a client licence, either a CAL or
installed on a machine that accesses another processor-licensed server.
PE is limited to 2GB database size however, so that may be an issue.
Dev Edition is licensed only for non-production development and
testing.
Check out the following link for info on the features supported by each
edition
http://www.microsoft.com/sql/evaluation/features/choosing.mspx
--
David Portas
SQL Server MVP
--|||David Portas wrote:
> Personal Edition just requires a client licence, either a CAL or
> installed on a machine that accesses another processor-licensed
> server. PE is limited to 2GB database size however, so that may be an
> issue.
> Dev Edition is licensed only for non-production development and
> testing.
> Check out the following link for info on the features supported by
> each edition
> http://www.microsoft.com/sql/evaluation/features/choosing.mspx
> --
> David Portas
> SQL Server MVP
David,
PE does not have a 2GB limit like MSDE. However, it does have the same
query governor in MSDE that throttles SQL Server with more than about 5
connections. I currently have Personal Edition running on my XP laptop
with databases in the 5GB range.
David Gugick
Quest Software
www.imceda.com
www.quest.com|||and what if we have a processor license of SQL 2000 enterprise ?
does the personnal edition follow the same license model?
"David Gugick" <david.gugick-nospam@.quest.com> wrote in message
news:uUUfsdTmFHA.2860@.TK2MSFTNGP15.phx.gbl...
> David Portas wrote:
>> Personal Edition just requires a client licence, either a CAL or
>> installed on a machine that accesses another processor-licensed
>> server. PE is limited to 2GB database size however, so that may be an
>> issue.
>> Dev Edition is licensed only for non-production development and
>> testing.
>> Check out the following link for info on the features supported by
>> each edition
>> http://www.microsoft.com/sql/evaluation/features/choosing.mspx
>> --
>> David Portas
>> SQL Server MVP
> David,
> PE does not have a 2GB limit like MSDE. However, it does have the same
> query governor in MSDE that throttles SQL Server with more than about 5
> connections. I currently have Personal Edition running on my XP laptop
> with databases in the 5GB range.
>
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com|||Jéjé wrote:
> and what if we have a processor license of SQL 2000 enterprise ?
> does the personnal edition follow the same license model?
>
http://www.microsoft.com/sql/howtobuy/personal.mspx
--
David Gugick
Quest Software
www.imceda.com
www.quest.com|||like other license document from MS...
this document doesn't describe what's appends exactly...
I have a 2 processors license, so I have a 2 processor personnal edition
license?
"David Gugick" <david.gugick-nospam@.quest.com> wrote in message
news:OLCUa5UmFHA.3828@.TK2MSFTNGP12.phx.gbl...
> Jéjé wrote:
>> and what if we have a processor license of SQL 2000 enterprise ?
>> does the personnal edition follow the same license model?
> http://www.microsoft.com/sql/howtobuy/personal.mspx
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com|||Jéjé wrote:
> like other license document from MS...
> this document doesn't describe what's appends exactly...
> I have a 2 processors license, so I have a 2 processor personnal
> edition license?
You should speak to a MS licensing exec for licensing questions. My
understanding is that if you own Standard or EE and have a processor
license, you can use Personal Edition on non-server hardware to support
your application when they are not connected to the main server.
--
David Gugick
Quest Software
www.imceda.com
www.quest.com|||Yes, thanks for the correction.
--
David Portas
SQL Server MVP
--