Re: Need help comparing MySQL to MS SQL Server

2003-11-18 Thread Peter Gulutzan
KEVIN ZEMBOWER wrote: The organization hired an outside consultant to evaluate which SQL engine to go with. This is what he sent to us: ... SQL Server 2000 is a complete Relational Database Management System (RDBMS) that also includes integrated analysis functionality for OLAP and data mining.

Re: Need help comparing MySQL to MS SQL Server

2003-11-07 Thread Martijn Tonies
Hi Kevin, I'm a system administrator for a small (200 people) branch of a large university/medical school. I've worked with MySQL and use it as my database of choice for web-based dynamic content. I would not consider myself an experienced, professionally-trained, knowledgeable database

Re: Need help comparing MySQL to MS SQL Server

2003-11-07 Thread KEVIN ZEMBOWER
Martijn, thank you very much for your analysis. I hope others will continue to join in. With regard to your point quoted below, are you referring to PostgreSQL, and would that be a stronger competitor to MS SQL Server 2000 than either the current version of MySQL or MySQL 5? Thanks, again, for

Re: Need help comparing MySQL to MS SQL Server

2003-11-07 Thread Martijn Tonies
Hi Kevin, Martijn, thank you very much for your analysis. I hope others will continue to join in. So do I :-) With regard to your point quoted below, are you referring to PostgreSQL, and would that be a stronger competitor to MS SQL Server 2000 than either the current version of MySQL or

Re: Need help comparing MySQL to MS SQL Server

2003-11-07 Thread Nestor Florez
I have not work with it but postgres is supposed to work great in /BSD/Linux/Unix/solaris environment Which platform are you using? :-) Nestor A. Florez Martijn Tonies [EMAIL PROTECTED] 11/7/2003 10:08:53 AM Hi Kevin, Martijn, thank you very much for your analysis. I hope others will

Re: Need help comparing MySQL to MS SQL Server

2003-11-07 Thread Brent Baisley
It sounds like a copy and paste from Microsoft, but that is just my guess. An objective recommendation with show pluses and minuses of both. It most definitely does not sound like this consultant is qualified to suggest a database product. What about PostgresSQL, Oracle, Sybase, DB2? They all

Re: Need help comparing MySQL to MS SQL Server

2003-11-07 Thread KEVIN ZEMBOWER
Nestor, thanks for your question. The platform will actually be dictated by the SQL engine, not the other way around, which is more typically the case. If we go with MS SQL Server, we'll build a separate host, NT I would guess, to host it. I'm only responsible for Unix and Linux boxes here, so

RE: Need help comparing MySQL to MS SQL Server

2003-11-07 Thread John Griffin
that do very nicely without them. Why are you different? John Griffin -Original Message- From: KEVIN ZEMBOWER [mailto:[EMAIL PROTECTED] Sent: Friday, November 07, 2003 1:53 PM To: [EMAIL PROTECTED] Subject: Re: Need help comparing MySQL to MS SQL Server Nestor, thanks for your question

Re: Need help comparing MySQL to MS SQL Server

2003-11-07 Thread Jeff Mathis
kevin, i tend to think the consultant really just read something that microsoft sent him. it doesn't sound like he's qualified to suggest one database or another. We've been usinf mysql for a year now. We use InnoDB tables, which give us primary key/foreign key constraints and transactions.