Search
Home
Articles
Backup
Books
Certification
FAQ
Products
Replication
Scripts
Seminars
Training
TSQL

MSDN Fourms
Fort Worth SSUG
Oklahoma City SSDG

Resume

Champion Valley Pens

DBArtisan 4.01 1 2 3 4 5 6 7 8 9 10

Note: There are a number of screen shots included in this article. While they may take a moment to load, they are important in the comparison of these two highly-graphical interface products.

Comparing DBArtisan 4.01 and Enterprise Manager

DBArtisan gives a clear advantage in productivity over all of the other tools used to perform the daily and not so frequent DBA tasks. It is a major step forward from Enterprise Manager in terms of ease of use, presentation, and power. In every case, Enterprise Manager implements the bare minimum in functionality. DBArtisan goes beyond this to not only present the needed information, but to present it in a manner that is very useful and does not require any searching.

DBArtisan's user interface presents all of the pertinent data a DBA needs in a simple tree and tabbed interface, while Enterprise Manager relies on dialog boxes to present detail data. This makes comparison of objects very tedious and hinders the use of multiple windows as the interface gets very cluttered quickly. Not only does Enterprise Manager require you to open dialog boxes to get at detailed data, but you must do this separately for every object in most cases. Overall, Enterprise Manager's interface is very work intensive and requires a lot of effort to move around and do multiple operations. In addition to the setup of the interface, gathering the data a DBA requires means executing stored procedures or digging through multiple layers of dialogs to get the data a piece at a time. DBArtisan does not have these drawbacks and easily allows the user to switch databases or even servers without ever leaving the detailed window they are looking at.

DBArtisan 4.01 1 2 3 4 5 6 7 8 9 10

Michael R. Hotek

All content on this site, except where noted, represents an original work of Michael R. Hotek and is protected by applicable copyright laws. The SQL Server FAQ is the sole work of Neil Pike. No page, portion of a page, or download may be used for commercial purposes in whole or in part without the express, written permission of the applicable author.