CODEWITHSUNDEEP
azureazure-cosmosdbazure-sql-server
Sumeth MK
Sumeth MK

Reputation: 1

SQL Server to Azure Cosmos DB Migration

Please let me know whether we can migrate stored procedure from Microsoft SQL server to Microsoft Azure Cosmos DB ? Either with DocumentDB migration tool or any other tool

Upvotes: 0

Views: 727

Answers (1)

David Makogon
David Makogon

Reputation: 71028

There's really no direct correlation between the two: Stored procedures within the two databases are completely different. No possible way to migrate them, aside from you doing a complete rewrite. SQL Server stored procedures are written in SQL, vs Cosmos DB's JS-based stored procedures. Plus there is the notion of partitions, context, etc.

And Cosmos DB doesn't offer SQL Server compatibility and isn't a relational database. The Core (SQL) API takes advantage of SQL query language, but only for queries.

Upvotes: 2

Related Questions