I have all of the three choices available to me at a shared host, which runs IIS 7.
While I've worked in MS SQL, I'm most comfortable in MySQL. However, I'm open to MS SQL if that's the best choice by way of compatibility with updates, modules and performance.
So, for a general brochure-ware type of CMS (lots of content, limited application-like functionality) which is the one I would do best to choose?
From my experience, both MySQL and MSSQL 2008 should perform admirably for a standalone umbraco installation.
But! I have seen more than one extension that requires MSSQL. Also, if you want to tap the power of complex server side database objects, then 2008 is going to be hard to beat. TSQL and extended stored procedures (for example) are amazing tools and great performers.
If there is no cost difference to you, I'd side with SQL 2008.
Hah! MSSQL 5 is an figment of my imagination and is NOT a choice I have. Oops! Wish I could change this title.
One thing I appreciate about MySQL is phpmyadmin; a nice lightweight way to access my data. Does MS SQL have something similar without needing a desktop binary?
There are no free or first-party thin clients for SQL Server that I know of. There are some third party ones at a premium, but it's pretty clear that's something MySQL has over the competition. If you don't have any other remote access to your hosting environment (like Remote Desktop), then that's pretty important!
MySQL vs MSSQL 5 vs MSSQL 2008
I have all of the three choices available to me at a shared host, which runs IIS 7.
While I've worked in MS SQL, I'm most comfortable in MySQL. However, I'm open to MS SQL if that's the best choice by way of compatibility with updates, modules and performance.
So, for a general brochure-ware type of CMS (lots of content, limited application-like functionality) which is the one I would do best to choose?
i have used both without any issues
From my experience, both MySQL and MSSQL 2008 should perform admirably for a standalone umbraco installation.
But! I have seen more than one extension that requires MSSQL. Also, if you want to tap the power of complex server side database objects, then 2008 is going to be hard to beat. TSQL and extended stored procedures (for example) are amazing tools and great performers.
If there is no cost difference to you, I'd side with SQL 2008.
What's MSSQL 5?
Hah! MSSQL 5 is an figment of my imagination and is NOT a choice I have. Oops! Wish I could change this title.
One thing I appreciate about MySQL is phpmyadmin; a nice lightweight way to access my data. Does MS SQL have something similar without needing a desktop binary?
There are no free or first-party thin clients for SQL Server that I know of. There are some third party ones at a premium, but it's pretty clear that's something MySQL has over the competition. If you don't have any other remote access to your hosting environment (like Remote Desktop), then that's pretty important!
is working on a reply...