One other very nice feature that does not exist in Enterprise Manager is the ability to verify replacement of an existing object.  If an object of the same name already exists on the target server, DBArtisan will popup a window displaying the DDL for each object and allowing you to accept or reject replacement of that particular object.

One of the most time consuming processes for any DBA is in granting or revoking permissions. Many of us have the script generator method down to a science.   Enterprise Manager gives you one option for granting permissions. This is to individually select each permission for each table through the dialog box. The other route is to create a SQL statement that will generate all of your grant or revoke statements and then execute the output. DBArtisan makes this operation absolutely painless. As an example, I needed to create select permissions on all tables for a single user. In DBArtisan it was simply a matter of selecting the database and opening up the user tab for editing. DBArtisan then presented me with a list of all of objects (this list could be filtered by just tables, views, or procedures). I then clicked the select all button, clicked grant, and selected the select permission. DBArtisan generated all of the grant statements I need to grant permissions on all tables and then executed them. This interface is a DBA’s dream for granting permissions. I can select the user or group and then select all of the objects in a single operation for granting permissions.

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