Data Replication with SQL Remote
PART 1. Introduction to SQL Remote
CHAPTER 5. A Tutorial for Adaptive Server Enterprise Users
The remote database needs to be created and configured in order to send and receive messages and participate in a SQL Remote setup.
Like the consolidated database, the remote database needs a publisher (in this case, the field_user user ID) to identify the source of outgoing messages, and it needs to have hq_user identified as a user with consolidated permissions. It needs the SalesRepData publication to be created and needs a subscription created for the hq_user user ID.
The remote database also needs to be synchronized with the consolidated database; that is, it needs to have a current copy of the data in order for the replication to start. In this case, there is no data in the publication as yet.
The database extraction utility enables you to carry out all the steps needed to create a remote database complete with subscriptions and required user IDs.
You need to extract a database from the consolidated database for remote user field_user.
To extract a database:Click the Remote Users folder, which is in the SQL Remote folder.
Right-click the field_user remote user, and select Extract Database from the popup menu. The Extraction Wizard is displayed.
Use the user ID and password that you have used to create the tables and users in the database.
On the next page, check Start Subscriptions Automatically, for user field_user. Also, check Create New Remote Database. Adaptive Server Anywhere must be installed for Create New Remote Database to be available.
Create the database as file c:\tutorial\field.db, using a transaction log in the same directory.
Choose to extract all parts of the schema (the default setting). Leave the other options at their default settings, and create the remote database.
You should connect to the field database as DBA and confirm that all the database objects are created.
To connect to and inspect the remote database:From Sybase Central, choose Tools->Connect->Sybase Adaptive Server Anywhere.
Provide the user ID DBA and the password SQL. These must be typed in upper case, as the database was created as case sensitive. Select the field.db file, and connect.
Open the database container, and confirm that the tables and user names are present.
In a proper SQL Remote setup, the remote database field would need to be loaded on to the computer using it, together with an Adaptive Server Anywhere server and any client applications required. For this tutorial, we leave the database where it is and use isql to input and replicate data.
The system is now ready for replication.
For the next step, inserting and replicating data, see the section Start replicating data.