MYSQL Vs. SQL 2

[btish]

Can anyone tell me the difference between MYSQL and SQL Server? Sorry, newbie here. I know many people use PHP and MYSQL, but I use ASP and Cold fusion and wondered if I need to learn MYSQL or just SQL server with ASP and Cold fusion

Thanks Brandon Brandon Tisherman
Designer/Web Developer
Web Blends

http://www.webblends.com

 

[TomKane]

I think I read somewhere that MYSQL was like a cut down version of SQL Server that can do pretty much what you want except that the databases can only go up to a certain size.

I think there is a thread about it in the Vb Forum - "Visual Basic (Microsoft): Version 5 & 6"

Best of luck...

 

[pabloj]

MySQL is a SMALL, FAST opensource database with:
- Excellent multiplatform support (Windows/Linux/OSX/Solaris/HPUX/...)
- Transaction support with InnoDB tablehandlers
- Support for Tbs of data
- Support for ODBC/JDBC connectivity
- Commercial version option for those who don't want to be bound by GPL
- Included in Novell products and used by many huge customers
- VERY EASY TO USE
- One of the winners of PC Magazine "Database Clash"
- Excellent grant management

What it lacks:
- Triggers, stored procedures, views Stick to your guns

 

[jnicho02]

On a practical level MySql is supplied by many ISPs when they host a site, getting them to host a SqlServer database is a more expensive prospect. Jeremy Nicholson, Director of

http://www.firstlightassociates.co.uk

a UK-based Java and Data Warehousing consultancy

 

[osjohnm]

Hi

pabloj, I think you better go read the PC Magazine article again:

http://www.pcmag.com/article2/0,4149,89891,00.asp

Click on the scorecard link to see the results.
MySQL came dead last it only scored well in the performance sector.

btish, the whole article will be of value to you as a whole as it compares all the top major RDBMS vendors out there.
The RDBMS were reviewed in 8 key areas:

security
performance
management tools
server engine
database design
interoperatability
data analysis
programmability

As the review said MySQL is fast but falls short in all the other areas. It came last in everything except performance.

Admittedly when it came to programmability SQL Server only scored 3, mysql 2 but this was because of SQL Server's poor Java performance. When it was used with asp it flew.

Speed is one thing but when working with databases and the internet security is another thing. As a DBA security is one the most important aspects of my job.

Stored procedures and views aid this as you can limit access to tables through stored procs and views. Ideally you applications should only use stored procs to query the tables and then you pages called the procedures. Same with views. The less direct access to the base tables the better.

MySQL relies on 3rd party management tools unlike most database packages who ship with their own tools. SQL Server's tools are very ease to use and work with.
As PC Mag says:
"The SQL Query Analyzer is the most polished and functional tool we saw for tuning manual SQL queries"

MySQL also doesn't support constraints which means you have to code in all the checks to make sure that incorrect data isn't inserted. This means more code.

In my opinion since you are using asp stick to sql server. It performs well and is easy to use. If you plan to use a Unix environment go with Oracle, if it is a NT environment go with SQL Server.

After all as Oracle states "The internet runs on Oracle".
They are being honet. If money isn't an object then go with Oracle.

Hope this helps

John

 

[Niv3k]

One more thing - last I checked MySQL does not support sub-selects, which I don't see how you can write a database without. For example: SELECT * FROM Table1 Where Table1.Field1 NOT IN (Select Field2 FROM Table2) -- This will not work at all.

 

[pabloj]

As a big fan of MySQL I must correct this:

MySQL also doesn't support constraints which means you have to code in all the checks to make sure that incorrect data isn't inserted.

That's not true, InnoDB tables support constraints. Stick to your guns

 

[btish]

thank you all for the informative feedback....Looks like it will be SQL server for this kid.....
thanks again to all.
btish Brandon Tisherman
Designer/Web Developer
Web Blends

http://www.webblends.com