Take the 2-minute tour ×
Webmasters Stack Exchange is a question and answer site for pro webmasters. It's 100% free, no registration required.

I'm using GoDdady for site hosting, and I'm currently using MySQL, because there are less limits on size,etc. My question is what is the difference between using a hosted GoDaddy Db such as MySQL vs. creating a SQL Server database in the the App_Data folder? My guess is security? Would it be a bad idea to use a SQL ServerDB that's located in the App_Data folder?

Additional Well I am able to create a .mdf (SQL Server DB file) in the App_Data folder, but I'm really unsure if should use that or not, If I did use it it would simplify using some of the Microsoft tools. Like I said my guess is that it would be less secure, but I don't really know. I know I have a 10gb, file system limit, so I'm assuming my db would have to share that space.

share|improve this question

migrated from stackoverflow.com Feb 7 '11 at 19:32

This question came from our site for professional and enthusiast programmers.

    
Have you talked to a GoDaddy customer service rep? That seems like the best place to ask this question. –  Kenzo Dec 29 '12 at 12:25
add comment

2 Answers 2

Using the MSSQL db file in your App_Data folder would require the hosting server to have, at the minimum, SQL Express installed. I don't know GoDaddy's billing model, but my guess is that an instance of SQL probably has a cost.

Therefore, the second option in your question is not possible.

share|improve this answer
    
Well I am able to create a .mdf (MSSQL DB file) in the App_Data folder, but im really unsure if should use that or not, If I did use it it would simplify using some of the Microsoft tools. –  Nate Gates Feb 7 '11 at 19:25
    
Not sure if this is a factor, but does Godaddy back up their MySQL info for you? Would your .mdf file get backed up similarly or would you have to maintain it? That would be one of my concerns if it's an issue. –  digit1001 May 11 '11 at 20:52
add comment

Not sure how GoDaddy has their servers set up, but many/most web hosts run dedicated MySQL servers, offloading the DB workload from the web server. As for security, SQL Server 2008 at least supports cell-level encryption like Server 2005 as well as full database-level encryption. Windows also supports file-level encryption via EFS and BitLocker. Given these factors, it's not necessarily less secure than having a MySQL DB, which, on its own, doesn't support file-level or database-level encryption.

That said, if their MySQL server is secure, then the lack of database-level encryption shouldn't be a problem, and it could still be more secure than using an SQL Server DB on the web server without TDE encryption of the .mdf file.

Frankly, I'd make the choice based on which RDBMS you prefer to work with. If you're a Windows shop and you already work with MS tools and are using Windows IIS web hosting, then SQL Server probably makes the most sense. And if you're a *nix shop using PHP/Ruby/Python and Apache web hosting, then what on earth are you doing using a Windows web server?

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.