Export to Database window

You can save MobiLink Monitor data to any consolidated database supported by MobiLink or to Microsoft Excel spreadsheets using the Export to Database window. You must be disconnected from the MobiLink server when you export data from the MobiLink Monitor.

Note

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:

This window has the following components:

  • Master table   Type a name for the master table created to hold MobiLink Monitor data. The table name must be 128 characters or less. By default this table is called mlm_by_sync. If the table does not exist, it is created by the MobiLink 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 MobiLink Monitor Details Table pane, an export_time column that contains the time the export was performed, and a server column that contains the MobiLink server name. Its primary key consists of the export_time, server, and sync columns.

  • Details table   Type a name for the details table created to hold MobiLink 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 MobiLink 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 properties window in the MobiLink Monitor, the export time, and the MobiLink server name. The details table has a foreign key relationship to the master table's export_time, server and sync columns. The primary key for the details table consists of the export_time, server, sync, and table_name columns.

  • Diagnostics table   Type a name for the diagnostics table created to hold synchronization warning and error messages. The table name must be 128 characters or less. By default this table is called mlm_diagnostic. If the table does not exist, it is created by the MobiLink Monitor. For Excel output, the table name identifies the worksheet that is created.

    This table contains a row for each warning or error message for each synchronization, and has columns for the type of message (1 for a warning or 2 for an error), the message text (truncated to 1024 characters if the message is longer), the export time, the MobiLink server name, the synchronization number, and a column named index in case the synchronization has more than one message. The primary key for the diagnostic table consists of the export_time, server, sync, and index columns. The details table has a foreign key relationship to the master table's export_time, server, and sync 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.

 See also