Migrating T-SQL features

This chapter provides reference information for T-SQL extensions required to migrate from Microsoft SQL Server 2019 to Amazon Aurora MySQL. You can gain a comprehensive understanding of the differences and similarities between these two database systems across multiple areas, including collation and character sets, cursors, date and time functions, string functions, database and schema concepts, transaction handling, SQL syntax, stored procedures, error handling, flow control, full-text search, graph databases, XML and JSON support, and more.

Topics

• Collations for T-SQL
• Cursors for T-SQL
• Date and time functions for T-SQL
• String functions for T-SQL
• Databases and schemas for T-SQL
• Transactions for T-SQL
• DELETE and UPDATE FROM for T-SQL
• Stored procedures for T-SQL
• Error handling for T-SQL
• Flow control for T-SQL
• Full-text search for T-SQL
• SQL server graph features for T-SQL
• JSON and XML for T-SQL
• MERGE for T-SQL
• PIVOT and UNPIVOT for T-SQL
• Synonyms for T-SQL
• SQL Server TOP and FETCH and MySQL LIMIT for T-SQL
• Triggers for T-SQL
• User-defined functions for T-SQL
• User-defined types for T-SQL
• Identity and sequences for T-SQL
• Managing statistics for T-SQL