Positive aspects And Down sides To Making use of Mysql Vs. Ms Sql

Alternatively, with the Microsoft product, you're limited to a Sybase-derived engine through the two good and bad times.

When thinking about how MySQL integrates seamlessly using a number of programming languages as well as other web-based technologies, it certainly has got the advantage over MS SQL in the way of compatibility, as the SQL Server could work better with other Microsoft products. 

Licensing 

Contrary to popular belief, the MySQL system isnt always free. However, it is always more affordable. In regards to both products, licensing fees are based on a two-tiered scheme. With MS SQL, the simplest way to obtain a developers license is to find a license for the Microsoft Developer or Microsoft Visual Studio suite. Both supply you with a free SQL Server license for development use. If you need to use the product in the commercial environment, you should at least purchase the SQL Server Standard Edition  which could cost you over $1,000 for a couple of client connections. 

Because MySQL can be an open-source system under the GNU General Public License, developers are able to use it at no cost as long as the associated projects are also open-source. However, if you intend to sell your software like a proprietary product, you should purchase a commercial license, that amounted to about $400 for up to nine clients. Depending on the project and your funds, MySQL may have the advantage here. 

Technical Differences

MyISAM databases leave a smaller jasa web designer using little disk space, memory and CPU. Because of its stability, many internet powerhouses including Yahoo! use MySQL as his or her back-end database.

When it comes to performance, MS SQLs strength for being packed with more features than other systems is perhaps its biggest disadvantage. Although these types of features are designed for performance tuning, they have a tendency to sacrifice other essential elements. The charge here is complexity along with the hogging of resources with respect to storage and memory, which ends up in poorer performance. If you lack the knowledge and sufficient hardware to guide an SQL server, you'd be better off with another database management system. 

Security

These two database systems are just about deadlocked in regards to security. Both feature adequate security mechanisms by default, bearing you keep to the directions and keep the software program updated with security patches. Both operate over known IP ports which unfortunately attracts a wealth of intruders, a downside that may be attributed to both products. Thankfully that MySQL and MS SQL let you change ports in the event the default becomes too vulnerable. 

Recovery

So far as recovery goes, the SQL Server carries a definite advantage over MySQL, which has a tendency to fall a little short using its MyISAM configuration. A UPS strategy is mandatory with MyISAM since it assumes uninterrupted operation. If the power outage should take place, it could result in the corruption and loss in  data. With the SQL Server, data corruption is a lot more unlikely. The data travels through various checkpoints while passing from a keyboard to the harddrive and through the monitor.  As you can see,  systems have their own advantages and disadvantages.