Menu
AWS Schema Conversion Tool
User Guide (Version 1.0)

Conversion Issues with DDL

Issue 7675: PostgreSQL doesn't support sorting options (ASC | DESC) for constraints

Remove these options from indexes and constraints.

Issue 7681: PostgreSQL doesn't support clustered indexes

Use nonclustered indexes.

Issue 7682: PostgreSQL doesn't support the INCLUDE option in indexes

Use the index without this option.

Issue 7781: PostgreSQL doesn't support the PAD_INDEX option in indexes

Use the index without this option.

Issue 7782: PostgreSQL doesn't support the SORT_IN_TEMPDB option in indexes

Use the index without this option.

Issue 7783: PostgreSQL doesn't support the IGNORE_DUP_KEY option in indexes

Use the index without this option.

Issue 7784: PostgreSQL doesn't support the STATISTICS_NORECOMPUTE option in indexes

Use the index without this option.

Issue 7785: PostgreSQL doesn't support the STATISTICS_INCREMENTAL option in indexes

Use the index without this option.

Issue 7786: PostgreSQL doesn't support the DROP_EXISTING option in indexes

Use the index without this option.

Issue 7787: PostgreSQL doesn't support the ONLINE option in indexes

Use the index without this option.

Issue 7788: PostgreSQL doesn't support the ALLOW_ROW_LOCKS option in indexes

Use index without this option.

Issue 7789: PostgreSQL doesn't support the ALLOW_PAGE_LOCKS option in indexes

Use index without this option.

Issue 7790: PostgreSQL doesn't support the MAXDOP option in indexes

Use index without this option.

Issue 7791: PostgreSQL doesn't support the DATA_COMPRESSION option in indexes

Use index without this option.

Issue 7679: PostgreSQL doesn't support computed columns

Try using a trigger instead.

Issue 7680: PostgreSQL doesn't support global temporary tables

Use local temporary or regular tables.

Issue 7812: Temporary table must be removed before the end of the function

Review your transformed code and modify it if necessary.

Issue 7825: The default value for a DateTime column removed

Review generated code and modify it if necessary.

Issue 7776: Automatic migration of inline functions not supported

Perform a manual conversion.