Durch die Nutzung von AWS re:Post stimmt du den AWS re:Post Nutzungsbedingungen
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
    vor einem Jahr

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

  • cedhood
    vor 10 Monaten

    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
    vor 7 Monaten

    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.

Themen
Migration und ModernisierungDatenbank
Tags
AWS Datenbank-MigrationsdienstMicrosoft SQL ServerAurora PostgreSQL
Sprache
English
abarry
gefragt vor einem Jahr715 Aufrufe
3 Antworten
1
Akzeptierte Antwort

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
EXPERTE
Riku_Kobayashi
beantwortet vor einem Jahr
profile picture
EXPERTE
Giovanni Lauria
überprüft vor einem Monat
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
beantwortet vor 7 Monaten
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
beantwortet vor 6 Monaten

Du bist nicht angemeldet. Anmelden um eine Antwort zu veröffentlichen.

Eine gute Antwort beantwortet die Frage klar, gibt konstruktives Feedback und fördert die berufliche Weiterentwicklung des Fragenstellers.

Richtlinien für die Beantwortung von Fragen

Relevanter Inhalt