January 25, 2004 at 9:35 pm
I am new to MS-SQL and I was wondering what is a good admin tool to use with it.
In Oracle I used "SQL Navigator" and with MySQL there is the "EMS MySQL Manager 2". The app should let me design and edit every aspect of the database as well as running queries and writing TSQL.
I am open to suggestions.
January 26, 2004 at 1:47 am
You can install client tools from SQL Server Setup
January 27, 2004 at 9:32 am
As you are used to Spolight for Oracle I assume that you like the product it therefore makes sense to use the same tool for SQL Server.
Quest have a Spoltlight version for SQL Server and you can download an eval copy from http:/www.quest.com
Hope this helps
January 27, 2004 at 9:34 am
As you are used to Spolight for Oracle I assume that you like the product it therefore makes sense to use the same tool for SQL Server.
Quest have a Spoltlight version for SQL Server as well as other SQL tools and you can download eval versions from http:/www.quest.com
Hope this helps
January 27, 2004 at 10:06 am
Well.. I meant more like a 3rd side application like "SQL Navigator"... To let me design the database and run queries.
Isn't there a popular one for MS-SQL?
January 27, 2004 at 12:24 pm
There are some other products (Embarcadero comes to mind). But, IMO, none that offer significantly greater advantage over MS builtin tools (at least not worth the extra cost). Unlike Oracle, MS does a better job at making their tools easier to use. I don't think there is a better query tool than Query Analyzer (at least I haven't seen one, although tools like mssqlXpress that tie into SourceSafe sound like they offer a feature worth having). And having the flexibility to either write DDL code or point and click for building databases/tables/columns/indexes is what has significantly helped build SQL Server's popularity.
Mark
January 28, 2004 at 6:02 am
Many SQL developers are MS developers and have MSDN Universal or similar which gives them Visio.
For design (not, IMO, administration and maintenance) I think Visio is a great tool, the right combinations of simplicity with generating decent initial schemas. You should clean them up by hand (you should clean any tools up by hand!) but the visual design is a vast improvement over the drawing tool in enterprise manager, and (if you have a subscription) the $0 price is right.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply