Backend Database Mysql Or Msql

heloo everyone we going to purchase a new retail management system for our retail business. we have chain store , the software which we are going to purchase is coded in vb.net (.net 2.0) and it uses mysql database for datbase operations. could anyone suggest me that how much mysql will be reliable over msql in next 5-7 years. we should go for mysql or not

 

Both MySQL and MSSQL are top-end databases that will work fine. Reliability usually is not a factor. MySQL runs mostly on Unix systems, while MSSQL runs on Windows servers. They also have different extensions and 3rd party solutions available for them. Your choice should be decided on which platform you want to use, not reliability.

 

we will use Linux as our back-end server, and client will use windows systems. where MySQL stands for security perspective.

 

Most Linux servers won't run .net programs, since .net is a Microsoft thing. (Some will have the capability, but I wouldn't count on it.)

Unless you mean that the client is running a vb.net program and the server is running something else (PHP?). In which case, you probably have no choice. Unless you own the server, of course, in which case the choice is paying for MSSQL or using MySQL for free.

As far as security is concerned, that's up to the programmer writing the server-side code, it has almost nothing to do with the database, unless someone gains physical access to the server. In which case your security is totally compromised, and you need better locks on your building.

 

MySQL has become more of the standard database software due to it's wide use and the fact it's free. It will also run on pretty much every platform.

Unless you have specialist reasons to MSQL, use MySQL.

 

MySQL is very secure. If you are going to run Linux then I would go with MySQL, if you are going to use windows as your backend server I would still run MySQL

 

Should go for MySQL. That's what we're using in most of our 'database' related projects.

 

I think you should go for MySQL as it has numerous great features that you won't find in SQL. The best part about MySQL is that it is open source and supported on atleast two dozen platforms.

 

How large your database and what capacity are you need?

 

Personally I would suggest Mysql for smooth running on Linux

 

According to me you should go for MySql because it is more reliable.

 

MySql is open-source and from what I understand does not have any restrictions. If your system is high traffic you might have to look into MSSQL Standard or Enterprise, it will cost you $$$$$

I come from a .net background so i usually go with mssql

cheers

 

Your understanding is flawed. Oracle now owns MySQL and if its good enough for a company that is on the Forbes Most Powerful Brands list then it must be legit.

Open source and free [true] - You get what you pay for [false]
Closed source and expensive [true] - You get what you pay for [false]

 

thnx guys got the right answer. MySQL will be good for us

 

Also, consider MariaDB. It is a drop-in replacement for MySQL (i.e just replace the binaries on an preexisting installation works), and it is faster than MySQL.

 

Looks a little too new for me to put into production.

 

It has been here for a while (after oracle bought sun), and wikipedia uses it (with some nice performance boosts).

 

It's been around for a few years, but the 1st stable code only came out early this year.

True that wikipedia and some other predominate organizations use it, but they probably have database engineers or at least people that know how to address or mitigate vulnerabilities in databases. Since databases aren’t my speciality, I wouldn't feel comfortable using it in my production environment or advising someone else to use it. That's all I'm saying.

I will however dump it into the lab to try it out.