I would like to add my 2 bits.

I have found that MS SQL server has some draw backs. The data types TIME
and DATE are supported by interbase and not SQL server. MS SQL server
only supports DATETIME and the extraction of date and time from MS SQL
server can be problematic
when speed is an issue. Also if you want to talk with other data bases
such as FOXPRO which have all three data types you have a problem with
MS SQL server. MS SQL server overheads are not trivial and must not be
understated.

There are "horses for courses". All data bases have limititations even
MS SQL server. Some of my clients have moved from ORACLE to MS SQL
server and back again as over 300 MB MS SQL server has problems.

Victor


-----Original Message-----
From: Martijn Tonies [mailto:m.tonies@...]
Sent: Sunday, 2 November 2003 11:52 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Is Firebird too weak for a business
environment?

> Sorry Martijn,

Ah, no need - I wrote a ":-)" behind it... Just joking around.

> > Hey hey hey, Database Workbench is a feature, not a bug :-)
>
> Hey don't get me wrong, I am a register user of this very fine product

and

> use it all day long, every day and it is an indispensable tool in my
> development process. Keep up the great work you are doing on this

product.

> If the Firebird development team does come up a better security model,

then

> this will protect us developers from someone using one of these tools

to

> view our schemas or data without the proper permission to do do.

I know what you mean - pretty much any user can now view schemata -
however, the data itself is secure, unless you know the SYSDBA password
or if you have granted rights to the PUBLIC user.


With regards,

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



Yahoo! Groups Sponsor

<http://rd.yahoo.com/M=259395.3614674.4902533.1261774/D=egroupweb/S=1705
115386:HM/A=1524963/R=0/SIG=12o885gmo/*http://hits.411web.com/cgi-bin/au
toredir?camp=556&lineid=3614674&prop=egroupweb&pos=HM>

<http://us.adserver.yahoo.com/l?M=259395.3614674.4902533.1261774/D=egrou
pmail/S=:HM/A=1524963/rand=930764405>

To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]