using MySQL on a web server to pass data to and from a SQL server

[PPettit]

My company is in the process of developing an online app that will interface with one of our in-house databases (SQL Server 2005). The boss wants us to try running MySQL 5.5.1.3 on the web server and have it somehow connect to the server running our in-house database. His thinking is that this setup should be more secure since the SQL server won't be exposed directly to the Internet.

Is this a good way to go about protecting our in-house database? Is there a better alternative?

 

[sleipnir214]

A correctly-configured firewall will keep a database server from being directly exposed to the internet. But without knowing what kind of data we're talking about and what you intend to do with it, it's difficult to do more than theorize.

I think the answer to your question is going to lie mostly in the definition of the phrase "somehow connect".



Want to ask the best questions? Read Eric S. Raymond's essay "How To Ask Questions The Smart Way". TANSTAAFL!