The Local Storage feature allows you to store data locally in an embedded database. You can store data as a table or as a snapshot. Store data in existing objects or create new objects and databases.
Snapshots
A snapshot contains data from a table, a view, or the results of a query, retrieved at a specific point in time. Snapshots can then be refreshed to reflect the current data from the source database object/objects. Upon refresh, the original actions used to create the snapshot are re-executed on the current data from the source database object or objects. Local Storage snapshots are a convenient way to retrieve current data from a source and reapply a set of predefined actions—all with one click.
Advanced Analytics
If you plan to analyze data using Toad's Advanced Analytics functions, you must first store that data in Local Storage. Advanced Analytics
To save data to Local Storage
Do one of the following:
You can choose to store data in a single existing table, a single new table, or a snapshot. Specify database, table, and column options. Review the following for additional information:
A snapshot | Description |
Database |
Select an existing database, or create a new database by entering a name. If this is the first time you have accessed Local Storage, you must first create a new database by entering a name. Note: A database name cannot include an underscore (_) as the first character. |
Snapshot |
Enter a custom name for the snapshot. |
PK |
Click in a cell under PK to include a column in the primary key. A key icon appears to the left of the column selected for inclusion in the primary key. |
Type |
Allows you to change the column's data type and field length (if applicable). Click within the text box and select from a drop-down list, or enter a valid data type and length. |
A single existing table | Description |
Database |
Select a database. |
Table |
Select a table. |
Source field |
Use this to map columns in the source data to columns in the existing table. Select a source column on the left to map to the target column listed on the right. Map by position—Select to initially map source columns to target columns by matching their positions in the table. Map by name—Select to initially map source columns to target columns by matching their names. |
A single new table | Description |
Database |
Select an existing database, or create a new database by entering a name. If this is the first time you have accessed Local Storage, you must first create a new database by entering a name. Note: A database name cannot include an underscore (_) as the first character. |
Table |
Enter a name for the table. |
PK |
Click in a cell under PK to include a column in the primary key. A key icon appears to the left of the column selected for inclusion in the primary key. |
Type |
Allows you to change the column's data type and field length (if applicable). Click within the text box and select from a drop-down list, or enter a valid data type and length. |
To refresh a snapshot in Local Storage
The Local Storage snapshot is refreshed to reflect the current data in the source database object.
To view snapshot origination details
From time to time you may need to find the Local Storage data hub folder, for example to rename it when troubleshooting. The best way to view the location of your Local Storage is to select Tools | Options | Local Storage. The path and the folder name are listed.
Notes:
© ALL RIGHTS RESERVED. 使用条款 隐私 Cookie Preference Center