| Author |
Topic |
|
drkaj
Starting Member
1 Post |
 Posted - 2003-02-25 : 06:50:11
|
| I have been using SQL server for some time now, and i am not wery impressed with the tools that follows. The query analyzer and enterprisemanager does the job, but not wery well. I have also used Oracle with PL/Sql developer, which is a much better query and administrationtool. Does anyone know some alternative tools?Best regardsThomas Kaj Bonfils |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-02-25 : 09:01:03
|
| Query analyser isn't very good?What else do you expect it to do.Enterprise manager is good for people new to sql server look at databases but shouldn't be used for changing anything as it doesn't give a record of what you've done.I do everything in query analyser.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-02-25 : 14:16:06
|
| I've done both (and DB2 zOS)...oh and btw how did you like your life with oracle before PL/SQL Developer? Pretty painful using SQL Plus I'd say. Like building db objects and such in a dos window.What you need to get your hands on is Embarcadero's products (like DB Artisan) Or CA's ERWin Studio. But they ain't cheap. Saw someone mention Visio2000 Pro for models, It's great if you have nothing (well almost).Brett8-)Edited by - x002548 on 02/25/2003 14:17:02 |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-02-25 : 14:53:37
|
Visio is only a modeler/diagrammer, you certainly can't administer or develop with it.And yeah, I gotta second that on SQL*Plus. NO ONE can complain about Query Analyzer if they've ever used SQL*Plus. I will agree that EM looks pretty poor compared to TOAD (haven't seen the others), but at the same time, you're dissing a Mercedes/BMW only because it's not a Rolls Royce.And I'd be interested in seeing how well any of these Oracle tools handle replication, full-text indexing, DTS or something like it, if they handle them at all.  |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-02-27 : 11:50:08
|
| Whats TOAD? |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-02-27 : 13:16:49
|
| http://www.quest.com/toad/It is NICE. There used to be a free version but I think it's been discontinued. It does a lot of what EM does, and adds some functions from Visual Studio too, but the interface is SOOOOOO much nicer and easier to use, no drilling down through a tree view necessary. (this is BY FAR my biggest gripe about EM) If you look at the screenshots you'll see. Unfortunately as long as Microsoft makes EM an MMC plug-in it's unlikely EM will ever be as easy to use as TOAD. |
|
|
|
byrmol
Shed Building SQL Farmer
1591 Posts |
Posted - 2003-02-27 : 14:40:04
|
| Thomas,I can appreciate the critisism of the "Mangler" (Enterprise Manager) but I would like to know what part of Query Analyzer you really don't like...DavidM"SQL-3 is an abomination.." |
|
|
|
KnooKie
Aged Yak Warrior
623 Posts |
Posted - 2003-03-03 : 03:55:12
|
| May also depend on which version of SQL Server you're using ??===========Paul |
|
|
|
simondeutsch
Aged Yak Warrior
547 Posts |
Posted - 2003-03-28 : 00:33:24
|
Try Sequin, a freebie by Ken Henderson. (But don't get version 1!!) If you're lucky, you might like it. If you're not, you will begin to appreciate Query Analyzer. (Version 1 of Sequin was the crashiest program ever. As soon as you started it, it'd crash.)Sarah Berger MCSD |
|
|
|
|
Replacement of Query Analyzer and Enterprise Mng.