Share via

Migrate data from Azure to AWS

Moneeka Maan 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

Community Center Not monitored

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.