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?
 
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
 
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
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
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 AnifantakisSoftware EngineerCommented:
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 AnifantakisSoftware EngineerCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.