Data store
The Data Store module allows for creating and storing database snapshots (datasets) so that you can backup and restore them as part of your development, testing, and deployment processes.
To start working with Data Store, you should first click the Refresh button at the bottom left corner of the main field. By clicking it, the program updates the information for both the Source and Target databases.
Figure 1. Refresh button
Then, to enable Data Store functionality, you should install an extension pack for both the Source and Target databases. To do that, go to the data element you want to store, right-click on it, and select “Install extension pack“.
Figure 2. Installing extension pack
Once installed, the selected data element will display with a black checkmark and the Packages list will contain the PKG_DATASTORE package.
Creating datasets
To create a dataset, follow these steps:
- Select the objects in the metadata tree that you want to store. That can be tables or nodes that contain table nodes.
- Select the Create dataset option in the context menu of the metadata tree.
Figure 3. Create dataset option
To add new tables to an existing dataset, select proper tables in the review metadata, right-click on each of them, and click Add to dataset.
Note: You cannot create a dataset for the data objects that contain LONG datatype, VDT columns, virtual columns or global temporary tables. If a data object wasn’t added to a dataset, the Warning column will show the reason for each of them.
- In the Dataset window specify the dataset name and description.
Figure 4. Finalizing dataset creation
- Click the Save button to create a list of data objects you want to back up.
When done, the created datasets appear in the list in the main field of the Data store module.
Figure 5. List of the datasets in the Data Store module
Backing up datasets
To back up a whole dataset or certain tables, click on the pencil icon to open the Dataset windows, choose the proper tables, and click the Backup button.
When the backup operation is complete, the dataset status in the State field changes.
There can be three possible values:
- Partial backed up (checkmark with a red circle) — only a part of all the tables from a dataset was successfully restored.
- Backed up (checkmark) — all the tables from a dataset were successfully restored.
- Error (red cross) — the process wasn’t completed.
Figure 6. Backup operation completed
Restoring datasets
To restore a whole dataset or its elements, click on the pencil icon to open the Dataset window, choose the proper elements, and click the Restore button.
Removing datasets
To remove a whole dataset, click the bucket button and confirm deleting in the dialog window.
Figure 7. Deleting a dataset
To remove separate tables from a dataset, click the pencil button, select proper tables, and click Save.
Figure 8. Deleting separate dataset tables
Didn’t find the answer?
You can report problems, ask questions or share ideas for improvements on our email [email protected].