SQL Remote User's Guide
Deploying and Synchronizing Databases
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.
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:
Building an Adaptive Server Anywhere database for each remote user, with their own initial copy of the data.
Installing the database, together with the Adaptive Server Anywhere database server, the SQL Remote Message Agent, and client application, on each user's machine.
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 Adaptive Server Anywhere databases, and this chapter focuses on this case.
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 Adaptive Server Anywhere databases.
Synchronizing data Synchronization of a database is the setting up of the initial copy of data in the remote database.