Database Properties window: SQL Remote tab

This tab has the following components:

  • This database has a publisher   Select this option to supply the name of the database's publisher. Selecting this option enables the Publisher field.

    • Publisher   Shows the name of the publisher for the database. You can click Change to select a publisher in the Set Publisher window.

  • This remote database has a corresponding consolidated database   Select this option if the database is acting as a remote database.

    • Consolidated user   Click Change to select the consolidated user from the list of available candidates in the Set Consolidated User window.

    • Message type   Select the message type for communicating with the publisher of the consolidated database from the dropdown list. For information about the message types supported by SQL Remote, see SQL Remote message systems.

    • Address   Provides a place for you to type the remote address of the consolidated user. The address is a string, according to the specified message type, to which the replication messages should be sent for the user.

    • Send frequency   Select one of the following options for the send frequency:

      • Send then close   Sets the replication frequency so that the Message Agent (dbremote) runs once, sends all pending messages, and then shuts down. The Message Agent (dbremote) must be restarted each time the publisher wants to send messages. This option is only useful when you are running the Message Agent (dbremote) at a remote site.

        In most replication setups, this option is not used for sending publications from the consolidated publisher to the remote group.

      • Send every   Select this option to set the replication frequency so that the Message Agent (dbremote) runs continuously, sending messages to this consolidated user at the given periodic interval. This option is useful at both consolidated and remote sites.

      • Send daily at   Select this option to set the replication frequency so that the Message Agent (dbremote) runs continuously, sending messages each day at the given time.

  • Subscribers   Shows the number of remote users subscribing to publications in the database.

  • Subscriptions   Shows the number of subscriptions to publications in the database.

  • Started subscriptions   Shows the number of subscriptions in the database that have been started.

 See also
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1