Lesson 14: Create a synchronization profile

When using central administration you must use a synchronization profile for synchronization. A synchronization profile is a named list of synchronization options that is stored in the remote database. If you are adding central administration to existing synchronization system and your remote database already contains a synchronization profile, you can skip this lesson.

 To create a synchronization profile

  1. The first step is to create a new remote task. In the Folders view of Sybase Central under Central Admin Tutorial, right-click Remote Tasks and choose New » Remote Task. The Create Remote Task Wizard appears.

  2. On the Welcome page, type Create Sync Profile in the Name field. Check This Task Requires or Creates a Remote Database and select the remote schema name Tutorial Application v1.0. This identifies the remote database that the database actions in this task will act on. Click Next.

  3. On the Trigger Mechanisms page, check When it is Received by an Agent then click Finish to complete the wizard.

  4. Click on the newly created Create Sync Profile task in the Folders view.

  5. Add a single command to the task that executes the necessary SQL to create the synchronization profile. Set the Command Type to Execute SQL. In the SQL box enter the following: 

    CREATE SYNCHRONIZATION PROFILE normal_sync 'subscription= tutorial1'

    This creates a synchronization profile named normal_sync. The only option specified in the profile is the name of the subscription to synchronize.

  6. The remote task is now complete. Deploy the task and assign it to the agent AID_JOHN:

    1. Right-click on the Create Sync Profile task in the Folders view and choose Deploy. The Deploy Remote Task Wizard is displayed.

    2. Accept the defaults on the Task Name and Destination page and click Next.

    3. From the Recipients dropdown, select Specific Agents. In the Agent list, select AID_JOHN and click Next.

    4. On the Delivery Options page, check The Next Time the Agent Synchronizes and click Next.

    5. On the Reporting Results and Status page, check Send Results and Status Immediately for both questions.

    6. Click Finish.

Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0