Upgrade addvice

[Anonymous]

I have run up against the 2 GB limit for MSDE and I need to know what my best options are for upgrading. I have been looking around on the net and have found Microsoft sql server 2000 standard with five cals for about $800. There are many versions of this software available What exactly do I need I have four users currently. Also could I get Microsoft sql 2005 workgroup edition software $700 or would I need standard edition $1750? Will Vault and Inventor continue to support sql 2000 and for how long, am I wasting my time and money buying an old version of software that is currently getting a major release?

Any help or suggestions are greatly appreciated

[Squeezer]

I'm not sure that SQL 2005 is supported yet. You'll have to wait for an Autodesk person to respond to this thead regarding it & the life span of SQL 2000.

Can you you reduce the # of properties in use by vault & re-index the database to get back under the 2GB limit?

[Anonymous]

I let the database get to close to the 2GB size (1.89) and now it doesn't have enough room to re-index

[Anonymous]

SQL 2005 is not supported so you will need to go with one of the SQL 2000 options. You will need a CAL for each machine that will be accessing Vault/Productstream.

[Anonymous]

John,

As already mentioned, SQL 2005 is not supported for Vault 4 or Productstream
4.5. However, it will be supported for the next release of both products as
will SQL 2005 Express. Regarding the workgroup edition, that is not
supported, but the Enterprise and Standard editions of full SQL are
supported.

I'm not 100% sure about your licensing needs, but there's a lot of good
information on the Microsoft web site regarding licensing.. There's an FAQ,
a whitepaper and plenty of documentation available that will help you make
the most intelligent decision for what will meet your needs. Here's a few
links I have:

How to Buy
http://www.microsoft.com/sql/howtobuy/default.mspx

SQL Server 2005 licesning FAQ
http://www.microsoft.com/sql/howtobuy/faq.mspx

SQL Server 2005 licensing whitepaper
http://www.microsoft.com/sql/howtobuy/sqlserverlicensing.mspx

Good luck!
Bob

wrote in message news:5087444@discussion.autodesk.com...
I have run up against the 2 GB limit for MSDE and I need to know what my
best options are for upgrading. I have been looking around on the net and
have found Microsoft sql server 2000 standard with five cals for about $800.
There are many versions of this software available What exactly do I need I
have four users currently. Also could I get Microsoft sql 2005 workgroup
edition software $700 or would I need standard edition $1750? Will Vault and
Inventor continue to support sql 2000 and for how long, am I wasting my time
and money buying an old version of software that is currently getting a
major release?

Any help or suggestions are greatly appreciated

[Anonymous]

To add to Bob's answer, Microsoft has what I believe to be called is a
Software Assurance agreement which allows you to purchase SQL 2005 but run
SQL 2000 under that aggreement until you need to upgrade to SQL 2005. Check
with your Microsoft reseller for details

Irvin
"Bob Henry (Autodesk)" wrote in message
news:5087934@discussion.autodesk.com...
John,

As already mentioned, SQL 2005 is not supported for Vault 4 or Productstream
4.5. However, it will be supported for the next release of both products as
will SQL 2005 Express. Regarding the workgroup edition, that is not
supported, but the Enterprise and Standard editions of full SQL are
supported.

I'm not 100% sure about your licensing needs, but there's a lot of good
information on the Microsoft web site regarding licensing.. There's an FAQ,
a whitepaper and plenty of documentation available that will help you make
the most intelligent decision for what will meet your needs. Here's a few
links I have:

How to Buy
http://www.microsoft.com/sql/howtobuy/default.mspx

SQL Server 2005 licesning FAQ
http://www.microsoft.com/sql/howtobuy/faq.mspx

SQL Server 2005 licensing whitepaper
http://www.microsoft.com/sql/howtobuy/sqlserverlicensing.mspx

Good luck!
Bob

wrote in message news:5087444@discussion.autodesk.com...
I have run up against the 2 GB limit for MSDE and I need to know what my
best options are for upgrading. I have been looking around on the net and
have found Microsoft sql server 2000 standard with five cals for about $800.
There are many versions of this software available What exactly do I need I
have four users currently. Also could I get Microsoft sql 2005 workgroup
edition software $700 or would I need standard edition $1750? Will Vault and
Inventor continue to support sql 2000 and for how long, am I wasting my time
and money buying an old version of software that is currently getting a
major release?

Any help or suggestions are greatly appreciated

[Anonymous]

I think that's not true. The Data Management Server accesses the SQL
instance as a single user regardless of the number of users.

>You will need a CAL for each machine that will be accessing
Vault/Productstream.

[Anonymous]

According to Microsoft's documentation, the CALS are based on the Client
Access Licensing, thus it's the # of clients that will be connecting to the
server, or SQL instance, in particular. I'm not sure of the pricing per CAL
or per processor, but you need to determine how many users will be
connecting (or go by device not user - ie, machine not user, if that's more
applicable) to see if the # of CALS x the cost per CAL is more/less than the
cost of licensing by processor.

Hope that helps.


"Dave Hoder" wrote in
message news:5088203@discussion.autodesk.com...
I think that's not true. The Data Management Server accesses the SQL
instance as a single user regardless of the number of users.

>You will need a CAL for each machine that will be accessing
Vault/Productstream.

[Anonymous]

From the research I have done so far I think cals are about $150 per seat.

[Anonymous]

From an earlier thread:

The only 'client' that access the SQL Server is the Autodesk Data Management
Server (ADMS). No real Autodesk client (such as Vault Explorer or
Productstream) accesses the SQL server directly, therefore my personal
opinion is that you need only one CAL for SQL server and that's the one for
ADMS.

Hope this helps,

Martin Gasevski
Software Engineer
Autodesk, Inc.

So if according to MS you need a cal for each workstation, you should
install a bunch of cal's even though only one will ever be used? How moral
are you feeling?

[Anonymous]

I don't think that is the case actually. It's all handled through ADMS and
the "VaultSys" user, but using CALS as a licensing mechanism can be
misleading because it's easy to fall outside the scope of what you're
licensed for. By that I mean if you purchase X number of CALS that through
web clients (Productstream Explorer) and Vault and/or PS clients, you can
easily add new clients seats and not update/increase the number of CALS
you're licensed for becoming noncompliant. Our software was written with the
"per processor" model in mind, but there's nothing that would keep you from
going with either model - CALs or by processor.

The best answer in this case is to consult with Microsoft or the Microsoft
parther that you'll be purchasing SQL from. They likely will be your best
resource and can best answer what will meet your needs. If you use any other
instances of SQL than you'll need to account for those as well.

Thanks,
Bob

"Dave Hoder" wrote in
message news:5089706@discussion.autodesk.com...
From an earlier thread:

The only 'client' that access the SQL Server is the Autodesk Data Management
Server (ADMS). No real Autodesk client (such as Vault Explorer or
Productstream) accesses the SQL server directly, therefore my personal
opinion is that you need only one CAL for SQL server and that's the one for
ADMS.

Hope this helps,

Martin Gasevski
Software Engineer
Autodesk, Inc.

So if according to MS you need a cal for each workstation, you should
install a bunch of cal's even though only one will ever be used? How moral
are you feeling?

[Anonymous]

I second what Bob stated. The original message quoted was a "personal
opinion". Please make sure that you check with Microsoft or a Microsoft
partner for the correct interpretation of how many licenses that you need.

-jeff

"Bob Henry (Autodesk)" wrote in message
news:5089721@discussion.autodesk.com...
I don't think that is the case actually. It's all handled through ADMS and
the "VaultSys" user, but using CALS as a licensing mechanism can be
misleading because it's easy to fall outside the scope of what you're
licensed for. By that I mean if you purchase X number of CALS that through
web clients (Productstream Explorer) and Vault and/or PS clients, you can
easily add new clients seats and not update/increase the number of CALS
you're licensed for becoming noncompliant. Our software was written with the
"per processor" model in mind, but there's nothing that would keep you from
going with either model - CALs or by processor.

The best answer in this case is to consult with Microsoft or the Microsoft
parther that you'll be purchasing SQL from. They likely will be your best
resource and can best answer what will meet your needs. If you use any other
instances of SQL than you'll need to account for those as well.

Thanks,
Bob

"Dave Hoder" wrote in
message news:5089706@discussion.autodesk.com...
From an earlier thread:

The only 'client' that access the SQL Server is the Autodesk Data Management
Server (ADMS). No real Autodesk client (such as Vault Explorer or
Productstream) accesses the SQL server directly, therefore my personal
opinion is that you need only one CAL for SQL server and that's the one for
ADMS.

Hope this helps,

Martin Gasevski
Software Engineer
Autodesk, Inc.

So if according to MS you need a cal for each workstation, you should
install a bunch of cal's even though only one will ever be used? How moral
are you feeling?