Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.0 » SQL Remote » SQL Remote Administration » Deploying and synchronizing databases with SQL Remote


Deployment overview

When you have completed the design phase of a SQL Remote system, the next step is to create and deploy the remote databases and applications.

Deployment tasks

In some cases, deployment is a major undertaking. For example, if you have a large number of remote users in a sales force automation system, deployment involves the following steps:

  1. Building a SQL Anywhere database for each remote user, with their own initial copy of the data.
  2. Installing the database, together with the SQL Anywhere database server, the SQL Remote Message Agent, and client application, on each user's machine.
  3. Ensuring that the system is properly configured, with correct user names, Message Agent connection strings, permissions, and so on.

In the case of large-scale deployments, remote sites are most commonly SQL Anywhere databases, and this chapter focuses on this case.

Topics covered

This chapter covers the following topics:

  • Creating remote databases   Before you can deploy a SQL Remote system, you must create a remote database for each remote site.

    Most of the description focuses on creating remote SQL Anywhere databases.

  • Synchronizing data   Synchronization of a database is the setting up of the initial copy of data in the remote database.