Introducing SQL Anywhere Studio
  Tutorial: Replicating Data with SQL Remote
    Lesson 2: Set up the consolidated database

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. This is a file sharing method, where the messages are left in a file on disk, and read by the intended recipient. SQL Remote also supports ftp and e-mail protocols.

• An address for this message link, to identify the source of outgoing messages. In this tutorial we use a file path to specify where the messages will be left.

Message types are created in all new databases, but you do need to supply an address for the message type you will use.

Add an address to a message type

1. From Sybase Central, connect to the sample database as user ID DBA using the password SQL, and open the sample database container (asademo) in the left pane.

2. Click the SQL Remote Users folder in the left pane.

3. Click the Message Types tab in the right pane.

4. Right-click the FILE message type, and choose Properties.

5. Enter a publisher address to provide a return address for remote users. The publisher address is the directory you created in Lesson 1 to hold messages for the consolidated database (DBA). For example, c:\tutorial\DBA.

6. Click OK to save the message type.