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:

Add new users.

Resynchronize users.

Delete users from the system.

Change the address, message type, or frequency for a remote user.

Add a column to a table.

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.