You can save MobiLink Monitor data to any consolidated database supported by MobiLink, or to Excel spreadsheets using the Export to Database dialog. You must be disconnected from the MobiLink server when you export data from the Monitor.
The data source must have quoted identifiers enabled because some of the columns are reserved words. The MobiLink Monitor enables quoted identifiers automatically for SQL Anywhere, Adaptive Server Enterprise, and Microsoft SQL Server databases. If quoted identifiers is not enabled, the export fails.
For more information about quoted identifiers, see:
The Export to Database dialog has the following components:
Master table Type a name for the master table created to hold Monitor data. The table name must be 128 characters or less. If the table does not exist, it is created by the Monitor. For Excel output, the table name identifies the worksheet that is created.
This table contains one row per synchronization, including all the information that can appear in the Monitor's Details Table pane, as well as an export_time column that contains the time the export was performed. Its primary key consists of the export_time and sync columns. By default this table is called mlm_by_sync.
Details table Type a name for the details table created to hold Monitor data. The table name must be 128 characters or less. By default this table is called mlm_by_table. If the table does not exist, it is created by the Monitor. For Excel output, the table name identifies the worksheet that is created.
This table contains one row per table per synchronization, and has a column for each upload, download, and synchronization statistic that appears on the Synchronization property sheet in the Monitor, as well as an export_time column that contains the time the export was performed. The details table has a foreign key relationship to the master table's export_time and sync columns. The primary key for the details table consists of the export_time, sync, and table_name columns.
Overwrite any existing data Select this option if you want to overwrite data in existing tables. If you do not choose to overwrite the data, new data is appended to existing data.