There is an amazing integrated suite for working with Interbase and Firebird, obviously named InterBase/Firebird Development Studio. It is really brilliant in all of its aspects and components, but I want to speak about the «first between equals» the Database Designer component.
IB/FB Development Studios Database Designer is a many-sided crystal. It serves as: Full-fledged visual ER diagram designer, with exceptionally usable navigation and layout manager; All-database objects manager, providing several different views; Object editor with handy property sheets provided. Yet Database Designers most serious achievement is its double-sided integration with the «physical» database. Unlike other similar software, this Database Designer is great not only for the «initial» design and script generation, but also for support, refactoring, and further development. To achieve those goals, the program has an integrated version control manager and rights manager. But the main thing is it can update (generate changing scripts) already existing database, even with non-trivial tasks like «change table name without data loss». And even if the database was changed, Designer can back-load all changes to diagrams and object lists in Designer.
Interbase/Firebird Development Studio 5.0 Interbase/Firebird Development Studio is a fully-fledged software solution for database programmers and administrators. You get the most powerful tools for the first time