MBO data cache copy utility

The data cache copy utility makes it easier to migrate mobile business objects (MBOs) to a new version of an MBO package.

When a new version of a mobile deployment package is deployed, some of the MBOs may not have changed, but new tables are created for the new package nonetheless. This can make populating MBO cache tables in a new package time consuming when there is a lot of data. The data cache copy utility allows you to quickly copy the cached data of unchanged MBOs from the previous MBO cache tables across to the new ones, thus avoiding the data change notification (DCN) bulk loading for the unchanged MBOs.

You can also use the utility to customize the generated SQL for MBOs that have been changed in these ways:

An attribute has been added (with customization you can specify an appropriate default value).
The attribute data type has changed (with customization you will be able to add CONVERT() or similar transformations around the source).
An existing relationship to another MBO has changed.
A new relationship to a previously existing MBO has been added.

Note: Use the dbisql.exe utility included with Sybase Unwired Platform to run the generated SQL scripts. The scripts use quoted identifiers, semicolon query delimiters, and a commenting style that is best supported by dbisql.exe.