Backing up Production database data (Transferred to SharePoint)

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

Backup Production data prior to making changes:

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).
       
       

2. Open