AlligatorSQL is a professional tool for managing and debugging all objects in a RDBMS. AlligatorSQL supports the twelve main database management systems present in the market namely, Oracle 8i, MySQL, Interbase, Birdstep RDM server, PostgreSQL, MSSQL, DB2, Ingres, Sybase, SAND/DNA Analytics, SAND/DNA Access and AlligatorDBC.
It is equally suited for DBAs and developers, who otherwise face a lot of problem with other such tool which don't have all the necessary features. AlligatorSQL is a complete solution to a DBA/developer's demands to database management and debugging. It comes with integrated project management features.
You can drag and drop objects from one database to another, analyse datas and import or export different file formats with simple clicks, no knowledge of any specific DDL is required for this.
The main feature provided by AlligatorSQL are as follows,
- Project Management
- Connection Folder
- Multithreaded Browser with Direct Edit and AutoFilter
- Multiple Join
- Simultaneous Access
- Explain Plan
- Source Code Checker
- Post Mortem Debugger
- Tablespace Checker
- DBA Toolbox
- Performance Monitoring
- User Management
- Process Management
- Office Integration
The Sourcechecker will find known bugs and errors in your PL/SQL Code which will not be detected by the PL/SQL Engine in Oracle. This feature will prevent the same bugs from creeping in again and again.
AlligatorSQL features amazing User Management functionality which make a DBAs work very easy, helping him to devote his time on other aspects of RDBMS. It'll also reduce the time take for a DBA to get familiarized with a DB system in case of a RDBMS switch.MySQL still does not offer user groups or roles. The user management for AlligatorSQL MySQL Edition shows all database users in an overview list. Access rights can be granted or revoked. Changes can be assigned to only one user or all selected rows of the list.
The integrated Profiler provides analysis of your PL/SQL code which would help you to find performance bottlenecks and make optimizations for improved performance.
You can access simulatneous database systems with AlligatorSQL, thereby removing the need for buying tools for all individual database systems, saving your organization a lot of money.
Being a multi-threaded application you can run concurrent queries, or you can continue with your work while a long and time taking query is being executed.
The project management feature allows you tob bundle single, repeated tasks into projects and load them again whenever you need them. If you need only a certain set of tables, out of probably hundreds or more, you can clone these tables into one custom folder and by saving the project you have them all in one folder whenever the project is loaded.Additionally you can link files from your hard drive into the project. All file types are recognized by AlligatorSQL and a double click will open them into the corresponding editor or SQL browser. This is a real time-saver.
AlligatorSQL is an amazing tool for both developers and DBAs, and it is designed to make your work easier and more productive. It's a must have tool for people working with multiple database systems, multiple database servers, or people who want to migrate data from an existing system to a new one.
A trial version of AlligatorSQL can be downloaded from the official site http://www.alligatorsql.de/products/...rsql/index.jsp The Enterprise Edition costs EUR 250 (roughly USD 336), it's worth the price for the features it offers.