Migrate data from Azure to AWS

Moneeka Maan (US) 0 Reputation points

Hi Team,

We are trying to migrate data from Azure to AWS.

We are using AWS DMS to connect to the source which is Azure (Microsoft Azure SQL Data Warehouse - 10.0.34903.0 Jan 22 2024 23:17:20 Copyright (c) Microsoft Corporation) but we are getting below error:

Test Endpoint failed: Application-Status: 1020912, Application-Message: Failed to get indication whether cdc is enabled. No data returned., Application-Detailed-Message: RetCode: SQL_ERROR SqlState: 42000 NativeError: 15165 Message: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Could not find object 'rdsadmin' or you do not have permission. Line: 1 Column: -1

We tried giving the permissions for full load, but while executing below query we are again getting error:


Error: "Securable class "server" not supported in the server scope in this version of SQL Server"

Can someone please help me with below queries :

Is there a limitation or restriction from Azure side that Microsoft Azure SQL Data Warehouse cannot be used as a source ?

Is it mandatory to have cdc_enabled at Azure end to be able to connect via DMS, even if we are using only full load ?

Is there any alternate query for "GRANT VIEW SERVER STATE TO dms_user;" which we can use to provide this access ?

Thank you,


Not Monitored
Not Monitored
Tag not monitored by Microsoft.
37,536 questions
{count} votes