Sign In
Create Account
Follow Us on Twitter
Subscribe on Youtube
Hi,
Can you please tell me the main differences between SQL Server and MySQL?
I'm learning SQL Server 2000 at the moment, but have no idea of what MySql is....
thank you very much...
:)
7 replies to this topic
Back to top|
|
|
#2
Posted 19 June 2007 - 08:50 PM
v0id
-
- Members
-
- 2,936 posts
Retired
First of all, your headline is not good.
You can't compare "SQL" and "MySQL". SQL is a language, while MySQL is a database.
MS SQL Server 2000 and MySQL are both databases, implementing the SQL-language. There is no big differences between the two databases. They both handles data. Of course there'll always be some differences between two products, but for a quick overview; they're doing the same stuff.
You can't compare "SQL" and "MySQL". SQL is a language, while MySQL is a database.
MS SQL Server 2000 and MySQL are both databases, implementing the SQL-language. There is no big differences between the two databases. They both handles data. Of course there'll always be some differences between two products, but for a quick overview; they're doing the same stuff.
#3
Posted 20 June 2007 - 04:12 AM
Sir_Rimo
-
- Members
-
- 18 posts
Newbie
First of all, sorry for that!
I meant MS SQL Server 2000 when I wrote SQL. we simply call it SQL in the class, and that causes the problem..
When I started the thread, I meant this:
we have a project which needs a database. Simply we don't use the MS Access for that, don't ask me why!:D it's not my fault! :D
I'm studying SQL and work with SQL Server 2000, so I know a bit about it. I want to know if MySql can help me instead of SQL Server 2000.
We don't need the file transfer or so. we just have a stand alone PC which runs the program. Is MySql good enough to handle a medium database?
What is the main difference of them? can we trust it for our project?
This is what I meant.
I'd be thankful to read your replies...
Thanks in anticipate,
Sir Rimo
I meant MS SQL Server 2000 when I wrote SQL. we simply call it SQL in the class, and that causes the problem..
When I started the thread, I meant this:
we have a project which needs a database. Simply we don't use the MS Access for that, don't ask me why!:D it's not my fault! :D
I'm studying SQL and work with SQL Server 2000, so I know a bit about it. I want to know if MySql can help me instead of SQL Server 2000.
We don't need the file transfer or so. we just have a stand alone PC which runs the program. Is MySql good enough to handle a medium database?
What is the main difference of them? can we trust it for our project?
This is what I meant.
I'd be thankful to read your replies...
Thanks in anticipate,
Sir Rimo
#4
Posted 20 June 2007 - 05:38 AM
v0id
-
- Members
-
- 2,936 posts
Retired
To be honest I don't no much about databases in general, and haven't used them for a while, so I'm not the best to ask.
I've only been working with the MySQL database, and it's fast, secure and easy to use. And it should could handle a medium database. I can't say if it's better than MS SQL Server because I've no experience with it.
If I should choose one of these databases (MS SQL Server and MySQL) I would choose the MySQL-database.
Maybe someone in here can come with a more detailed description?
I've only been working with the MySQL database, and it's fast, secure and easy to use. And it should could handle a medium database. I can't say if it's better than MS SQL Server because I've no experience with it.
If I should choose one of these databases (MS SQL Server and MySQL) I would choose the MySQL-database.
Maybe someone in here can come with a more detailed description?
#5
Guest_Jordan_*
Posted 20 June 2007 - 05:50 AM
Guest_Jordan_*
Guest_Jordan_*
-
- Guests
The difference is that one is a free (largest used) database - MySQL while MS SQL is made by Microsoft and is intended for large scale database structures.
MySQL will do fine for a medium or even a large database and I prefer to use it because it runs on Linux. MS SQL isn't bad but I hate managing it with the GUI that it comes with. In the end you should probably choose the one you know best.
MySQL will do fine for a medium or even a large database and I prefer to use it because it runs on Linux. MS SQL isn't bad but I hate managing it with the GUI that it comes with. In the end you should probably choose the one you know best.
#6
Posted 20 June 2007 - 06:33 AM
Sir_Rimo
-
- Members
-
- 18 posts
Newbie
Thank you both, you helped me a lot.
I'm going to give Mysql a try, I'll consult more with the tutorials and eBooks...
Thanks alot once more, I didn't think my questions will be answered this soon! good Site, Good Forums...
Thanks very much...
I'm going to give Mysql a try, I'll consult more with the tutorials and eBooks...
Thanks alot once more, I didn't think my questions will be answered this soon! good Site, Good Forums...
Thanks very much...
#7
Posted 20 June 2007 - 08:06 AM
WingedPanther
-
- Moderators
-
- 16,831 posts
A spammer's worst nightmare
I work with Firebird, MS SQL, and Oracle. I advise against Oracle whenever possible. It's painful to work with. MS SQL and MySQL will have slightly different syntax for advanced features, but should be comparable for a moderate number of users with pure SQL. You should avoid using Access if there is any chance of more than a handful of people using it at once, or even slightly complicated SQL queries. Access is a toy.
#8
Posted 05 October 2007 - 08:16 PM
Surgeon
-
- Members
-
- 3 posts
Newbie
I would *definately* have to agree with pretty much everyone.
Use MySql, you are going to be using SQL for all of your queries really, just hopefully you have MySql 4+ on the server you are going to be messing with.
I have been recently developing in .net so, I use SQL Server 2005 express, but then I make the DAL and the BLL, and then I cry, then I program..
One other thing you may want to consider if you are using PHP5 or so, is SQLite, its not meant for large scale projects, it doesn't scale well thats for sure, but, for small/medium sized projects, it is absolutely fantastic. Try it out, its actually really cool.
Use MySql, you are going to be using SQL for all of your queries really, just hopefully you have MySql 4+ on the server you are going to be messing with.
I have been recently developing in .net so, I use SQL Server 2005 express, but then I make the DAL and the BLL, and then I cry, then I program..
One other thing you may want to consider if you are using PHP5 or so, is SQLite, its not meant for large scale projects, it doesn't scale well thats for sure, but, for small/medium sized projects, it is absolutely fantastic. Try it out, its actually really cool.
