Database Backup Restrictions

The Database Backup plug-in allows you to back up databases through the use of ODBC (Open Data-Base Connectivity) drivers. ODBC exploits a so-called “Driver Manager” which uses a library of database drivers and acts an interface between the application and databases. Such “general” approach allows Handy Backup to back up standard types of data without concern for specific features of each particular database. This results in the following limitation:

• Handy Backup can only back up database tables. It cannot back up store procedures, views, functions, triggers, etc.

Note: It is possible to back up MSSQL database without limitations with a separate MSSQL backup plugin. To learn more, refer to MSSQL backup.

When restoring backed up tables to a new database, it is recommended to use a database of the same type and version, or with an identical structure. Otherwise, the following problems may occur:

• Loss of PRIVATE and FOREIGN keys information
• Loss of information about fields appearance format in DBMS editor
• IDENTITY field information loss (this field may be restored as a common one)

Currently, Handy Backup was tested with MySQL, DB2 and MS Access databases. Tests with other DBMS are in progress, and we will update this information as soon as possible.