6. Firmware Upgrade and Configuration Management
ROS® v3.11User Guide
110
RMC30
6.6.1. Backing Up Files Using SFTP
This method requires that SFTP client software be available on a computer with a network
connection to the ROS® device that one wishes to back up. Establish an SFTP connection
with administrative privileges to the ROS® device. Begin transferring the desired file from the
device. An example of using an SFTP session to create a local backup of the ROS® main
firmware image to a Linux workstation follows:
user31host$ sftp admin31ros_ip
Connecting to ros_ip...
admin31ros_ip's password:
sftp> get main.bin
Downloading /main.bin
main.bin 100% 2139KB 48.7KB/s 00:44
sftp>
All files in ROS® may be backed up using an SFTP session with administrative privileges.
6.7. Using SQL Commands
The ROS® provides an “SQL-like” command facility that allows expert users to perform several
operations not possible under the user interface, namely:
• Restoring the contents of a specific table, but not the whole configuration, to their factory
defaults.
• Search tables in the database for specific configurations.
• Make changes to tables predicated upon existing configurations.
When combined with RSH, SQL commands provide a means to query and configure large
numbers of devices from a central location.
6.7.1. Getting Started
SQL information is obtainable via the CLI shell “SQL” command:
>sql
The SQL command provides an 'sql like' interface for manipulating all system
configuration and status parameters. Entering 'SQL HELP command-name' displays
detailed help for a specific command. Commands, clauses, table, and column
names are all case insensitive.
DEFAULT Sets all records in a table(s) to factory defaults.
DELETE Allows for records to be deleted from a table.
HELP Provides help for any SQL command or clause.
INFO Displays a variety of information about the tables in the database
INSERT Allows for new records to be inserted into a table.
SAVE Saves the database to non-volatile memory storage.
SELECT Queries the database and displays selected records.
UPDATE Allows for existing records in a table to be updated.
6.7.2. Finding the Correct Table
Many SQL commands operate upon specific tables in the database, and require the table
name to be specified. Navigating the menu system to the desired menu and pressing <Ctrl-