Webmaster Forum

Go Back   Webmaster Forum > Web Development > Coding Forum

Coding Forum Problems with your code? Discuss coding issues, including JavaScript, PHP & MySQL, HTML & CSS, Flash & ActionScript, and more.


Reply
 
Thread Tools Display Modes
Share |
  #1  
Old 11-25-2014, 12:21 PM
pintukennady31 pintukennady31 is offline
Contributing Member
 
Join Date: 11-24-14
Posts: 99
iTrader: 0 / 0%
MYSQl ,SQL SERVER

difference between my sql and sql server
 
Reply With Quote

Advertisement

Advertisement

  #2  
Old 11-26-2014, 01:51 AM
georgeweballey13's Avatar
georgeweballey13 georgeweballey13 is offline
Contributing Member
 
Join Date: 09-26-14
Location: athens,greece
Posts: 162
iTrader: 0 / 0%
One major thing is this:
Mysql is Free! (open source)
SQL is not free. I think is the same with MS SQL (microsoft)
 
Reply With Quote
  #3  
Old 11-26-2014, 11:32 PM
HTMLBasicTutor's Avatar
HTMLBasicTutor HTMLBasicTutor is offline
Administrator
 
Join Date: 10-29-07
Location: Canada
Posts: 26,707
iTrader: 5 / 100%
Here is a table explaining the differences: What is the difference between MySQL and SQL Server?

Quote:
MySQL is (as of March 2014) the world's second most widely used open-source relational database management system (RDBMS).
MySQL - Wikipedia

SQL server is by Microsoft
 
Reply With Quote
  #4  
Old 11-28-2014, 06:55 AM
ServStrongcom's Avatar
ServStrongcom ServStrongcom is offline
Contributing Member
 
Join Date: 11-11-14
Posts: 62
iTrader: 0 / 0%
They are two DB engine, with almost same functionality,
MySQL is cross platform but MSSQL is not,
MySQL is free and MSSQL is commercial software and have a free version
 
Reply With Quote
  #5  
Old 12-01-2014, 06:59 PM
billzo billzo is offline
Contributing Member
 
Join Date: 07-29-12
Posts: 50
iTrader: 0 / 0%
Microsoft SQL Server is used mainly by corporations using Windows. MySQL is used mainly by people using Linux, and some corporations.

Microsoft's SQL has many more features than MySQL and is actively developed. MySQL's has two versions: free and paid. The pay version has been getting more features while the free version has not.

Many using MySQL are moving away from it in favor of MariaDB. Including Wikipedia and some Linux distributions (and maybe even cPanel).
 
Reply With Quote
  #6  
Old 12-04-2014, 07:33 PM
capturts capturts is offline
Junior Member
 
Join Date: 09-24-13
Posts: 12
iTrader: 0 / 0%
Quote:
Originally Posted by billzo View Post
Many using MySQL are moving away from it in favor of MariaDB. Including Wikipedia and some Linux distributions (and maybe even cPanel).
I think it's important to note that mariadb was a fork of mysql and when people speak about mysql, the two are usually used interchangeably.
 
Reply With Quote
  #7  
Old 12-04-2014, 07:51 PM
CerealNut's Avatar
CerealNut CerealNut is offline
Contributing Member
 
Join Date: 02-26-12
Location: Charlotte, NC
Posts: 191
iTrader: 0 / 0%
Quote:
Originally Posted by HTMLBasicTutor View Post
Here is a table explaining the differences: What is the difference between MySQL and SQL Server?
Great link.

Also, when it comes to hosting you might find that the MySQL solutions could be a bit cheaper.

When talking about development languages, if you are using .NET then I would lean on using MS SQL because of how tightly it is integrated with Visual Studio.
 
Reply With Quote
  #8  
Old 12-06-2014, 08:06 AM
billzo billzo is offline
Contributing Member
 
Join Date: 07-29-12
Posts: 50
iTrader: 0 / 0%
Quote:
Originally Posted by capturts View Post
I think it's important to note that mariadb was a fork of mysql and when people speak about mysql, the two are usually used interchangeably.
The two are used interchangeably for the version 5 branch of MariaDB. MariaDB version 5 is meant to be used as a drop-in replacement for MySQL Community Edition. Meaning that everything that works with MySQL CE version 5 will/should work just fine with Maria DB 5.x, including PHP connection libraries, queries, and the like.

However with version 10 branch, MariaDB has moved away from being a drop-in replacement for MySQL. MariaDB 10 may not incorporate all features of MySQL and may include its own features.
 
Reply With Quote
Go Back   Webmaster Forum > Web Development > Coding Forum

Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
#1045 Cannot log in to the MySQL server!? Al1000 Web Hosting Forum 5 12-20-2012 09:26 AM
Need a hand on mysql / php / server yy885 Coding Forum 8 03-14-2012 08:06 AM
MySQL Server Crashing need Help cataplexy Dedicated Servers 3 05-17-2011 02:37 AM


V7N Network
Get exposure! V7N I Love Photography V7N SEO Blog V7N Directory


All times are GMT -7. The time now is 05:46 AM.
Powered by vBulletin
Copyright 2000-2014 Jelsoft Enterprises Limited.
Copyright © 2003 - 2018 VIX-WomensForum LLC