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
SQL Server versions
Re: SQL Server versions
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.
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.
Mike Kolev