IMO there is no question that IB Server Manager is inadequate. It does the
bare minimum of admin, and is not at all usefull as a developers right hand
tool for developing and tuning SQL. nor is it in any way usefull for
designing and maintaining a database model.
However, there are numerous excellent shareware products you can use as
devlopment tools to use with IB - Marathon and TV being 2 good examples for
starters. Without these, it is hard work developing a CS solution.
I am sure there are similar good tools to help you with SQL7 development.
By the same token I found the tools that come with SQL Server 7 partricuarly
ugly, (I just hate the MDI interface for the ISQL thing they have) dated in
style, Bloated, gimicky, but useless.
The exception is the Optimiser Plan display which I found very nice.
SQL7 tools are an example of non standard, ugly, bloated gimicky but totally
useless UI. On the surface they look great, but after you have used them for
a month.....
Add to that the lack of triggers, fairly useless SP language, complete
absence of read consistency without writers blocking readers, heavy reliance
on tuning and general Admin, lack of generators...I could go on for ever,
but why not just take our advice and run with Interbase otherwise start
talking to the SQL 7 people who I am sure will give you every reason under
the Sun to use their product.
Much more importantly is the changes you need to make inside your own head
when moving from Local Database to CS and this is what you should be
focussing on rather than comparing N details of DBX versus DBY.
Like Nic, and many others, I find IB to be a nice simple to use, well
featured, robust, reliable slim, efficient, multi platform, free from vices
and gotchas, CS DBMS.
I have introduced many developers to it, and without exception every one of
them will second my opinion.
Anyway, why do we keep on getting sucked into this rant Nic?
.-----Original Message-----
From: Nic Wise <[EMAIL PROTECTED]>
To: Multiple recipients of list delphi <[EMAIL PROTECTED]>
Date: Wednesday, 19 January 2000 2:52 PM
Subject: Re: [DUG]: That famed Interbase Admin GUI...... (Att: Nic)
> Yeah..... REAL great GUI we have here. Please tell me that I am missing
> something here. I have Interbase 5.5.0.742 and the ServerManager is paltry
> in terms of GUI config options.
this is mostly 'cos there ARE NO OPTIONS IN INTERBASE! There is nothing
to tune, nothing to mess with etc. You install it. You start it (if its
not already). You leave it the hell alone. Unlike MSSQL and Oracle where
you need a DBA to tweek it every 5 mins.
Sorry if I sound a little agitated, but EVERY time someone looks at IB
from a MSSQL background, they get hung up on this! MSSQL has a pretty
interface over an old and shockingly bad database engine. IB has almost
no gui over a very good one. Think about which bit you want.
Look at something else which is similar. Linux vrs NT.
NT: pretty face. Runs for about a week. Users love it 'cos of the gui.
Linux: charactor mode (Xwindows doesn't count IMO). Runs for ever,
pretty much (months and years, not weeks and days). Users dont like it
'cos they have to type, not click on pretty pictures.
Which would you rather have running your business?
See my point?
> Compare this to SQL 7 where you can see all
> the objects in the database (Tables, Views, Stored Procedures etc. etc.)
and
> you can set all the security permissions etc. via the GUI. Unless I am
> missing a tool here the Admin GUI is non-existent.....
yup, it is lacking in that area - 6.0 goes some of the way to fixing
that, tho not as far as you want. Seen the SQL Explorer? Looked at some
of the 3rd party stuff (InterbaseDesktop etc)? I used them for a while,
then didn't bother, 'cos I never really needed them - mostly 'cos I
never needed to change anything beyond what I did when I set the
database up.
N
--
Nic Wise - Chief SCUD Launcher - Inprise/Borland New Zealand
wk: 09.481.9999 x9753 cell: 021.676.418
em: [EMAIL PROTECTED]
---------------------------------------------------------------------------
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
