You deploy and administer a SQL Remote system from the consolidated database.
Set up the consolidated database.
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.
Create remote databases and deploying the design.
As the DBA of the consolidated database, you deploy SQL Remote by:
Creating a SQL Anywhere database for each remote user, with their own initial copy of the data, and starting their subscriptions. See Extracting remote databases.
Installing on each remote user's computer the SQL Anywhere database server, the remote database, SQL Remote, and the client application. See Deploying embedded database applications and Deploying SQL Remote.
Run the SQL Remote Message Agent (dbremote) to exchange messages.
To exchange messages, you need to:
Decide whether to run the SQL Remote Message Agent (dbremote) in continuous mode or batch mode on the consolidated and remote databases. Choosing the SQL Remote Message Agent (dbremote) mode.
Ensure that the system is properly configured with correct user names, SQL Remote Message Agent (dbremote) connection strings, permissions, and so on. See Understanding the SQL Remote Message Agent (dbremote).
Use the Guaranteed Message Delivery System to manage the messages being sent back and forth among many databases. See Understanding the Guaranteed Message Delivery System.
Implement a backup and recovery strategy.
You must create and implement a backup and recovery strategy for the consolidated database. See Backing up SQL Remote systems.
Upgrade the software and database schemas as required.
Extracting remote databases
Extracting remote databases to a reload file
Understanding the SQL Remote Message Agent (dbremote)
Improving SQL Remote performance
Understanding the Guaranteed Message Delivery System
Controlling message size
SQL Remote message systems
Backing up SQL Remote systems
Recover consolidated databases manually
Recover consolidated databases automatically
Reporting and handling replication errors
Upgrading and resynchronization
SQL Remote passthrough mode
Discuss this page in DocCommentXchange.
|Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0|