Interprise Suite Community / Interprise Suite Community Forums / Hardware / SQL2005 Workgroup to SQL2005 Express / Latest Posts

RE: SQL2005 Workgroup to SQL2005 Express

Brucehall123 — Tue, 08 Nov 2011 05:13:50 GMT

which OS is being used by your clients in their computer is it XP or Win7 or some other one.

RE: SQL2005 Workgroup to SQL2005 Express

jamesdockel — Sun, 09 Oct 2011 22:45:36 GMT

Which edition of SQL Server is being used in your project?

RE: SQL2005 Workgroup to SQL2005 Express

BJ Dimes — Fri, 29 May 2009 09:46:39 GMT

Steve,

I dont see a problem with it because we have customers running on SQL Express now (started on SQL Express though). I wouldnt recommend SQL Express because it can only handle so much load. If you website starts creating alot of traffic, SQL Express might not keep up with it. Also there are features you can use with SQL2005 that can help optimize the performance. Also if I recall, SQL Express will only go up to 2 Gig worth of data. So if you database gets big, it will not handle it.

My opinion, I wouldnt run IS on SQL Express; I would only run IS on SQL2005.

Hope that helps.

SQL2005 Workgroup to SQL2005 Express

Steve — Fri, 29 May 2009 05:29:37 GMT

I thought this question might have a broader appeal than just my situation:
I am installing IS on my SBS2003 R2 Server using the included SQL Server Workgroup edition. This will allow me to keep it locally in house while I set it up and get my employees comfortable with it. However, I do see a future for a dedicated hosted server and the ecommerce. I really doubt my load will be very much, so the question: Is it possible to "downgrade" the database to the free SQL express at that point? Thanks!