Use the MobiLink plug-in to create a MobiLink project for your consolidated database if you have not already created one.

See Creating a MobiLink project.

In the Folders view of Sybase Central, expand MobiLink 12 and your MobiLink project name, and then click Synchronization Models.

From the File menu, click New » Synchronization Model to start the Create Synchronization Model Wizard.

From the Welcome page, choose a name for your synchronization model. Your model is stored as a .mlsm file in the project directory. Click Next.

On the Primary Key Requirements page, select the three checkboxes and then click Next. For more information about primary keys, see Unique primary keys.

On the Consolidated Database Schema page, select the consolidated database for obtaining your consolidated database schema from the list, and then click Next. The schema from the consolidated database is loaded.

If you chose an Oracle database, you may be prompted to choose a subset of owners because loading schema for all owners can take a long time.

The Remote Database Schema page appears. You can create your remote database schema based on the consolidated database schema or an existing remote database. The existing remote database can be SQL Anywhere or UltraLite. For help deciding, see Remote schemas.

Follow the remaining instructions in the Create Synchronization Model Wizard. Default recommendations based on best practices are used where possible.

Click Finish.