Go4Expert

Go4Expert (http://www.go4expert.com/)
-   Products Showcase (http://www.go4expert.com/articles/products-showcase/)
-   -   Database Management made easier with AlligatorSQL (http://www.go4expert.com/articles/database-management-easier-alligatorsql-t5926/)

pradeep 18Aug2007 23:34

Database Management made easier with AlligatorSQL
 

Introduction



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.

Features



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
  • Profiler
  • Post Mortem Debugger
  • Tablespace Checker
  • DBA Toolbox
  • Performance Monitoring
  • User Management
  • Process Management
  • Office Integration
  • Adaptor
The Debugger lets you debug your sourcecode simple and efficient.The AlligatorSQL debugger supports interactive checking of PL/SQL procedures and functions, trigger and packages stepping through every single line of code. It supports creation of breakpoints to make things easier, and makes tracking down the problem a piece of cake.

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.

Screenshots



http://www.go4expert.com/images/arti...creenshot1.jpg

http://www.go4expert.com/images/arti...creenshot2.jpg

Conclusion



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.

coderzone 23Aug2007 17:27

Re: Database Management made easier with AlligatorSQL
 
Nice one. I have downloaded the Trial and see how things turn up.

coderzone 18Oct2007 10:38

Re: Database Management made easier with AlligatorSQL
 
Looks interesting.

Nadr 18Oct2007 10:48

Re: Database Management made easier with AlligatorSQL
 
Quote:

Originally Posted by coderzone
Nice one. I have downloaded the Trial and see how things turn up.

How does it differ from TOAD

Petra 18Oct2007 15:29

Re: Database Management made easier with AlligatorSQL
 
Quote:

Originally Posted by Nadr
How does it differ from TOAD

TOAD is just working with ONE database (Oracle) :( . AlligatorSQL supports twelve databases.
:)

coderzone 19Oct2007 21:22

Re: Database Management made easier with AlligatorSQL
 
Quote:

Originally Posted by Petra
TOAD is just working with ONE database (Oracle) :( . AlligatorSQL supports twelve databases.
:)

Hardly any person needs that many databases but yes its good to have that many options.

Safari 20Oct2007 10:49

Re: Database Management made easier with AlligatorSQL
 
Quote:

Originally Posted by Obaid
Hardly any person needs that many databases but yes its good to have that many options.

You can target more people if you have more options.


All times are GMT +5.5. The time now is 09:46.