Benefits/disadvantages of hosting SQL server on site versus MySQL in cloud?

1110 pts.
Tags:
Cloud Computing
Cloud Services
MySQL
SQL
SQL Server
SQL Server administration
What are the benefits or disadvantages of hosting a SQL server on site or using a MYSQL server in the cloud? The MYSQL box is much cheaper is there anything I will not be able to do with my web app using MYSQL?

Answer Wiki

Thanks. We'll let you know when a new response is added.

First you are talking about two different database platforms Microsoft SQL Server and MySQL. There are a lot of features that are different between the two. If you are thinking about moving a database into the cloud you should look at SQL Azure which is a Microsoft SQL Server database hosted in the cloud by Microsoft.

Switching from MS SQL to MySQL you loose things like Service Broker, full text indexing, etc that MySQL simply doesn’t support.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following