SQL Remote passthrough mode

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

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

Caution
  • 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. See Changes to avoid on a running system.

  • Always 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.

  • You should always 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.


Passthrough mode limitations
Start and stop passthrough mode