SQL Operations Guide

ctpath - Change Internal (SQL) Database Paths

The ctpath utility allows you to adjust the path in the dictionary after extracting the SQL database directory from a backup and renaming it.

Changes the internal FairCom DB SQL dictionary paths of database locations.

Syntax

ctpath [-s server] [-u user] [-p password] [-d database] [-v] from-path-prefix to-path-prefix

Options:

• -s server - FairCom DB server name
• -u user - user name
• -p pw - user password
• -d database - database name
• -v - verbose
• from-path-prefix - path prefix to be replaced
• to-path-prefix - path prefix to use as replacement

Description

• Command-line switches may not have optional spaces between the switch and the argument. Example: -s FAIRCOMS is not the same as -sFAIRCOMS.
• Command-line switches may be entered in any order, but the from-path-prefix must appear before the to-path-prefix.
• Command-line switches should start with a '-' or '/' character. Command line switches accept both lowercase and uppercase characters, e.g. -s or -S are the same.
• ctpath returns 0 when the execution detected no errors. Non-zero values are returned when errors are detected. Error messages are written to stderr.
• If you omit the -d database switch, all databases in the session will be scanned.
• The -r switch indicates to repeat the substitution and replace all occurrences of the searched path and not just the first one.
• The -v command-line switch indicates verbose output.