|
|
Posted by Erland Sommarskog on 10/02/59 11:55
Jim Devenish (internet.shopping@foobox.com) writes:
> We are trying to evaluate the use of SQL Server as a back-end and
> although the system works with a very small number of users we are
> encountering difficulties when the number rises to about 8-10. If we
> cannot overcome these we will revert to Access back-end.
Certainly one woujld expect SQL Server be a lot better on handling many
users than Access. But with poor indexing etc, you can make things to
really slow on SQL Server as well. And if you just migrated the Access
database with the up-sizing wizard, you most likely have a non-optimal
database.
> If we are successful, the licenses will be acquired for Enterprise
> edition. There is no intention of violating licences. We do however
> wish to test the system fully before advancing.
When I think of it, moving from Access to Enterprise for a back-end is
quite a step, not the leasr financially. Are there any special feature
in Enterprise you are yearning for? Else, Standard or even Workgroup
Edition may work just as well.
For evaluation purposes, you should probably use Evaluation Edition, but
I'm not the license police. :-)
By the way, your post says SQL 200, I suppose that means SQL 2000. Why
not SQL 2005?
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|