# Migrating ANSI SQL features
<a name="chap-sql-server-aurora-pg.sql"></a>

This topic provides conceptual content comparing various database features and functionalities between Microsoft SQL Server 2019 and Amazon Aurora PostgreSQL. You can gain valuable insights into the similarities and differences in areas such as object naming conventions, SQL constraints, table creation, Common Table Expressions (CTEs), data type compatibility, derived tables, grouping operations, join operations, temporal tables, views, and window functions. Understanding these concepts is crucial for database administrators and developers planning a migration from SQL Server to Aurora PostgreSQL. By familiarizing yourself with these comparisons, you can anticipate potential challenges, make informed decisions about database migration strategies, and ensure a smooth transition of your database operations and applications to the new PostgreSQL environment.

**Topics**
+ [Case sensitivity differences for ANSI SQL](chap-sql-server-aurora-pg.sql.casesensitivity.md)
+ [Constraints for ANSI SQL](chap-sql-server-aurora-pg.sql.constraints.md)
+ [Creating tables for ANSI SQL](chap-sql-server-aurora-pg.sql.tables.md)
+ [Common table expressions for ANSI SQL](chap-sql-server-aurora-pg.sql.cte.md)
+ [Data types for ANSI SQL](chap-sql-server-aurora-pg.sql.datatypes.md)
+ [Derived tables for ANSI SQL](chap-sql-server-aurora-pg.sql.derivedtables.md)
+ [GROUP BY for ANSI SQL](chap-sql-server-aurora-pg.sql.groupby.md)
+ [Table JOIN for ANSI SQL](chap-sql-server-aurora-pg.sql.tablejoin.md)
+ [Temporal tables for ANSI SQL](chap-sql-server-aurora-pg.sql.temporaltables.md)
+ [Views for ANSI SQL](chap-sql-server-aurora-pg.sql.views.md)
+ [Window functions for ANSI SQL](chap-sql-server-aurora-pg.sql.windowfunctions.md)