Database Table Backup

RazorSQL includes a database table backup tool that allows users to backup database tables. The backup tool generates data definition language (DDL) statements for the table such as the Create Table and Alter Table statements for the table. The backup tool also generates SQL insert statements for the data contained in the table.

The table backup tool allows users to select the character encoding of the backup file, the SQL statement separator to use when generating the backup file, and whether to fully qualify the database table name in the generated SQL and DDL statements.

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

Backup files generated by the RazorSQL table backup tool can be imported using the RazorSQL Import tool.

Listed below is an screen shot of the table backup tool.

Table Backup Tool Image