SQL Server 2018 deprecated features list - SQL Server to Aurora PostgreSQL Migration Playbook

SQL Server 2018 deprecated features list

This topic provides reference information related to migrating from Microsoft SQL Server 2019 to Amazon Aurora PostgreSQL. It covers a range of database concepts and features that differ between the two systems, including data types, table creation, maintenance operations, and query syntax. You’ll find information on how various SQL Server constructs and functionalities map to their PostgreSQL equivalents or alternatives.

SQL Server 2018 deprecated feature Section

TEXT, NTEXT, and IMAGE data types

Data Types

SET ROWCOUNT for DML

Session Options

TIMESTAMP syntax for CREATE TABLE

Creating Tables

DBCC DBREINDEX, INDEXDEFRAG, and SHOWCONTIG

Maintenance Plans

Old SQL Mail

Database Mail

IDENTITY seed, increment, non primary key, and compound

Sequences and Identity

Stored procedures RETURN values

Stored Procedures

GROUP BY ALL, Cube, and Compute By

GROUP BY

DTS

ETL

Old outer join syntax = and =

Table JOIN

'String Alias' = Expression

Migration Quick Tips

DEFAULT keyword for INSERT statements

Migration Quick Tips