Access MS SQL Server Through Internet
I have a server with Windows 2003 Server installed and inside the server, I installed several applications and one of them is MS SQL Server. I'm using MS SQL Server for a custom desktop application that I developed and for some time everything works great with no problem whatsoever.
Lately, I'm considering changing the database from MS SQL Server to MySQL so, I can access the database from around the world. Unfortunately, it means I need to adjust some things to make the desktop application work fine using MySQL like when it used MS SQL Server for the database. Using the same desktop application I can access and manipulate databases inside MySQL without having to develop new applications for it.
Several days ago, a friend of mine told me that I don't even have to change the database to MySQL because, MS SQL Server can be accessed from around the world just like MySQL. In fact, I can develop different applications for several branches and they can connect to databases installed in the Head Office. Unfortunately he didn't elaborate in details on how to do that.
Can anyone advise me on how to do that, so I won't have to waste many time migrating from MS SQL Server to MySQL?