Solved

Migrating to MySQL

Posted on 2011-03-20
6
428 Views
Last Modified: 2012-05-11
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
Comment
Question by:sepknow
  • 3
  • 2
6 Comments
 
LVL 39

Expert Comment

by:Aaron Tomosky
ID: 35175689
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
 

Author Comment

by:sepknow
ID: 35177448
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
 
LVL 39

Expert Comment

by:Aaron Tomosky
ID: 35177553
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
Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

 
LVL 8

Assisted Solution

by:wolfgang_93
wolfgang_93 earned 250 total points
ID: 35210763
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
 
LVL 39

Accepted Solution

by:
Aaron Tomosky earned 250 total points
ID: 35210864
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
 

Author Closing Comment

by:sepknow
ID: 35224701
Thanks.
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SubQuery link 4 43
Re-appearing SQL Server Agent jobs 7 42
how would you excute a sproc on another database on the fly 9 28
mysql qry 1 18
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

685 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question