Managing SQL Remote systems

You deploy and administer a SQL Remote system from the consolidated database.

 Deploy and administer a SQL Remote system

  1. Set up the consolidated database.

    See Creating SQL Remote systems.

  2. Review and test your SQL Remote system.

    Thorough testing of your SQL Remote system should be done before deployment, especially if you have a large number of remote databases.

  3. Create remote databases and deploying the design.

    As the DBA of the consolidated database, you deploy SQL Remote by:

    1. Creating a SQL Anywhere database for each remote user, with their own initial copy of the data, and starting their subscriptions. See Remote database extraction.

    2. Installing on each remote user's computer the SQL Anywhere database server, the remote database, SQL Remote, and the client application. See Embedded database application deployment and SQL Remote deployment.

  4. Run the SQL Remote Message Agent (dbremote) to exchange messages.

    To exchange messages, you need to:

    1. Decide whether to run the SQL Remote Message Agent (dbremote) in continuous mode or batch mode on the consolidated and remote databases. See SQL Remote Message Agent (dbremote) modes.

    2. Ensure that the system is properly configured with correct user names, SQL Remote Message Agent (dbremote) connection strings, permissions, and so on. See SQL Remote Message Agent (dbremote).

  5. Manage messages.

    Use the Guaranteed Message Delivery System to manage the messages being sent back and forth among many databases. See Guaranteed Message Delivery System.

  6. Improve performance.

    See SQL Remote performance.

  7. Implement a backup and recovery strategy.

    You must create and implement a backup and recovery strategy for the consolidated database. See SQL Remote system backups.

  8. Handle errors.

    See Replication error reporting and handling.

  9. Upgrade the software and database schemas as required.

    See Upgrades and resynchronization.

Remote database extraction
Remote database extraction to a reload file
SQL Remote Message Agent (dbremote)
SQL Remote performance
Guaranteed Message Delivery System
Message size
SQL Remote message systems
SQL Remote system backups
Recovering consolidated databases manually
Recovering consolidated databases automatically
Replication error reporting and handling
Security
Upgrades and resynchronization
SQL Remote passthrough mode
Subscription resynchronization

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