Migrating T-SQL features

This topic provides conceptual content comparing various features and functionalities between Microsoft SQL Server 2019 and Amazon Aurora PostgreSQL. You can gain valuable insights into the differences and similarities between these two database systems, which is crucial for planning and executing a successful migration. The content covers a wide range of topics, including data types, cursors, stored procedures, error handling, full-text search, and more. By understanding these concepts, database administrators and developers can anticipate challenges, identify potential workarounds, and make informed decisions when transitioning their databases and applications from SQL Server to Aurora PostgreSQL. This knowledge enables smoother migrations and helps maintain data integrity and functionality in the new PostgreSQL environment.

Topics

• Service Broker functionality for T-SQL
• SQL Server cast and convert for T-SQL
• Common Language Runtime for T-SQL
• 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
• Dynamic SQL for T-SQL
• Transactions for T-SQL
• Synonyms 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
• Triggers for T-SQL
• Top fetch for T-SQL
• User-defined functions for T-SQL
• User-defined types for T-SQL
• Identity and sequences for T-SQL