RazorSQL How to Backup Tables or Databases / Schemas
The first step before backing up data and structures is to get connected to a database. For more information on getting connected, see How to Get Connected.
Once connected to a database, RazorSQL provides two backup tools. There is the DB Tools -> Backup -> Backup Table tool for backing up a single table. This option is also available in the right-click menu of the database navigator. The backup table option generates the Create and/or Alter Table DDL for the selected table, and also generates an SQL insert statement for each row in the table.
Please note that the DDL generated by the backup tool may not contain all database specific attributes such as physical or storage properties.
RazorSQL also provides a Backup Database / Schema tool available in the DB Tools -> Backup menu. This option allows users to backup an entire database or schema. Depending on the database, the following objects are supported:
- Tables
- Views
- Indexes
- Stored Procedures
- Stored Functions
- Triggers
- Packages and Package Bodies
The backup Database / Schema option generates the DDL Create and/or Alter statements for each object selected. For tables and views, it also generates an SQL insert statement for each row in every table.
Please note that the DDL generated by the backup tool may not contain all database specific attributes such as physical or storage properties.
