Which SQL Server 2005 Edition is required for web hosting solution?

Hi
I am in the proces of moving my client over onto a dedicated web server solution. We have developed an ASP.Net aplication which currently connects to a SQL Server 2000 standard edition database.

The database is mainly used just for data storage and receiving data updates via DTS packages from another SQL Server database hosted externally from elsewhere. An my ASP.Net application queries the data via stored procedures.

As part of the Dedicated solution I am looking to purchase their own copy of SQL Server (processor license) too.

Based on the information above, would SQL 2005 Workgroup edition sound appropriate rather than standard?... i'm thinking of the cost.

Is there anything I would need to consider regarding Workgroup edition within a hosting environment?

Many thanks

Rit

I see that Workgroup is a little more cost effective so I am tempted to go for that edition.
LVL 1
rito1Asked:
Who is Participating?
 
imran_fastCommented:
0
 
imran_fastCommented:
>>Is there anything I would need to consider regarding Workgroup edition within a hosting environment?

Sql workgroup dosent come with sql profiler and so if in future you want to trasce sql statements you cannot.
0
 
Racim BOUDJAKDJIDatabase Architect - Dba - Data ScientistCommented:
Standard or Enterprise (depending on concurrency level).  Forget about 64 bit edition.  If you want a free product use DB2 Express-C (unlimited db size)...+ they have a neat DOT NET plugin for visual studio integration...

Hope this helps...
0
 
nakul_vachhrajaniCommented:
I think you should go with Standard or Enterprise Edition depending upon your concurrency levels (as Racimo mentioned).
Also, in order to support your DTS packages, etc, you will then need to download the SQL Server Feature Pack (http://www.microsoft.com/downloads/details.aspx?FamilyID=50b97994-8453-4998-8226-fa42ec403d17&DisplayLang=en)
0
 
rito1Author Commented:
Thanks All.

nakul_vachhrajani, regarding the DTS packages, the data is imported into my servre from a DTS on another server btu no harm in installing the feature pack anyway i suppose.

Rit

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.