Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How do I change API in cosmosDB?

I have a cosmosDB with mongo API, however there are many features not supported in this API so I want to switch to SQL API?

like image 885
Jeffrey C Avatar asked Jul 22 '19 09:07

Jeffrey C


People also ask

Which API is best for Cosmos DB?

Cassandra API is wire protocol compatible with the Apache Cassandra. You should consider Cassandra API if you want to benefit the elasticity and fully managed nature of Azure Cosmos DB and still use most of the native Apache Cassandra features, tools, and ecosystem.

Can I use multiple APIs to access the data in Cosmos DB?

Can I use multiple APIs to access my data? Azure Cosmos DB is Microsoft's globally distributed, multi-model database service. Where multi-model means Azure Cosmos DB supports multiple APIs and multiple data models, different APIs use different data formats for storage and wire protocol.

Which APIs are supported by Cosmos DB?

Azure Cosmos DB offers multiple database APIs, which include the Core (SQL) API, API for MongoDB, Cassandra API, Gremlin API, and Table API.

Which type of database API is not supported by Cosmos DB?

CosmosDB: Sql api is not supported for this database account - Hosting (OnPremise) - Squidex Support.


1 Answers

As things stand today it is not possible to switch you account from one type to another.

This is what you need to do if you need to switch to the SQL API:

  1. Create a SQL API Cosmos DB Account
  2. Download the Cosmos DBmigration tool
  3. Migrate all the data from the MongoDB account to the SQL API account
  4. Delete the MongoDB account
like image 136
Nick Chapsas Avatar answered Sep 19 '22 14:09

Nick Chapsas