Understanding SAP ASE (Sybase ASE) to PostgreSQL conversion settings - Amazon Database Migration Service
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

Understanding SAP ASE (Sybase ASE) to PostgreSQL conversion settings

SAP ASE (Sybase ASE) to PostgreSQL conversion settings in DMS Schema Conversion include the following:

  • To convert applicable database objects using generative AI enable the Generative AI setting. Objects successfully converted using generative AI will be clearly identified with Action Item 3077, which states: "This conversion uses machine learning models that generate predictions based on patterns in data." For more information, see Converting database objects with generative AI.

  • Comments in converted SQL code: This setting includes comments in the converted code for the action items of the selected severity and higher. This setting supports the following values:

    • Errors only

    • Errors and warnings

    • All messages

  • You can define the template to use for the schema names in the converted code. For Schema names, choose one of the following options:

    • DB – Uses the SAP ASE (Sybase ASE) database name as a schema name in PostgreSQL.

    • SCHEMA – Uses the SAP ASE (Sybase ASE) schema name as a schema name in PostgreSQL.

    • DB_SCHEMA – Uses a combination of the SAP ASE (Sybase ASE) database and schema names as a schema name in.

  • You can keep the exact case of object names from your source database. To do so, select Treat source database object names as case sensitive. When this option is turned off, all database object names are converted to lowercase.

  • You can avoid casting operands to lowercase during case-insensitive operations. DMS Schema Conversion will not apply the LOWER function to operands in the converted code. To do so, select Avoid casting operands to lowercase for case-insensitive operations. When this option is not selected (default), DMS Schema Conversion automatically applies the LOWER function to convert operands to lowercase before performing case-insensitive comparisons.

  • In SAP ASE (Sybase ASE), you can create indexes with identical names across different tables. PostgreSQL requires all index names within a schema to be unique. To ensure Amazon Schema Conversion creates unique index names during migration, select Generate unique names for indexes. This option automatically adds prefixes to index names to prevent naming conflicts in your target PostgreSQL database.