Backing up Production database data

Owned by Noreen Dertinger
Last updated: Mar 15, 2023
1 min read

Transferred from CAMIS How-to’s. These instructions are based on TOAD.


Backup Production data prior to making changes:


IMPORTANT: Before updating any data, backup the result set, returned by the script, to your local drive. Once the change is approved and moved to 'Done” you can copy the backup to the relevant shared location.

IMPORTANT: Before updating any data, backup the result set, returned by the script, to your local drive. Once the change is approved and moved to 'Done” you can copy the backup to the relevant shared location.

  1. To backup the data from TOAD:

    • right click anywhere in the result set (rows that were returned).

    • Select export data from the “pop-up” menu”.
      Settings highlights:

      • Export format: Excel file.

      • Output: set the path and filename for the file you will be saving.

      • In the Date format section, I recommend enabling the the checkbox “Hide time portion if zero
        Example settings (TOAD).