Managing Backups (OracleToSQL)

Oracle Backup Management lets you backup and restore table data before or after running a test. You can also manage the backup content with Manage Backup Contents dialog.

Oracle Backup Management

Backup

To open the backup dialog, on the Tester menu point to Oracle Backup Management, then click Backup.... In the backup dialog you will find the Oracle Metadata tree displaying all tables of the loaded Oracle schema. Select one or more tables to perform a backup.

The following buttons are available on the dialog:

  • Click the Check State button to check the table's backup state.

  • Click the Backup button to back up table's the data.

  • Click the Cancel button to close the dialog.

Restore

To open the restore dialog, on the Tester menu point to Oracle Backup Management, then click Restore.... There you will find a tree containing the tables available in backup. Select one or more tables to restore its data.

The following buttons are available on the dialog:

  • Click the Check State button to check the table's backup state.

  • Click the Restore button to restore backup data into the table.

  • Click the Cancel button to close the dialog.

Managing Backup Contents

To open Managing Backup Contents, on the Tester menu point to Oracle Backup Management, then click Backup Content.... There you will find a tree containing the tables in the backup.

The following buttons are available on the dialog:

  • Click the Check State button to check the table's backup state.

  • Click the Remove button to remove the table from the backup.

  • Click the Close button to close the dialog.

SQL Server Backup Management

SQL Server Backup Management lets you backup and restore table data before or after running a test. You can also manage the backup content with Manage Backup Contents dialog.

Backup

To open the backup dialog, on the Tester menu point to SQL Server Backup Management, then click Backup..... In the backup dialog you will find the SQL Server Metadata tree displaying all tables of the loaded SQL Server databases. Select one or more tables to perform a backup.

The following buttons are available on the dialog:

  • Click the Check State button to check the table's backup state.

  • Click the Backup button to back up the table's data.

  • Click the Cancel button to close the dialog.

Restore

To open the restore dialog, on the Tester menu point to SQL Server Backup Management, the click Restore.... There you will find a tree containing the tables available in backup. Select one or more table to restore its data.

The following buttons are available on the dialog:

  • Click the Check State button to check the table's backup state.

  • Click the Restore button to restore backup data into the table.

  • Click the Cancel button to close the dialog.

Managing Backup Contents

To open Managing Backup Contents, on the Tester menu point to SQL Server Backup Management, then click Backup Content.... There you will find a tree containing the tables in the backup.

The following buttons are available on the dialog:

  • Click the Check State button to check the table's backup state.

  • Click the Remove button to remove the table from the backup.

  • Click the Close button to close the dialog.

See Also

Testing Migrated Database Objects (OracleToSQL)