Availability, performance and security are the universal goals of database administrators. Achieving these goals requires constant vigilance, contingency planning, and a huge amount of tedious work. Embarcadero DBArtisan liberates you from the tedium by providing comprehensive graphical facilities that make error-prone and time-consuming administrative tasks a thing of the past.

DBArtisan is the leading database administration solution for managing Oracle®, Sybase®, Microsoft SQL Server®, IBM® DB2® for Open Systems, and IBM DB2 for z/OS and OS/390. Its rich feature set helps you maximize the availability, performance, and security of databases throughout the enterprise. DBArtisan enables you to concurrently manage multiple databases from a single graphical console, creating dramatic productivity gains for both experienced and novice database professionals.

DBArtisan automates and streamlines day-to-day administrative tasks such as managing space, creating user accounts, altering objects, migrating schemas between development, test and production databases, monitoring performance, and much more. And because DBArtisan provides a common user interface for all major DBMS platforms, businesses can lower costs and boost productivity by standardizing on a single database administration solution.

DBArtisan provides unparalleled database object management capabilities. Its database platform- and version-specific graphical object editors and wizards allow you to create, drop or alter a wide variety of database objects, including tables, constraints, indexes, views, users, procedures, functions, triggers, groups, roles, profiles, and packages.

DBArtisan includes standardized, multi-tabbed, graphical object editors, for each database object type, which allow you to move effortlessly from managing a SQL Server® or Sybase® schema to managing an Oracle® schema and vice-versa. The product contains full knowledge of the underlying DBMS system catalog, syntax, and alteration rules. In terms of documenting your schemas, wizard-driven report facilities can help you create frame-based web sites that contain one object or an entire database's definition.

DBArtisan can help you efficiently establish and maintain database security. Whether you're managing an existing production database or setting up a new one, you'll find powerful functionality to:

Managing space is vital to ensuring the availability and performance of your databases. DBArtisan incorporates many built-in space features that enable you to smartly manage and exploit all aspects of your database's storage. For advanced space analysis, DBArtisan's Space Analyst component (included in DBArtisan Workbench) contains sophisticated diagnostics to help you pinpoint all space-related problems in your database, as well as an intelligent reorganization wizard that can reorganize all or selected parts of your database.

DBArtisan offers powerful visual tools for creating and analyzing complex SQL statements and server-side code objects such as stored procedures, triggers, etc. Using the Embarcadero Query Builder, you can construct even the most complicated SQL statements with point-and-click ease. As you select the objects and methods to use for SQL statements, DBArtisan automatically generates the code. The built-in syntax checking facility ensures that all SQL statements are built and run correctly the first time.

DBArtisan's feature-rich ISQL facility allows you to create, save, and execute all SQL code against your databases with ease. Built-in hotkeys and code completion features help you code SQL as quickly as possible. To analyze and debug your code, DBArtisan provides built-in explain and performance execution analysis as well as optional cross-platform code debuggers (purchased and licensed separately) that you can use to troubleshoot server-side code objects. For unattended Oracle® SQL capture and execution analysis, you can use the optional SQL Profiler component (purchased and licensed separately). Finally, to tune inefficient SQL code, DBArtisan integrates with Embarcadero SQL Tuner, allowing you to automatically rewrite poorly performing code into fully optimized SQL.

Tasks, like large reorganizations or critical database alteration scripts, often need to run during off-hours. DBArtisan offers two different ways to help you get a handle on job management:

1. DBArtisan freely integrates with the Microsoft Windows® Task Scheduler, which allows you to schedule virtually any task to run on your own computer whenever and how often you'd like.
2. For those wishing more robust job management capabilities, DBArtisan integrates fully with the Embarcadero Job Scheduler. From your DBArtisan desktop, you can build and schedule any command line or SQL job to run on any Windows, UNIX, or Linux machine in your job scheduler network. Within DBArtisan, you can deploy a SQL job to run on any machine in your environment. If you use UNIX or Linux, imagine – no more CRON files! You also have full control over every job you create and can stop, start, and analyze the output of any job you choose.

DBArtisan provides comprehensive facilities to help you manage the data in all your databases. A visual data editor helps you add, change, and delete data from your database tables with all referential integrity being enforced. You can create insert statements for tables using current data and also extract data as XML documents for certain databases.

DBArtisan also offers wizard-driven utilities for migrating schema objects and associated table data from one database server to another. You can copy a single database object, all objects owned by a specific schema user, or an entire database. Alternatively, you can define a custom migration job that will migrate any group of database objects. DBArtisan can also perform combinations of cross-DBMS platform migration for common database objects, such as tables, data, users, indexes and views.

There is perhaps no greater responsibility for the DBA than establishing proper backup and disaster recovery plans. DBArtisan assists the DBA with backup and recovery in a number of ways. First, DBArtisan provides graphical interfaces to assist with the exporting, importing, loading, and unloading of data. DBArtisan also offers wizards that assist in creating full backup and recovery tasks, such as Sybase dumps and loads. For those needing integration with operating system backup and recovery jobs, DBArtisan fully integrates with the Embarcadero Job Scheduler, which provides full support for all UNIX, Linux, and Windows jobs, including those designed for backup and recovery.

SQL Server® DBAs with involved backup and recovery needs will benefit from using Backup Analyst, which runs inside the DBArtisan console. Backup Analyst provides a high performance backup and recovery engine that contains powerful compression capabilities that reduce backup storage requirements by up to 80-90% in many cases. Additionally, Backup Analyst provides built-in encryption features that offer extra protection for sensitive database backups. These features, combined with DBArtisan's administration suite and a robust backup and recovery management interface, make Backup Analyst the only choice for serious SQL Server® DBAs who need an enterprise solution for their growing backup and recovery needs.

As a busy DBA, you can't waste time trying to figure out critical performance bottlenecks in your database. Instead you need tools that take all the guesswork out of performance management and help you make things right again. DBArtisan offers a number of different options to help you manage the performance of your key databases. DBArtisan ships with a built-in process monitor that helps you understand who is connected to your database along with each session's current activity. Locking details and other session-related data is also provided.

For those wishing more robust performance details, DBArtisan's Performance Analyst component (included in DBArtisan Workbench) is a powerful client-side database monitor that runs fully contained inside the DBArtisan console. Embarcadero Performance Analyst provides intelligent database and OS diagnostic information and strong drill down details to help you get to the heart of any episode of performance degradation. Embarcadero Performance Analyst integrates completely with DBArtisan so you can fix any found performance problems with a few mouse clicks.

If you need 24 x 7 unattended coverage of your critical databases, then you will want to look into the Embarcadero Performance Center. Performance Center is a separate enterprise-wide performance solution that can notify you around-the-clock of any performance problem requiring your attention and integrates fully with DBArtisan to help you fix identified performance bottlenecks.

Planning for the future of your critical databases used to be a difficult task. However, DBArtisan's Capacity Analyst tool (included in DBArtisan workbench) makes it easy to understand where your databases are today and where they are heading in the future. Embarcadero Capacity Analyst lets you track key database metadata and performance metrics over time so you can perform trend analysis on key areas like database growth, object fragmentation, database I/O, and session load. Smart forecasting mechanisms built into Embarcadero Capacity Analyst allow you to predict when your databases will run out of space or when an object will need to be reorganized.

Unlike other DBA tools, the base DBArtisan product does not install any objects on production database servers so you have no product footprint to manage. DBArtisan's optional Performance Analyst component only installs two packages on each database it monitors. DBArtisan's optional Capacity Analyst component does require the installation of several repository tables that are used to collect, retain, and analyze historical database information.

DBArtisan supports the following DBMS versions running on UNIX, Linux, and Windows-based servers:

• IBM® DB2® EE, EEE and ESE for Open Systems 7.1 - 8.x
• IBM DB2 for OS/390 and z/OS v6, v7 and v8 (IBM mainframe)
• Microsoft® SQL Server 7.0, 2000, 2005
• MySQL® 3.x - 4.1x
• Oracle® 7.3.4 - 10g
• Sybase® ASE 11.92 - 15.0

Embarcadero DBArtisan Workbench supports:

• IBM DB2 EE, EEE, and ESE for Open Systems 7.1 - 8.x
• Microsoft SQL Server 7.0, 2000, 2005
• Oracle 7.3.4 - 10g
• Sybase ASE 11.9.2 - 15.0

Embarcadero Backup Analyst supports:

• Microsoft SQL Server 7.0, 2000, 2005

Embarcadero Backup Analyst is a separately licensed add-on to DBArtisan, DBArtisan Professional and DBArtisan Workbench.

• Windows® 2000, 2003 and XP
• 256 MB memory
• 256 MB disk space
• Embarcadero Performance Analyst requires Internet Explorer 5.5 or later