HQbird: Advanced FirebirdSQL

IBSurgeon HQbird is an advanced distribution of Firebird for enterprises, with the following list of features: 100% Firebird engine, optimized configurations, high availability and replication, backups automation, database health monitoring, transactions and queries monitoring (TraceAPI, MON$ and FBScanner), database structure analysis, recovery toolset and database development GUI.
 
   

Firebird Performance Optimization

IBSurgeon offers Firebird Performance Optimization service to increase the performance of your Firebird database and application. We will optimize configuration of Firebird server and database, tune settings of hardware, virtual environments and operation systems, speed up your SQL queries with indices and tweaks, and improve database structure and transactions management.
From $599

Emergency recovery

To recover corrupted Firebird (or InterBase) databases (with size less than 65Gb) you can use IBSurgeon FirstAID - the best recovery tool for Firebird and InterBase. FirstAID can  automatically fix the vast majority of Firebird database corruption. For databases more than 65Gb in size please contact our support, most like they will require manual recovery service.
From $199

News

How to migrate to Firebird 3 in the fast and safe way?

As far as you know, recently released Firebird 3.0 has a lot of nice features, and the most important of them are the increased performance and the high compatibility with the previous version, so migration is the very attractive idea.
Probably you know that successful backup/restore does not mean successful migration:  the compiled representation of database objects are not changed during backup/restore, it remains in the old format.  There are several important steps to ensure the successful migration of database metadata and data to the new Firebird version.
We recommend having a copy of Firebird Migration Guide, which includes many recommendations and description of typical errors during migration.  It will really save you a lot of time during the migration.
Too complex?
What if your database structure is very complex, a database itself is really big and it has many applications connected too?  In this case, you need help from professionals – and we offer our comprehensive Firebird migration service.
Recently we have migrated very complex Firebird database with more 7000 stored procedures, 320Gb in size, in less than 2 months, and the delay between the final switch of the production copy from the old Firebird to the new one was less than 24 hours (it was done during the weekend). We guarantee the smooth and hassle-free migration.
The key thing in such a complex migrations is tracking tools from HQbird advanced Firebird distribution. These tools (FBScanner and FBPerfMon) allow tracking of ad-hoc SQLs and automated check of their validity against the new version, and then we can adopt these queries to the new Firebird version.
What about safety?
And, finally, let me add a word about the safety.  It is not a good thing to migrate your database and then got the corruption. To prevent it, HQbird (Enterprise edition) has replication and high availability features. With HQbird, you can create the complete and reliable replica of the database (on the same server or on another), which guarantees that even in the case of bad corruption you will have the good copy, and switch to it in minutes. HQbird Enterprise for Firebird 3.0 is now passing final tests and will be available in May, and there will be the free upgrade for existing HQbird Enterprise users.
Please feel free to contact us with any questions by email.

26 April 2016

How to migrate to Firebird 3 in the fast and safe way?

As far as you know, recently released Firebird 3.0 has a lot of nice features, and the most important of them are the increased performance and the high compatibility with the previous version, so migration is the very attractive idea.

19 April 2016

Firebird 3 is available!

Firebird 3 is available now!

15 April 2016

HQbird: advanced Firebird SQL for Enterprises

IBSurgeon is proud to present HQbird: advanced distribution of Firebird for enterprises. It is an enhanced, fully compatible with Firebird, feature-rich distribution of FirebirdSQL that provides superior performance, reliability, and instrumentation.

27 January 2016

Firebird Language Reference in English: Beta is available

Firebird Language Reference: Beta 1 of English version is available.

03 December 2015

Resolving Firebird performance problems

We have just published the new (completely new!) version of our presentation "Resolving Firebird Performance problems".

Read more news