Wednesday, March 21, 2012

MSDE or SQL-SERVER ?? help

Hello can someone help me out, i need to know if i buy the 5 User Cal license of MS-SQL server, does that mean that only 5 people on the network or through the web can access the database? Is that true?
How can i use the SQL Server in the following way:
2-4 users running on a local area network
10-15 concurrent users online
Database size will grow each year by 800-1000mb, i know the MSDE limit is 2Gig,
How can i get a solution to the above problem? what is my best bet to utilize SQL-Server? MSDE Or some other type of sql product?
MSDE has been shown to support far more than 10-15 users. It all depends on
how well the application is written and how your code manages the connection
and the server resource. SQL Express which is due out in 2005 ups the limit
to 4GB. However, with appropriate archiving, you can keep within the limits.
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
"Artmic" <Artmic@.discussions.microsoft.com> wrote in message
news:703D7809-DB32-4557-825D-0C7F1F689BEC@.microsoft.com...
> Hello can someone help me out, i need to know if i buy the 5 User Cal
license of MS-SQL server, does that mean that only 5 people on the network
or through the web can access the database? Is that true?
> How can i use the SQL Server in the following way:
> 2-4 users running on a local area network
> 10-15 concurrent users online
> Database size will grow each year by 800-1000mb, i know the MSDE limit is
2Gig,
> How can i get a solution to the above problem? what is my best bet to
utilize SQL-Server? MSDE Or some other type of sql product?
>
|||Ok thanks, i guess i will go ahead with the MSDE and switch to SQL Express when it is available... it is just not economic for a small site to buy a multi-thousand dollar processor license for Online volume that is laughable IMO.
"William (Bill) Vaughn" wrote:

> MSDE has been shown to support far more than 10-15 users. It all depends on
> how well the application is written and how your code manages the connection
> and the server resource. SQL Express which is due out in 2005 ups the limit
> to 4GB. However, with appropriate archiving, you can keep within the limits.
> --
> ____________________________________
> William (Bill) Vaughn
> Author, Mentor, Consultant
> Microsoft MVP
> www.betav.com
> Please reply only to the newsgroup so that others can benefit.
> This posting is provided "AS IS" with no warranties, and confers no rights.
> __________________________________
> "Artmic" <Artmic@.discussions.microsoft.com> wrote in message
> news:703D7809-DB32-4557-825D-0C7F1F689BEC@.microsoft.com...
> license of MS-SQL server, does that mean that only 5 people on the network
> or through the web can access the database? Is that true?
> 2Gig,
> utilize SQL-Server? MSDE Or some other type of sql product?
>
>

No comments:

Post a Comment