Skyvia allows creating connections to your backups. This means that you can create a connection to either a backup for a specific date or to the most recent backup from a backup package, and then use them in your Data Integration packages or query backed up data with the Query tool.
Backed up data are always read-only, so you cannot modify them. You cannot import data to your backups or synchronize them with another data source. You can use them only as Source in Import Packages or in Export Packages. In Query you also cannot execute DML statements against backup connections. Only SELECT statements are allowed.
When querying data from backup connections, you need to use SQLite syntax of SELECT statements, not the Transact-SQL.
Backup connections can either always point to the most recent backup of a backup package or to point to a backup for a specific date and time.
To create a backup connection, perform the following steps:
|1.||Open the Connections page by clicking Connections in the menu on the left side of the page.|
|2.||Сlick the New button.|
|3.||In the opened pane click Backup.|
|4.||In the opened New Connection dialog box, specify a connection Name that will be used to identify the connection.|
|5.||In the Source list select the backup package to connect to backed up data from.|
|6.||If you want to always connect to the most recent backup from the package, simply click the Save button and omit the next step. Otherwise, if you want to connect to a specific backup (for a specific date), in the Type list select Specific Date.|
|7.||In the Date list select the backup you want to connect to and click Save.|