1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Database Management made easier with AlligatorSQL

Discussion in 'Products Showcase' started by pradeep, Aug 18, 2007.

  1. pradeep

    pradeep Team Leader

    Joined:
    Apr 4, 2005
    Messages:
    1,646
    Likes Received:
    86
    Trophy Points:
    0
    Occupation:
    Programmer
    Location:
    Kolkata, India
    Home Page:

    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



    [​IMG]

    [​IMG]

    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/alligatorsql/index.jsp The Enterprise Edition costs EUR 250 (roughly USD 336), it's worth the price for the features it offers.
     
  2. coderzone

    coderzone Super Moderator

    Joined:
    Jul 25, 2004
    Messages:
    734
    Likes Received:
    37
    Trophy Points:
    0
    Nice one. I have downloaded the Trial and see how things turn up.
     
  3. coderzone

    coderzone Super Moderator

    Joined:
    Jul 25, 2004
    Messages:
    734
    Likes Received:
    37
    Trophy Points:
    0
    Looks interesting.
     
  4. Nadr

    Nadr New Member

    Joined:
    Oct 16, 2007
    Messages:
    165
    Likes Received:
    1
    Trophy Points:
    0
    How does it differ from TOAD
     
  5. Petra

    Petra New Member

    Joined:
    Aug 23, 2007
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    0
    TOAD is just working with ONE database (Oracle) :( . AlligatorSQL supports twelve databases.
    :)
     
  6. coderzone

    coderzone Super Moderator

    Joined:
    Jul 25, 2004
    Messages:
    734
    Likes Received:
    37
    Trophy Points:
    0
    Hardly any person needs that many databases but yes its good to have that many options.
     
  7. Safari

    Safari New Member

    Joined:
    Oct 16, 2007
    Messages:
    183
    Likes Received:
    17
    Trophy Points:
    0
    You can target more people if you have more options.
     

Share This Page