Behavior changes and deprecated features

Following is a list of changes to SQL Remote introduced in version 10.0.0.

  • Support for Adaptive Server Enterprise databases is removed   SQL Remote no longer supports Adaptive Server Enterprise consolidated databases. This means that ssxtract, ssremote, ssqueue, and all other SQL Remote for Adaptive Server Enterprise utilities and files are removed from the install.

    To synchronize Adaptive Server Enterprise databases, you should use MobiLink.

    For information about upgrading from SQL Remote to MobiLink, see [external link] http://www.ianywhere.com/whitepapers/migrate_to_ml.html.

  • Extract Database wizard no longer extracts legacy databases   The Extract Database wizard only works with version 10 databases.

  • Expanded values in #hook_dict   The utilities dbxtract and dbremote expose hooks and pass values as name/value pairs through a temporary table called #hook_dict. In the past, the values in the #hook_dict table were defined as VARCHAR(255). This has been increased to VARCHAR(10240).

  • Changes to Extraction utility   There are several changes to dbxtract:

    • The options -j, -k, and -x are removed.
    • New options -al and-xh are added.

    See Extraction utility.

  • Message Agent (dbremote) deprecated option   The -k option, which closed the window on completion, is deprecated. To close window on completion, use the new -qc option.

    See Message Agent.