Export to External Database

Before exporting to an external database, ensure that the following conditions are satisfied:

• The external database and Aurea CRM database must be of the same database type (MS SQL or Oracle).
• For Oracle databases, the same character set (NLS_CHARACTERSET) must be used as in the Aurea CRM database. The character set used by the Aurea CRM database is specified in the mmdb.ini file using MM_NLS_CHARSET.
• MS SQL databases can use a different character set from the Aurea CRM database. In this case, enable the Perform translation for character data option in the ODBC connection.
  Note: Aurea recommends that you exhaustively test the transformations applied to the character data.