SQL Server v MySQL

[Baby_G]

Hi there, can someone tell me what the differences between SQLServer and MySQL are.

I'm presuming MySQL is just a cut down version of SQLServer (oh and its free !) but what are the actual differences. What can i do in SQL that i can't do in MySQL.

I have a project to research and work are too tight to give me a copy of SQL to take home with me (although it will be SQL that i will do the work on eventually).

Any help would be greatly appreciated.

Cheers

[r937]

they are totally different products

totally

the only thing they have in common is that they both claim to support the relational database model through the so-called standard SQL language

but both have wildly different proprietary extensions to that language

suggesting that MySQL and SQL Server are the same is like suggesting that Apple and Wintel computers are the same

at some nebulous level of abstraction, they are

but not where it matters


rudy

[seanf]

Perhaps you can tell us about the project and we can suggest suitable software

Sean

[Baby_G]

Funnily enough, i don't know too much about the project. All i know is that involves a database and a web interface for people to compare data.
The database will be SQL Server and alot of the programming done in VB.NET

I'm meeting the people that have started the project to find out what they have done so far. I didn't want to appear stupid when i met them so thought I should brush up on all things databasey (this is my first development project).

I couldn't get a copy of SQL server, so i was going to download a copy of MySQL and go from there.

I'm thinking now though, that maybe if i just brush up on the SQL Language and database structure in general, that may suffice for now.

When i join the project and get stuck on SQL, i know where to come for advice... )
Thanks for the info so far though.

[Baby_G]

That should have been a smiley at the end of that sentence - that will teach me to draw my own smiley face instead of selecting one !!

[tripp]

You can get a six-month trial version of SQL Server for evaluation purposes: http://www.microsoft.com/sql/evaluat...al/default.asp

It comes with the Server Tools, so you can use Enterprise Manager and Query Analyzer to set up and manage your databases.

[Baby_G]

Thanks Tripp, i'll give it a go.