Page 1 of 1
SQL Server versions
Posted: Wed Jun 16, 2010 9:32 pm
by markc
What is the best version of SQL Server to use?
We are looking to combine multi sites in the same Database.
What are the pros and cons?
Thanks
Mark
Re: SQL Server versions
Posted: Thu Jun 17, 2010 10:40 am
by mikek
Hi Mark,
The best MSSQL version from our experience is SQL Server 2008 Web Edition. The Web Edition has all features required for running AbleComerce sites and has lower license cost comparing to Standard
and Enterprise Editions. If you are running low traffic sites SQL Server 2008 Express edition will do the work and you can always upgrade to Web Edition if you need more DB Server Memory later. The
SQL Server 2008 Express edition now supports databases with up to 10GB DB Size comparing to 2005 Express Edition which supports up to 3GB only.