Filter
Top Products
Again, you do not need to use the property sheets.
7. Save the table.
8. In the Tables folder in the left pane, select the Customer table, then click
the Foreign Keys tab in the right pane.
9. From the File menu, choose New ➤ Foreign Key. Using the wizard, add a
foreign key to the Rep_key column of the SalesRep table. You can use
the default settings for this foreign key.
You are now ready for the rest of the tutorial.
Setting up a consolidated database
This section of the tutorial describes how to prepare the consolidated
database of a simple replication system.
Preparing a consolidated database for replication involves the following
steps:
1. Create a message type to use for replication.
2. Grant PUBLISH permissions to a user ID to identify the source of
outgoing messages.
3. Grant REMOTE permissions to all user IDs that are to receive messages.
4. Create a publication describing the data to be replicated.
5. Create subscriptions describing who is to receive the publication.
You require DBA authority to carry out these tasks.
Add a SQL Remote message type
All messages sent as part of replication use a message type. A message type
description has two parts:
♦ A message link supported by SQL Remote. In this tutorial, we use the
FILE link.
♦ An address for this message link, to identify the source of outgoing
messages.
Adaptive Server Anywhere databases already have message types created,
but you need to supply an address for the message type you will use.
34