The Data Preview page allows you to search, view, and restore backed up data. To open this page and view the backed up data for an object, on the Backup Details Page click the View link for the corresponding object.
In its upper part this page displays date and time when the backup operation started and when it was finished, the number of backed up objects and the total number of backed up records.
Below the Data pane displays the backed up data. The Data pane has two tabs: All and Changed to the left of the Data header. The All tab displays the actual data in object at the time of the backup operation. The Changed tab displays the records changed since the previous (or even earlier) backup operation.
If there were no successful backups prior to the current one for this backup package, only the All tab is displayed and the tab captions are not displayed, because there is no prior backup to compare the current one to.
The tab captions are also not displayed after you select check boxes for some objects or records. You will be able to switch between tabs again only after you clear check boxes or leave the Backup Details page and open it again.
By default, Skyvia displays 10 records per grid page. You can switch between grid data pages by clicking the corresponding buttons below the grid. The number of rows per page can be changed in the Items list.
Skyvia allows sorting and filtering the data being viewed. To sort data by values of a column, click the corresponding column header. To filter data enter some characters to the box above the grid and click the Search in current backup button or press Enter. Only the records, containing the entered string in any of their fields, will be displayed.
When viewing data, you can select and restore records from the backup. See more about data restore below.
You can also click the Details link for the record to view the record field values as a list instead of a table row, view all the related records and browse by relations on the Record Details Page.
You can navigate back to the list of the backed up objects using the browser Back button, Backspace key, or breadcrumbs:
When you view the records that were changed since the second compared backup, the State column displays the status of the record - whether it was added, deleted, or updated between backups. It can have the following states:
- the record is present in the older backup and not present in the newer one.
- the record is not present in the older backup and is present in the newer one.
- the record is present in both backups, however some of its fields were changed.
For updated records () you can see the changed fields on the Record Preview Page. For this click the Select fields link in the second column.
When comparing backups you can select and undo changes made between backups. See more about this below.
Skyvia offers two ways to restore data: using the All tab and using the Changed tab.
When you use the All tab, you need to select check boxes for the records to restore, click the Restore button, and then select the operation to perform: Insert records, Update records, or Delete records.
When you use the Changed tab, the restore operation undoes the selected changes. So you can compare two backups, then select and undo changes between them. The operation to apply is selected automatically.
For added rows (marked with in the State column) restore (undoing adding this row) means that the row will be deleted from the data source.
For deleted rows (marked with in the State column) restore (undoing deletion of this row) means that the row will be inserted to the data source.
For updated rows (marked with in the State column) restore means undoing the row update. Values from older backup will be applied.
Thus, for example, to undo the recent changes you can perform a fresh backup, compare it with one of the previous backups, select the changes you want to undo, and click Restore.
For updated records () you can select and undo the separate field changes on the Record Preview Page. For this click the Select fields link in the second column and select the fields to restore.
Skyvia offers powerful data search functionality for your backups. You can search your backed up data by a fragment of one of its fields. For example, if you want to find a specific account in your backups, you can find it by a part of its name, address, phone, etc. Data search can be the fastest way for you if you want to find and restore a specific record.
Skyvia can search data in all backups of the current backup package. If it does not find the necessary records in the current backup, you can continue search in previous backups, and get results for the most recent backup that contains such records. If these are not the results you want, you can continue search in even older backup or navigate back to results in a newer backup.
When you perform search on the All tab of the Data pane, all the records are searched, and when you perform search on the Changed tab, Skyvia searches only changed records.
To start searching data, open the data of the object to search in on the Backup Details page and enter the search string to the Search record box above the grid. Then click the Search in current backup button or press Enter. Skyvia will display the records, containing the searched string or the message that there are no records to display. You can continue search in the older backups by clicking the Search in older backup button. You can navigate back to newer backups by clicking the Search in newer backup button.