| Author |
Topic |
|
molebrain
Starting Member
18 Posts |
 Posted - 2004-01-05 : 09:41:31
|
| Ok, now, to start things fresh, I am looking at why SQL Server is THE choice over mySQL. Im in a debate with someone here at work who swears by mySQL and rags on SQL Server. Can anyone provide me any info on why i shouldnt use mySQL?thanks!!!-tony |
|
|
ehorn
Master Smack Fu Yak Hacker
1632 Posts |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2004-01-05 : 11:03:38
|
| And remember, if COST is the primary point of concern, you can get SQL Server 2000 in its "free" form by using MSDE 2000. There are a couple of performance limits, but you still get all the features of SQL Server at the price of mySQL.--------------------------------------------------------------Find more words of wisdom at [url]http://weblogs.sqlteam.com/markc[/url] |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-01-05 : 11:15:06
|
| >> but you still get all the features of SQL Server at the price of mySQLActually msde is freely distributable whereas mysql costs money.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2004-01-05 : 11:24:28
|
quote:
Originally posted by nr
>> but you still get all the features of SQL Server at the price of mySQLActually msde is freely distributable whereas mysql costs money.
Well there you go. That just shows I've never implemented a mySQL solution...never had reason to. I thought mySQL's big selling point was that it was free.--------------------------------------------------------------Find more words of wisdom at [url]http://weblogs.sqlteam.com/markc[/url] |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-01-05 : 11:29:19
|
| Open source - you still need a licence for anything commercial (in theory).==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
molebrain
Starting Member
18 Posts |
Posted - 2004-01-05 : 11:54:29
|
| Thanks for the info. What always bugged me about mySQL is that it doesnt (to my knowledge) have Views, Stored Procedures or DTS. |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-01-05 : 14:01:26
|
quote:
Originally posted by molebrain
Thanks for the info. What always bugged me about mySQL is that it doesnt (to my knowledge) have Views, Stored Procedures or DTS.
DTS?Brett8-) |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-01-06 : 07:09:28
|
| DTS is a client application so it can ineract with mysql if it has the driver.It only happens to be distributed with sql server (like enterprise manager).Should be considered as a separate application like VB.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
Andraax
Aged Yak Warrior
790 Posts |
Posted - 2004-01-07 : 06:01:35
|
| mySQL also doesn't have referential integrity so far... (no foreign keys). They are planning to include it in their next version though.Also, stored procedures is also under development.But right now I would definately recommend MSSQL over mySQL (even though it's swedish). |
|
|
|
|
mySQL