mySQL and not SQL2008?

Question

mySQL and not SQL2008?

Casper101

Hall of Fame

Points: 3903
More actions
March 15, 2012 at 3:03 pm

#270114

We have 4 production servers still running sql 2000. I finally convinced business that it is time to upgrade to 2008. But after reviewing the licensing fees they are now convinced that mysql is the way to go. I do NOT agree with them.
Apart from the obvious advatages of BI and such, what in your opinions are the greatest disadvantages of doing this?
I need some ammunition to take to them and convince them sql 2008 is the way forward.

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply

Possinator Hall of Fame Points: 3422 More actions · Answer 1

This quote:

..there are features in SQL Server MySQL has no complement for. Security is one particular area where MySQL trails Microsoft – unlike SQL Server, MySQL has no concept of roles or external authentication, and its data auditing abilities are quite weak compared to Microsoft.

Is from a comparison of SQL vs mySQL by mySQL

http://dev.mysql.com/tech-resources/articles/move_from_microsoft_SQL_Server.html">

http://dev.mysql.com/tech-resources/articles/move_from_microsoft_SQL_Server.html

Microsoft has their own comparison here:

http://www.microsoft.com/sqlserver/en/us/product-info/competitor-compare.aspx">

http://www.microsoft.com/sqlserver/en/us/product-info/competitor-compare.aspx

I don't know enough to have an opinion myself, but your question interested me. Perhaps compare the estimated development time and tool cost for conversion v. server license costs?

Is perhaps SQL Express an option?

[font="Courier New"]Looking for a Deadlock Victim Support Group..[/font]

CapnHector SSCoach Points: 16143 More actions · Answer 2

you say you have 4 production servers on 2000. does this mean you have other servers on SQL 05 or later? The next question is how much will you really save in the licensing. take into consideration the time to install and test MySQL, rewrite any stored procedures, triggers or UDF's that are not compatible. The increased short term development time as you learn MySQL (i went to Britain and wow there are differences in English). A move to MySQL may make sense but really dig into the costs because there lots of ways to be penny smart that are dollar stupid.

For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 3

Casper101 (3/15/2012)
We have 4 production servers still running sql 2000. I finally convinced business that it is time to upgrade to 2008. But after reviewing the licensing fees they are now convinced that mysql is the way to go. I do NOT agree with them.
Apart from the obvious advatages of BI and such, what in your opinions are the greatest disadvantages of doing this?
I need some ammunition to take to them and convince them sql 2008 is the way forward.

If the licensing fees are the only reason to migrate, that's quite short-sighted of them.

BI comes without any licensing fee.

But, I guess if secury and high availability are not important and ACID is something to laugh about, mySQL makes a good choice 🙂

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

spaghettidba SSC Guru Points: 105732 More actions · Answer 4

MySQL has no native physical backup tool to date.

That alone should keep you away from that crap.

On another note, Oracle bought the product just to kill it. If you don't want to go with a walking dead, stay away from it.

-- Gianluca Sartori

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 5

In addition to the costs of re-developing any application (and believe be, unless you're doing nothing more than trivial queries that is a huge amount of work), they also need to cost in the training for developers and DBAs to be able to properly administer and develop on the product.

If they change, there will be a huge upfront cost (redevelopment, training) and maybe savings over time from the licensing (though you might want to also consider the cost of technical support), it usually takes years to never to recoup the costs of that kind of migration.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Lowell SSC Guru Points: 323518 More actions · Answer 6

it looks to me like the cost of SQL Server 2008 starts at around $3,000 dollars...well maybe 6K for a dual proc multi core, 12k for a Quad Proc multi core , etc.

http://www.google.com/search?sourceid=navclient&ie=UTF-8&rlz=1T4GZAG_enUS450US450&q=cost+of+sql+server+standard+license

As everyone has alluded to, the payroll spent for retraining and redevelopment would probably outpace the licensing costs.

Also, wouldn't you upgrade your servers one at a time, to space out the costs over time?

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 7

Gianluca Sartori (3/16/2012)
On another note, Oracle bought the product just to kill it. If you don't want to go with a walking dead, stay away from it.

How's the relation between Oracle and MySQL now?

Is MySQL still open source? (How does a company actually "own" an open source product?)

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

spaghettidba SSC Guru Points: 105732 More actions · Answer 8

Oracle owns MySQL, but there's a community edition of the product that can be downloaded and used at no charge.

Oracle offers Standard/Enterprise editions and maintains additional tools/features on those versions.

-- Gianluca Sartori

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 9

Gianluca Sartori (3/16/2012)
Oracle owns MySQL, but there's a community edition of the product that can be downloaded and used at no charge.
Oracle offers Standard/Enterprise editions and maintains additional tools/features on those versions.

Ahahahahaha, an enterprise version of MySQL. 😀

Oh wait, you were serious?

:hehe:

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

CapnHector SSCoach Points: 16143 More actions · Answer 10

Koen Verbeeck (3/16/2012)
Gianluca Sartori (3/16/2012)
Oracle owns MySQL, but there's a community edition of the product that can be downloaded and used at no charge.
Oracle offers Standard/Enterprise editions and maintains additional tools/features on those versions.
Ahahahahaha, an enterprise version of MySQL. 😀
Oh wait, you were serious?
:hehe:

you could also mention to your boss you could really save money if you went with linux, a "Free" operating system. I say "Free" because in the enterprise arena you have migration costs as Gail pointed out.

For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]