I agree with Nic 100%. Specially on the moving from IB to Ms SQL after... I did it
last year a nd I still regret it...
Bernard Varaine
Digital Objects Ltd www.digitalobjects.co.nz
PO Box 60510 Mobile: 025 2777-843
Titirangi Fax: (09) 8128-368
Waitakere city Phone: 0800 LETS DO IT
New Zealand 0800 538-736
-----Original Message-----
From: Nic Wise <[EMAIL PROTECTED]>
To: Multiple recipients of list delphi <[EMAIL PROTECTED]>
Date: Sunday, 28 February 1999 16:29
Subject: Re: [DUG]: SQL Server or Interbase ??
> Hi all.
OK, I'm a little biased, but still..... (so are most people who have
used
IB)
>
> I have only really had experience with SQL Server, how does Interbase
> stackup against
> SQL server ?
Basically, except for a few points, it eats its lunch. Period.
> Is is reltivly similar ?
Kinda. Both are RDBMS's with SQL interfaces - a lot of the themes
are the same - SP's, Triggers etc. MSSQL has a nicer interface (UI),
and more built in SP's, but its tied to NT (NOT a good thing if
you need >100 people on the machine), and has a few fundermental
flaws (no row level locking, the log file, having to manually resize
data files (6.5), only one transaction per connection, only one active
statement per connection (this is a biggie), 16 tables per select)
Interbase has stuff all UI, but it doesn't need it (there is stuff all
to configure), it runs on various flavours of Unix as well as NT/9x
(and linux!!), and requires stuff all memory (64meg machine will run
WELL, not on MSSQL). It has pre and post triggers (ie, fire before an
insert,
not just after it!), and good SP language (not as good as PL/SQL, but
way better than Transact/SQL), etc.
Oh, and we sell it. :)
> Is it about the same in ease of use ?
>From a developer's POV using Delphi (different if you use VB or VC++),
I think they are about the same. Technically, dont start with IB if you
want to go back to MSSQL at a later date - it (MSSQL) will just
frustrate you
.
:)
> Is it easy to deploy ?
MSSQL is a MISSION to delpoy, especially in a single user system (ala
IBLocal),
and not a load of fun as a server.
Interbase is trivial to install and deploy. Just run the installer. Set
passwords
if needed. Put your DB on the machine. Leave it alone.
Embed, Deploy, Relax. I hate taglines, but this one is about right.
> Any info would helpful.
If you need something specific, drop me a line ([EMAIL PROTECTED]). I
have
done a few comparisons for people of late (I've used MSSQL for about a
year
at my previous job, from a dev. and admin point, and I have a MCP exam
for it under my belt), and I can forward them to you if you want them
Nic
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
