Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » SQL Remote » Managing SQL Remote systems


SQL Remote passthrough mode

Use passthrough mode to pass standard SQL statements to a remote database where they can be executed.

You must have the SYS_RUN_REPLICATION_ROLE system role.

You can use passthrough mode to complete the following tasks on a running SQL Remote system:

  • SQL Remote relies on each database in the system having the same objects; when a table is altered at some sites but not at others, attempts to replicate data changes fail. Additional schema changes executed on a running SQL Remote system might cause problems.

  • Test your passthrough operations on a copy of the consolidated database with a copy of a remote database subscribed. Never run untested passthrough scripts on a production database.

  • Qualify object names with the owner name. PASSTHROUGH statements are not executed on remote databases from the same user name. Object names without the owner name qualifier may not be resolved correctly.

 See also

Passthrough mode limitations
Start and stop passthrough mode