[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 436
  • Last Modified:

Migrating to MySQL

Is MySQL product really free to use even for commercial?
The free MySQL is a full feature product?

What is the advantage of migrating from MSSQL 2005/8 to MySQL
when all my servers are running Microsoft OS and all my developement
work is using VS 2005/2008?
0
sepknow
Asked:
sepknow
  • 3
  • 2
2 Solutions
 
Aaron TomoskyTechnology ConsultantCommented:
Your developers will get mad. If your concerned about cost use express editions. You can't cluster or replicate but aside from that it's fully functional.
0
 
sepknowAuthor Commented:
But Express has database size limitation (2005-4GB, 2008 10GB?).
MySQL is free and the database size is much more than what Express can offer.
0
 
Aaron TomoskyTechnology ConsultantCommented:
Talk to your programmers. If they are using linq or entity framework they will have prolems. My biggest issue with mysql is the lack of decent support for stored pocedures. Many .net mssql guys live off stored procs.
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
wolfgang_93Commented:
aarontomosky, what do you mean you can't cluster or replicate with MySQL? You can do
replication using the MASTER/SLAVE setup readily available in MySQL Community Edition
(i.e. the Open Source version available free to anyone) and we do it quite readily. As for clustering,
there is a free Open Source version of MySQL cluster product.

If you are converting an application that includes SQL procedures, it is going to be an issue
no matter which different DBMS you convert to. Reason: each DBMS has its own flavour of
commands and internals which means a major rewrite of each procedure -- making conversion
a royal pain.
0
 
Aaron TomoskyTechnology ConsultantCommented:
I guess I wasn't clear. I ment that with Microsoft SQL express you can't cluster or replicate. Only the full versions of MICROSOFT SQL can do that.
0
 
sepknowAuthor Commented:
Thanks.
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now