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.
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).
Purge information about obsolete remote databases from the MobiLink system tables.
Delete unused or unwanted synchronization state information.
Reset synchronization state information.
New MobiLink server system tables and schema Following are changes to the MobiLink system tables:
Several new MobiLink system tables have been added:
The contents of ml_subscription are significantly different. The UltraLite synchronization sequence number, previously stored in ml_user.commit_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:
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.
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|