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

SQL Server 2018 deprecated features list

This topic provides reference information for deprecated features from SQL Server 2018. For more information, refer to the linked topics.

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

Identity and Sequences

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