Consolidated databases

New setup procedures

Setup script required by SQL Anywhere consolidated databases You must now run a setup script before using a SQL Anywhere database as a MobiLink consolidated database, and the MobiLink system tables that are created with the setup script are now owned by the user who ran the setup script. This behavior is consistent with other consolidated database types. In previous versions of MobiLink, MobiLink system tables were owned by DBO in SQL Anywhere consolidated databases.
See SQL Anywhere consolidated database.
Simplified setup procedures You can now set up your consolidated database in Sybase Central or using setup scripts. Previously, you had to run a setup script. In addition, each type of consolidated database now has only one setup script. There are no more version-specific setup scripts (such as syncase125.sql).
See MobiLink consolidated databases.

New system objects

New ways to clean up MobiLink system tables on your consolidated database New system procedures have been added that help you do the following:
- Purge information about obsolete remote databases from the MobiLink system tables.
  
  See ml_delete_sync_state_before system procedure.
- Delete unused or unwanted synchronization state information.
  
  See ml_delete_sync_state system procedure.
- Reset synchronization state information.
  
  See ml_reset_sync_state system procedure.
New MobiLink server system tables and schema Following are changes to the MobiLink system tables:
- Several new MobiLink system tables have been added:
  - ml_database
  - ml_column
  - ml_qa_clients
- The contents of ml_subscription are significantly different. The UltraLite synchronization sequence number, previously stored in ml_user.commmit_state, is now stored in ml_subscription.progress. The progress column also stores the SQL Anywhere remote synchronization progress.
- The contents of ml_user are significantly different.
- A checksum column has been added to the ml_script table.
- The ml_user column of ml_listening has been changed to the name column.
- A new system table has been added that is used internally by Sybase Central for server-initiated synchronization.
- There have been changes to several QAnywhere system tables. See:
  - ml_qa_delivery
  - ml_qa_delivery_client
  - ml_qa_global_props
  - ml_qa_global_props_client
  - ml_qa_repository
  - ml_qa_repository_client
  - ml_qa_repository_props
  - ml_qa_repository_props_client
  - ml_qa_repository_staging
New system procedure ml_add_column When you are using named row parameters, you may need to use this new system procedure to populate the ml_column MobiLink system table with information about columns on the remote database.
See ml_add_column system procedure.

Discuss this page in DocCommentXchange.