In a SQL Remote installation, data is organized into publications for replication. To receive SQL Remote messages, a subscription
must be created for a user ID with REMOTE permissions.
If a string is supplied in the subscription, it is matched against each SUBSCRIBE BY expression in the publication. The subscriber
receives all rows for which the value of the expression is equal to the supplied string.
In SQL Remote, publications and subscriptions are two-way relationships. If you create a subscription for a remote user to
a publication on a consolidated database, you should also create a subscription for the consolidated database on the remote
database. The extraction utility carries this out automatically.