The fourth version of IBAdmin available for Windows and Linux platform. Right now you can download only Linux edition of IBAdmin. IBAdmin 4 Windows Edition is coming soon.

IBAdmin is a complete SQL tool for Interbase / Firebird developers and database administrators. It has a lot of features that helps you easily create and maintain your database. IBAdmin covers all needs from the initial database design and development to database maintainance and clients support. Except the standard set of features for editing a database objects Linux Edition of IBAdmin includes:

Database Comparer
This is a great tool to upgrade your deployed database or prepare scripts to perform such upgrade. IBAdmin can compare the structure of two databases and prepare the "update script". This script will include statements needed to change database from one to another.

SQL Debugger
You can debug your Stored Procedures and Triggers. You may set input parameter values and look at the execution statistics.

Grant Manager
Some rights may be granted to Users and Roles here.
SQL Script Execution

There are two major enchancements here:

Script Navigator.
The contents of your script are shown at the left pane. You can double-click on the object name to find this object in the script. IBAdmin shows line numbers when your object is found several times (for example, CREATE PROCEDURE and later ALTER PROCEDURE statements.

Ability to control execution of the script and build conditional script execution.
Now you can include external files to your script, declare variables and check their values. Extra commands must be in the comments like a $DEFINE in Delphi and C++Builder. There are three commands available:

$INCLUDE
$SET <variable name>=<value>
$SET select field1, field2 from Table1 into <variable 1>,<variable 2>
$IF <condition> <Statements> [$ELSE <Statements>] $ENDIF
More examples are available in the users manual. Sample script is included in the IBAdmin installation.

Ability to change field datatype without data loss.
Sometimes you need to change the field datatype in the table filled with data. Sometimes you need to change field datatype and this field is used in many Procedures, Triggers and Check constraints. Interbase 6.x and Firebird has the ALTER TYPE command. But even this command does not allow you to reduce field size. The previous versions of Interbase has not ALTER TYPE command and you cannot safely change your field datatype. IBAdmin can do that for you. When you edit your field just set the "Keep Data" flag and IBAdmin will analyze your field dependencies and prepare script for safely change datatype. This first part of this script will drop indicies and alter your procedures to the empty one. The next part will create a temporary field and move your data. The last part will recreate dropped objects and restore the body of your stored procedures. Now you can change your field datatypes safely.

Script Recorder
When you working with database you may need to log all changes made with your database. This can be useful to log your changes at your development database to apply tit to the production database later. Turn on script recording to start loggin. You can start loggin for each registered database.

QuickView for the Object Metadata, Data and Description
This is just a useful interface improvement for Database Explorer. When you click on any database object you may see it's metadata, data for Tables and Views and object description.

Server Management (User Manager, Server Log, Backup, Restore, etc)
This feature available for Interbase 6.0/Firebird and higher versions only. Includes all standard set of Services API functions: Database Backup and Restore, Shutdown and Restard database, User Manager, Server Log, Server Properties, Database Validation.

Code Templates.
Very useful feature when writing a lot of code. You may set any expansion to any string. For example, when you type "sf" it will be replaced to "select * from ". "bg" can be replaced to "begin ... end" pair and so on.