By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

MSSQL Server 2022 support for DMS

3

We recently upgraded SQL Server from 2016 to 2022 and we had DMS tasks with CDC that was using SQL Server as a source. These tasks are now failing and if I point the endpoint to the SQL Server 2016, the DMS tasks succeeds. I have not been able to track the the cause of the issue with cloudwatch logs, does anyone face a similar issue or is there a roadmap to when DMS will support MSSQL Server 2022.

  • Robert Love
    a year ago

    What is the result of Test Connection when pointing at 2022? FYI - Docs currently don't list support for 2022

  • cedhood
    9 months ago

    Hello "Abarry" Could you please provide your AWS customer name so that we can add your company as an influence for this request?

  • Amadou Barry
    7 months ago

    Hello cedhood, my company is SWBC. We are currently doing a lots double hopping to a lower version of MSSQL Sever to get this data into aws.

Topics
Migration & ModernizationDatabase
Tags
AWS Database Migration ServiceMicrosoft SQL ServerAurora PostgreSQL
Language
English
abarry
asked a year ago682 views
3 Answers
1
Accepted Answer

Checking the following documentation, SQL Server 2022 is not yet supported.
Also, no roadmap has been announced until it is supported.
https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.SQLServer.html

profile picture
EXPERT
Riku_Kobayashi
answered a year ago
profile picture
EXPERT
Giovanni Lauria
reviewed a month ago
1

We have the same problem. We would like to hear if we have any advancements or announcements as to when DMS will support MSSQL Server 2022. This becomes a real bottleneck for our projects and has to be solved immediately.

Melih
answered 7 months ago
0

It seems like SQL Server 2022 is now supported as Source endpoints for data migration https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Introduction.Sources.html

Amadou Barry
answered 5 months ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content