question

nithishreddyminupuri-8171 avatar image
0 Votes"
nithishreddyminupuri-8171 asked OuryBa-MSFT edited

Can you migrate your data from sql server to Gremlin API cosmos DB

I need to migrate my relational data in SQL Server to Azure Cosmos DB . Do i have any tool for it ?

azure-cosmos-db
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

OuryBa-MSFT avatar image
0 Votes"
OuryBa-MSFT answered OuryBa-MSFT edited

Hi @nithishreddyminupuri-8171 Azure Cosmos DB migration strategies currently differ based on the API choice and the size of the data.
Graph bulk executor library
Gremlin Spark

You could use these to ingest data but you're going to have to refactor the data model to move from relational database tables to a graph
they would work with any source but you wouldn't be able to keep the data model as-is since you're moving to a graph

The Data Migration tool isn't a supported import tool for Gremlin API accounts at this time. Learn about migration options for importing data into Gremlin API


Regards,
Oury


· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @nithishreddyminupuri-8171 Checking if the above answer was helpful. If yes, please mark as accepted answer . Otherwise let us know how we can better assist.

Regards,
Oury

0 Votes 0 ·

Is there a Cosmos DB (Gremlin API) connector on the roadmap for Azure Data Factory?

This would clearly be the most logical option...

0 Votes 0 ·

Hi @CorySeaman-6081 You can use SQL API one to push data to Gremlin API. We support both the endpoints on same account.
We don't have a roadmap for now. As soon as it is implemented we will be updating it on this thread or the Cosmos DB gremlin API documentation

Regards,
Oury

0 Votes 0 ·