Informix Database Backup Tool

Included in RazorSQL are Informix backup tools for backing up Informix structures and data for various Informix objects. RazorSQL also includes a single table backup tool for Informix.

The Informix database backup tool works by generating all data definition language (DDL) statements for the Informix database objects selected by the user. It also generates SQL insert statements for all table data in the database. The DDL and SQL insert statements are written out to a backup file.

The Informix database backup tool allows users to select the objects to backup such as tables, views, indexes, functions, procedures, and triggers, the character encoding of the backup file, the SQL statement separator to use when generating the backup file, and whether to fully qualify object names in the generated SQL and DDL statements.

The database backup tool writes out all data in character format, and as such, may not be acceptable for backing up tables that contain binary data.

Below are screen shots of the main selection pages for the Informix database backup tool and the Informix single table backup tool.

 

Informix Database Backup Tool

Informix Table Backup Tool