Migrating ANSI SQL features

This chapter provides reference information for ANSI SQL operations required to migrate from Microsoft SQL Server 2019 and Amazon Aurora MySQL. You can use this information to understand the key differences and similarities in areas such as object name case sensitivity, constraint compatibility, table creation, Common Table Expressions (CTEs), data type compatibility, GROUP BY operations, table joins, views, window functions, and temporary tables.

Topics

• Case sensitivity differences for ANSI SQL
• Constraints for ANSI SQL
• Creating tables for ANSI SQL
• Common table expressions for ANSI SQL
• Data types for ANSI SQL
• GROUP BY for ANSI SQL
• Table JOIN for ANSI SQL
• Views for ANSI SQL
• Window functions for ANSI SQL
• Temporary tables for ANSI SQL