Welcome to the IB LogManager Product Family

The IB LogManager Product Family is a suite of tools which helps you to keep track of data changes in your InterBase® and Firebird^tm database.

But, it's more than simply integrating a logging/auditing mechanism in your InterBase® and Firebird^tm database, because the available Addon's will help you to manage and to process log data in different ways.

Download Factsheet (.pdf)

Key Features

• Supports InterBase 5.x, 6.x, 7.x, and Firebird 1.x, 2.0
• Server-side logging mechanism
• Table operation logging
• Table column logging (including BLOBs)
• User-definable conditional logging
• Scripting Engine to automate repetitive tasks
• Browse, export, print log data
• Global IBO DML Caching Integrator Support. More...
• Addon IBLMExport: Command-line utility to export logged data
• Addon IBLMPump: Command-line utility to pump/transfer logged data
• Addon IBLMRedo: Wizard driven roll-forward log utility
• Addon IBLMUndo: Wizard driven roll-back log utility
• and much more...

Products/Tools

The IB LogManager Product Family currently consists of the following products/tools:

• IB LogManager: The core product to integrate a server-side logging/auditing mechanism in your InterBase/Firebird database. IB LogManager logs data changes in the database for different data manipulation operations (Delete/Insert/Update) on user-definable database objects (tables, columns). A point-and-click interface enables you to define easily, which database objects should be logged. If you are interested in logging a history of price changes in a table ARTICLE, just define it with one mouse-click and relax.

• IB LogManager Viewer: Same code base as IB LogManager, but without the capability to change the logging schema. Useful for people who should be able to browse, export and print log data, but without the permission to change the logging schema. IB LogManager Viewer isn't needed if you have IB LogManager, because IB LogManager has the entire Viewer stuff built-in.

• IBLMExport: A command-line utility to export logged data into different file formats (e.g. Excel, Winword, HTML, XML, ...). You can schedule the export process by using any task scheduling facility like 'AT' under Windows NT/2000/XP. More...

• IBLMPump: A command-line utility to pump/transfer logged data from the production database into an external "transaction log" database using the two phase commit (2PC) protocol. By using IBLMPump regularly, you keep your production database tight (logged data will not "pollute" your production database) and in case of a crash of your production database, logged data will not be lost. To regularly pump logged data you can either schedule the pump process by using any task scheduling facility like 'AT' under Windows NT/2000/XP or by using the background pumping option (timer or InterBase^®/Firebird event based) of IBLMPump. More...

• IBLMRedo: A utility with a wizard driven graphical user interface to apply logs in a source (external "transaction log") database on a destination database, either to recover (roll-forward log) a production database from a workable operating system backup by applying all logged operations and column values or to manually replicate (one-way; unidirectional) one master database with many slave databases. More...

• IBLMUndo: A utility with a wizard driven graphical user interface to undo logged data manipulation operations to a specific point in time. Currently in Beta and only available for registered customers. More is coming soon. Stay tuned.