CODEWITHSUNDEEP
sqlazurenosqlazure-cosmosdbazure-data-factory
superninja
superninja

Reputation: 3401

Unable to see data after data migration from SQL Server to Azure Cosmos db

I used Azure Data Factory to migrate data from SQL Server to Azure CosmosDB. In Data Factory, it shows the status is Ready and succeeded (100%). Retry attempt is 1.

But I am not able to see any data in CosmosDB after the migration is done. It also shows an error message from CosmosDB that

"code" : 500, "body": "Detected corrupted documents without _id identifier, verify that you are only storing documents through Mongo protocol and not SQL API or DocumentDB SDK."}

A few things I did differently is that

Please let me know your thoughts. Thank you!

Upvotes: 0

Views: 367

Answers (1)

Jay Gong
Jay Gong

Reputation: 23782

From this official doc you could see Azure Cosmos DB connector supports only Cosmos DB SQL API(document db). And the type in the Dataset properties need to be set to DocumentDbCollection.

Azure Document DB and Azure Mongo DB are both NO-SQL database in the Azure Cosmos DB.However, there are many differences between them.

Hope it helps you.

Upvotes: 1

Related Questions