SQL Remote behavior changes and deprecated features

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

  • LOAD TABLE now optionally logs loaded rows as inserts   The new clause WITH ROW LOGGING means that SQL Anywhere remote databases can now load data using the LOAD TABLE statement. Previously, LOAD TABLE was not always useful in a synchronization or replicating environment because the rows were not logged and so they were ignored by dbremote or dbltm. See Import data with the LOAD TABLE statement.

  • VIM and MAPI message types unsupported   Support for the VIM and MAPI message systems has been removed in this release. When you upgrade a database that uses VIM or MAPI to SQL Anywhere version 11.0.0, you must change the message type to File, FTP, or SMTP. Dbremote.exe does not start if the message type is MAPI or VIM.

    The simplest change is to switch to SMTP/POP; changing message types may require a change to your mail server to support SMTP/POP.

    For more information about choosing a SQL Remote message type, see SQL Remote message systems.