InterBase/Firebird Development Studio takes you
from start to finish while you design, develop, and deploy
InterBase/Firebird databases. Seven specialized tools walk you
through all the steps of the development process—from design to
deployment to maintenance. Work efficiently and powerfully, every
step of the way.
ER diagrams can make the early stages of
database development a breeze. Database Designer offers ER
diagramming features—and much more. Database Designer
encompasses complete database development, covering table
structures along with stored procedures and triggers. Your
Database Designer project contains a repository for your database
objects, including the ER diagram as an object type. More about Database
Our Database Editor puts you in charge of your
database—create and modify database objects in your production or
development database. You can work quickly with the special editor
for each object type, along with advanced tools like SQL Debugger,
Extract Metadata, and SQL Monitor. Most code editors support
dynamic syntax and error highlighting. Our power-packed Database
Editor takes powerful editing one step further—with refactoring.
Optimize your queries with Query Analyzer.
Execution statistic and visual plan analyzer provide a fast and
effective way for speeding up your query. Query Analyzer is
equipped with Database Explorer that allows quickly extract object
metadata for instant change or generate SELECT, INSERT, UPDATE or
DELETE statements based on the table structure. You may write
several statements and run them all at once, except for SELECT
statement, of course. You can save frequently-used statements with
our SQL Favorites feature. Query Analyzer can be used also to
create and execute SQL Script.
Upgrade your database easily with Database
Comparer. To perform an update you can select your production
database, select your development database, and click Compare. The
tool generates an SQL script containing all DDL commands required
to upgrade metadata of the production database. It’s that quick.
Automate your deployment process with command line switches of the
InterBase and Firebird require almost no
administration. However, occasionally you might need to back up or
restore a database, check it for corruption, and manage server
users. Do it all with Administration Console.
Monitor your database performance the right
way. Interbase 7.x has special temporary tables with lots of
information about your database. Firebird and prior versions of
Interbase provide only general workload information. Performance
Monitor extracts available information, depending on your version
of Interbase/Firebird and presents the data in a variety of ways.
Maintenance Service Manager.
Interbase/Firebird Development Studio contains
a system service to perform scheduled maintenance tasks. The
Maintenance Service Manager manages this service locally or
remotely. You can schedule database backup with a wide range of
options, such as including validation before backup, attempt to
restore after successful backup, and more. You can even schedule
stored procedures or SQL scripts to run on specific days and
times. Receive error reports in your e-mail.