By providing a single, easy-to-use interface for all major DBMS platforms, DBArtisan boosts your productivity, lowers costs and simplifies database administration in complex environments. DBArtisan automates and streamlines your day-to-day tasks by providing a rich, intuitive feature set including utilities for schema, SQL, job, and data management. It enables you to concurrently manage multiple databases from a single interface, enabling dramatic productivity gains for both experienced and novice database professionals.

DBArtisan provides numerous methods to help you optimize the performance of your key databases. With powerful database monitors, intelligent diagnostic information, and strong drill-down details, you can quickly get to the heart of any performance degradation and take the necessary steps to fix it. DBArtisan also offers additional functionality to analyze, debug, and optimize your SQL for maximum code efficiency.

DBArtisan will also help you effectively establish and maintain database security throughout your environment. Powerful functionality allows DBAs to manage users, roles, privileges and password security, and migrate accounts between the same or different database platforms. And because DBArtisan manages database security across different types of databases, you can take a consistent, simplified approach to security even in the most complex heterogeneous environments.

Planning for the future of your databases is a critical task. Embarcadero Performance, Space, and Capacity Analysts make it easy to understand where your databases are today and where they are heading in the future, as well as establish proper backup and recovery plans. By enabling a proactive approach, DBArtisan helps you improve uptime, quality of service, resource allocation, and avoid costly mishaps.

With the ability to display data in both text and graphical form, DBArtisan gives DBAs the information they need in the format they want.

DBArtisan Key Features

• Single interface for all major DBMS.
• Graphic editors and wizards for easy object administration.
• Migration wizards ensure accurate movement of schema objects and associated table data across databases and DBMS platforms.
• ISQL window with builtin explain plans, syntax checking, code complete, and performance execution analysis.
•  Graphical query builder.
• Debug procedures, triggers, functions, and packages.
• Add, change, or delete data from the tables while maintaining referential integrity.
• Performance, space and capacity analysis and planning tools.
• Backup and recovery for SQL Server.

The Analyst Pack includes advanced space, capacity and performance management capabilities to help DBAs prevent storage-related problems, trend data and object growth over time, and pinpoint performance bottlenecks.

DBArtisan Editions

DBArtisan Standard Features

• Security Management
• Performance Management
• Schema Managment

DBArtisan Professional Features

• Security Management
• Performance Management
• Schema Managment
• SQL Debugger/Profiler 

DBArtisan Workbench Features

• Security Management
• Performance Management
• Schema Managment
• SQL Debugger/Profiler