mysql vs mssql

I have been running MySQL for my in-house applications for a couple of years now.  Today I was asked to move them to a MSSQL server to consolidate all our databases to a few servers running the same database software.  I was looking for feedback both pro MSSQL as well as pro MySQL to either help me explain why my apps should stay on MySQL or to help me feel better moving to a database I know nothing about.  Thanks in advance.
LVL 5
rkeith2412Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

gtworekCommented:
Did you see http://www.mssqlcity.com/Articles/Compare/sql_server_vs_mysql.htm and http://www.microsoft.com/sqlserver/2008/en/us/compare-mysql.aspx ?

The first one is about old versions but language and platform characteristics changes really slowly.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Lee SavidgeCommented:
Personally I'm a MS SQL person. However, if you were asked I would say no. If it ain't broke, don't fix it. If you were "asked", aka "told", then it's a decision that the person who "asked" you may regret.

Lee
0
rkeith2412Author Commented:
I took my own time and money to become a Certified MySQL DBA.  Would it be asking too much for the people that are forcing me to change pay for me to be trained and get certified on MSSQL?
0
10 Tips to Protect Your Business from Ransomware

Did you know that ransomware is the most widespread, destructive malware in the world today? It accounts for 39% of all security breaches, with ransomware gangsters projected to make $11.5B in profits from online extortion by 2019.

Lee SavidgeCommented:
No. If they're changing the core technologies then they should expect to train those up in it that were trained in the soon-to-be-replaced technology.

Lee
0
Ioannis AnifantakisProgramming InstructorCommented:
Stick to MySQL.

1) You are certified MySQL DBA, which is something important.
2) Open Source
3) Faster
4) More Secure
5) Sun Microsystems
0
Ioannis AnifantakisProgramming InstructorCommented:
Sorry to all MS-SQL people here, no offence by any means, I just big fan of MySQL :)

Also have to agree that you have something that's currently working and programming rule number 1 is "don't mess with whats already working fine"
0
gtworekCommented:
I'm quite sure the "let's switch" decision has some background... maybe it makes sense to do some research about such background? It may give you useful hints...
0
rkeith2412Author Commented:
I'm pretty sure the let's switch decision is based on the fact the he knows Windows and MySQL is running in Linux.
0
gtworekCommented:
Maybe MySQL on Windows makes sense? ;)))
Just joking. I love Windows+MSSQL but if it working - do not try to break it...
0
tikusbalapCommented:
Well, don't matter what you will be using. Stick to ANSI-SQL, learn little about how to backup and restore, and how database is using index. That's enough.
0
rkeith2412Author Commented:
Thank you all for the valuable feedback.  This will really help me stand my ground.  We will have to see how it goes, thanks again.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
MySQL Server

From novice to tech pro — start learning today.