Migrate data from Azure to AWS

Moneeka Maan (US) 0 Reputation points
2024-06-14T09:00:54.2566667+00:00

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:

"GRANT VIEW SERVER STATE TO dms_user;"

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,

Moneeka

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