SQLArtist

The SQLArtist is a software tool that is designed to be easy to use and highly powerful for administering databases. Among the powerful functionality of this tool, its user-friendliness is one of the key criteria. The strengths of the SQLArtist can be listed in the following points:

- Editing, creating, and deleting tables, procedures, primary keys, triggers, constraints, foreign keys, unique keys, indexes, views, roles, users, user datatypes, defaults, rules
- Wizard for creating SQL scripts like select, update, delete, insert with options for restriction, grouping, and sorting
- Import and export SQL scripts between SQLArtist and Borland Delphi
- Automatically update tables based on SQL scripts, for example, from Sybase Power Designer
- SQL editor with full SQL syntax support (colors can be adjusted) for better readability of scripts
- Edit data directly without SQL scripts
- Manage database updates for customers, including a program for execution at the customer's site
- Integrated, context-sensitive SQL help
- Comprehensive help for the SQLArtist with added pictures
- Save created SQL scripts individually or in lists
- Database version control

The ability to create SQL scripts, with the option to store them individually or in lists, ensures that the scripts can be executed on other databases without having to re-enter the entire script. The created database update lists can now be executed on the customer's database in a secure mode. The version control records which queries were executed, or which version the database is on. The execution mode guarantees that changes are executed correctly. In case of an error, the original state can be restored.

The current version supports the database servers Microsoft SQLServer 2000 and Sybase SQLAnywhere from version 7.0. SQLArtist is built on the ADO interface.