Embarcadero DBArtisan

General

• Supports all major DBMSs (database management systems)
• Graphical editors and wizards help to improve productivity and provide a common interface to manage multiple tasks on multiple database platforms, improving manageability
• Integration with Microsoft Windows Task Scheduler
• Unicode support

SQL Management

• SQL editor offers syntax checking for code and object names, object lookup and code completion
• ISQL facility for creating, saving and executing SQL statements against your database
• SQL analysis provides code explanation and performance execution analysis for SQL code
• Visual query builder makes it easy to construct even the most complex queries

Schema Management

• Visually create, drop or alter a wide variety of database objects

Data Management

• Visual data editor enables users to add, edit and delete data whilst retaining referential integrity
• Easily migrate schema objects and associated table data using wizards

Security Management

• Manage users and their associated information
• Manage roles, grant and revoke roles
• Migrate accounts between multiple database platforms
• Categorise data according to the level of security and privacy that should be applied to it

Performance Management

• Proactively monitors your database and provides warning on performance, capacity planning and storage management issues before they become major problems
• Monitor actively connected users and other session related data