Solved

SQL Server vs MySQL

Posted on 2014-02-12
6
28 Views
Last Modified: 2016-05-29
We are using SQL Server, currently version 2008, in our facility in Idaho, and we are having performance problems in our facility overseas, with Access databases and multiple users. They have a MySQL system on their premises. We are thinking of deploying a SQL Server solution over there. Are MySQL and SQL Server similar enough to run the same solution on both premises, and would MySQL support a multi user environment with good performance.

SQL Server runs wonderful in our Idaho facility and I know it, I don't know much about MySQL other than what I have done with websites.
0
Comment
Question by:ACDATA
6 Comments
 
LVL 54

Assisted Solution

by:Julian Hansen
Julian Hansen earned 83 total points
ID: 39853971
If you have MS SQL why would you want to go with MySQL?

Just a question - if that is what you know then go with that.

MySQL will handle multiple users just fine - up to a point - but I doubt you will test the limit.

However if you are already running MS SQL then it makes sense to stay on that platform otherwise you need double the resources to support your environment.
0
 
LVL 18

Assisted Solution

by:Jerry Miller
Jerry Miller earned 83 total points
ID: 39854185
Access is not a good solution for multiple users as you have found out. If you already have MySQL in the overseas facility with resources to support it, I would move the Access tables to that platform.

That being said, if you have future plans to migrate the MySQL to MS SQL I would move the Access to MS SQL and migrate the other databases as you have time. There is always a learning curve running multiple platforms, but if you have the resources that know MySQL you can learn it too.
0
 
LVL 43

Assisted Solution

by:Chris Stanyon
Chris Stanyon earned 83 total points
ID: 39855753
As for whether they're similar enough to run your application - maybe!

You need to make sure you app language has drivers to support mysql.

If you're just running standard SQL stuff then it probably will be, but obviously if your app relies on native Microsoft functionality, then it won't run with mySQL
0
 
LVL 25

Accepted Solution

by:
kode99 earned 251 total points
ID: 39876237
Here's a pretty good outline of the differences between the most common SQL servers,

http://troels.arvin.dk/db/rdbms/

If you are familiar with your SQL applications syntax it may help to give you a idea of where problems may be or the scope of change it would be.

I agree with the others that going to one common SQL platform makes alot of sense but it may also depend on how invested the other site is with MySQL.

Even if things more or less do translate you could be in for a fair amount of testing to verify that your queries/data are good on the other platform.

At the minimum it may be a good idea to keep in mind the differences so the Access stuff you need done now could easily work on either DB down the road.  Probably a good exercise to get a real good grasp of what all your current stuff would involve.
0

Featured Post

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

Suggested Solutions

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.
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

772 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