SQL Server

brettb · 04-16-2012, 04:38 AM

Hi all,

I'm building a membership site and I'm a little unsure about which database to use. I believe the site could be very popular. However, earnings per member will be low. For that reason I need an economical hosting solution, at least until I can calculate true income/expenditure and look into dedicated hosting.

I've started building the site using SQL Server. While I prefer to develop using this database, I've suddenly realised that SQL Server hosting is seriously expensive

.

Example: Godaddy's shared hosting gives you 1Gb mySQL databases but only 200Mb SQL Server databases

. 200Mb isn't a lot of space! I think my site will need around 750Mb in a year or two.

So, should I stick with SQL or cut my losses and switch to mySQL?

The frontend is ASP.NET/C# by the way.

P.S. I don't even want to get into talk about splitting my data between countless 200Mb SQL Server databases!

msu · 04-16-2012, 11:42 AM

I'm not exactly an expert on databases but I have developed a number sites using PHP and MySQL. I'd switch to MySQL. It should be able to handle everything you need it to, it's cheaper and you don't want the nightmare of having to redo everything two months in to the project.

TG12 · 04-16-2012, 11:49 AM

Yeah SQL Server is way too expensive for small sites. It depends how you write your query's and what you store in your tables for 200MB but No its not a great deal.

Earnie Boyd · 04-16-2012, 03:12 PM

You should switch. MySQL and PostgresDB are both Open Source. Just dump the DB to a Sql script that can then be used by MySQL to import the data.

Darknite7 · 04-17-2012, 02:32 PM

Time to dispel some myths!

* You can use SQL Express versions, they have some features removed that you simply will not need for small web sites.

* Microsoft Bizspark (for start-ups) Lots of free licences:

http (//) www (.) microsoft.com (/) bizspark

* 750mb? in one year? how are designing your schema? not nvarchars I hope

EDIT:

If you are worried about space, just rent a VPS, even a lowly one usually will have 40GB hdd space, you can expand this on the fly as your traffic and site grows.

Some have Install anything policies. I did this for a while, worked just fine.

Earnie Boyd · 04-18-2012, 08:26 AM

My host provides me 1.8 Tera Byte for "unlimited" disk space. Check the linked page in the signature for a link to the host I use.

webcosmo · 04-18-2012, 12:17 PM

expense is a big issue with windows hosting no doubt.

do the math for cost of conversion compared to extra cost for sql.

IMBotz · 04-18-2012, 12:31 PM

Yep,

Last time I checked SQL Express supported up to a 4GB database.

Quote:

Originally Posted by Darknite7

Time to dispel some myths!

* You can use SQL Express versions, they have some features removed that you simply will not need for small web sites.

* Microsoft Bizspark (for start-ups) Lots of free licences:

http (//) www (.) microsoft.com (/) bizspark

* 750mb? in one year? how are designing your schema? not nvarchars I hope

EDIT:

If you are worried about space, just rent a VPS, even a lowly one usually will have 40GB hdd space, you can expand this on the fly as your traffic and site grows.

Some have Install anything policies. I did this for a while, worked just fine.

JayWiz · 04-21-2012, 04:21 AM

Your frontend is ASP.NET/C# then obviously it's best using SQL Server. There are few limitations when using mySQL or PostgreSQL compared when using Sql server. I think you will find many problems when you switch from sql server to mysql directly, you will need to modify your code and in the end takes more time. You better find other web hosting that supports sql server cheaply, you can compare and find this on web host forum such as Web Hosting Talk - The largest, most influential web hosting community on the Internet

04-16-2012, 04:38 AM	#1
brettb Freelance C#/SQL guy War Room Member Join Date: Jul 2010 Location: London, UK Posts: 843 Thanks: 259 Thanked 87 Times in 80 Posts Social Networking	SQL Server – Too Expensive for Small Sites? Hi all, I'm building a membership site and I'm a little unsure about which database to use. I believe the site could be very popular. However, earnings per member will be low. For that reason I need an economical hosting solution, at least until I can calculate true income/expenditure and look into dedicated hosting. I've started building the site using SQL Server. While I prefer to develop using this database, I've suddenly realised that SQL Server hosting is seriously expensive . Example: Godaddy's shared hosting gives you 1Gb mySQL databases but only 200Mb SQL Server databases . 200Mb isn't a lot of space! I think my site will need around 750Mb in a year or two. So, should I stick with SQL or cut my losses and switch to mySQL? The frontend is ASP.NET/C# by the way. P.S. I don't even want to get into talk about splitting my data between countless 200Mb SQL Server databases!

04-16-2012, 11:42 AM	#2
msu HyperActive Warrior Join Date: Nov 2011 Location: Live from the hammock Posts: 364 Thanks: 9 Thanked 37 Times in 35 Posts Social Networking	Re: SQL Server – Too Expensive for Small Sites? I'm not exactly an expert on databases but I have developed a number sites using PHP and MySQL. I'd switch to MySQL. It should be able to handle everything you need it to, it's cheaper and you don't want the nightmare of having to redo everything two months in to the project.
	New to WordPress? Save time with my beginner's guide: WordPress Step-by-Step (for Kindle & Kindle Apps) I'm a top-notch WordPress developer: hire me

04-16-2012, 11:49 AM	#3
TG12 HyperActive Warrior War Room Member Join Date: Apr 2011 Posts: 256 Thanks: 38 Thanked 21 Times in 21 Posts	Re: SQL Server – Too Expensive for Small Sites? Yeah SQL Server is way too expensive for small sites. It depends how you write your query's and what you store in your tables for 200MB but No its not a great deal.
	Vaoser Link Ninja Software DHV Delivery Systems FAILING at online dating???

04-16-2012, 03:12 PM	#4
Earnie Boyd HyperActive Warrior War Room Member Join Date: Feb 2012 Posts: 292 Thanks: 14 Thanked 47 Times in 47 Posts	Re: SQL Server – Too Expensive for Small Sites? You should switch. MySQL and PostgresDB are both Open Source. Just dump the DB to a Sql script that can then be used by MySQL to import the data.
	Earnie Boyd

04-17-2012, 02:32 PM	#5
Darknite7 Warrior Member Join Date: Mar 2012 Location: London Posts: 16 Thanks: 0 Thanked 1 Time in 1 Post Social Networking	Re: SQL Server – Too Expensive for Small Sites? Time to dispel some myths! * You can use SQL Express versions, they have some features removed that you simply will not need for small web sites. * Microsoft Bizspark (for start-ups) Lots of free licences: http (//) www (.) microsoft.com (/) bizspark * 750mb? in one year? how are designing your schema? not nvarchars I hope EDIT: If you are worried about space, just rent a VPS, even a lowly one usually will have 40GB hdd space, you can expand this on the fly as your traffic and site grows. Some have Install anything policies. I did this for a while, worked just fine.
	Graduate IT Career "Learn, Teach Grow"

04-18-2012, 08:26 AM	#6
Earnie Boyd HyperActive Warrior War Room Member Join Date: Feb 2012 Posts: 292 Thanks: 14 Thanked 47 Times in 47 Posts	Re: SQL Server – Too Expensive for Small Sites? My host provides me 1.8 Tera Byte for "unlimited" disk space. Check the linked page in the signature for a link to the host I use.
	Earnie Boyd

04-18-2012, 12:17 PM	#7
webcosmo Webmaster Join Date: Sep 2008 Location: Boston, MA Posts: 376 Thanks: 3 Thanked 37 Times in 35 Posts Social Networking	Re: SQL Server – Too Expensive for Small Sites? expense is a big issue with windows hosting no doubt. do the math for cost of conversion compared to extra cost for sql.
	JOIN US ___ FAST GROWING WEBMSTER FORUM ___ WEBMASTER TOOLS ___ JOIN US Free Classified Ads & BUSINESS SOCIAL NETWORK \| Health News

04-21-2012, 04:21 AM	#9
JayWiz Software Entrepreneur War Room Member Join Date: Sep 2009 Posts: 142 Thanks: 26 Thanked 22 Times in 20 Posts Social Networking	Re: SQL Server – Too Expensive for Small Sites? Your frontend is ASP.NET/C# then obviously it's best using SQL Server. There are few limitations when using mySQL or PostgreSQL compared when using Sql server. I think you will find many problems when you switch from sql server to mysql directly, you will need to modify your code and in the end takes more time. You better find other web hosting that supports sql server cheaply, you can compare and find this on web host forum such as Web Hosting Talk - The largest, most influential web hosting community on the Internet