List:General Discussion« Previous MessageNext Message »
From:KEVIN ZEMBOWER Date:November 7 2003 6:53pm
Subject:Re: Need help comparing MySQL to MS SQL Server
View as plain text  
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 it'll be the 
responsibility of another group. If we go with MySQL or PostgreSQL 
(the only databases I have any familiarity with), I'll probably be 
responsible for setting up and configuring a new Linux (Debian) host, 
and maintaining it. The in-house database administer would be the 
administrator, and I would just offer any help that I could, which might 
not be much.

Thanks, again, for writing.

-Kevin

>>> Nestor Florez <Nflorez@stripped> 11/07/03 01:18PM >>>
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" <m.tonies@stripped> 11/7/2003 10:08:53 AM
> >>>
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
> MySQL 5?

I have no experience with PostgreSQL - although, from what I've heard
and
read,
it's quite capable - but not easy to get going on Windows.

One other open source RDBMS would be Firebird - see www.firebirdsql.org 

Especially the newer release (1.5). Don't get fooled by that version
number -
it's a fork of the Borland InterBase code, which has been around for
about
20
years now.

I'm looking forward to MySQL5 to see what's new and how it's
implemented.

As for what engine would be the best for you - it all depends on what
you're
going to do. For example, I frequently use triggers and check
constraints in
my database applications, with MySQL, I can't do this.


With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird & MS SQL
Server.
Upscene Productions
http://www.upscene.com 


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql 
To unsubscribe:    http://lists.mysql.com/mysql?unsub=1 



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql 
To unsubscribe:    http://lists.mysql.com/mysql?unsub=1 


Thread
Need help comparing MySQL to MS SQL ServerKEVIN ZEMBOWER7 Nov
  • Re: Need help comparing MySQL to MS SQL ServerMartijn Tonies7 Nov
  • Re: Need help comparing MySQL to MS SQL ServerBrent Baisley7 Nov
Re: Need help comparing MySQL to MS SQL ServerKEVIN ZEMBOWER7 Nov
  • Re: Need help comparing MySQL to MS SQL ServerMartijn Tonies7 Nov
Re: Need help comparing MySQL to MS SQL ServerNestor Florez7 Nov
Re: Need help comparing MySQL to MS SQL ServerKEVIN ZEMBOWER7 Nov
  • Re: Need help comparing MySQL to MS SQL ServerJeff Mathis7 Nov
RE: Need help comparing MySQL to MS SQL ServerJohn Griffin7 Nov
Re: Need help comparing MySQL to MS SQL ServerPeter Gulutzan18 Nov