Skip to main content

database_migrations_mongo_to_cosmos_db_ru_mongo

Creates, updates, deletes, gets or lists a database_migrations_mongo_to_cosmos_db_ru_mongo resource.

Overview

Namedatabase_migrations_mongo_to_cosmos_db_ru_mongo
TypeResource
Idazure.data_migration.database_migrations_mongo_to_cosmos_db_ru_mongo

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
idstring
namestring
propertiesobjectDatabase Migration Resource properties for CosmosDb for Mongo. (x-ms-discriminator-value: MongoToCosmosDbMongo)
systemDataobjectMetadata pertaining to creation and last modification of the resource.
typestring

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectresourceGroupName, targetResourceName, migrationName, subscriptionIdGet Database Migration resource.
createinsertresourceGroupName, targetResourceName, migrationName, subscriptionIdCreate or Update Database Migration resource.
deletedeleteresourceGroupName, targetResourceName, migrationName, subscriptionIdforceDelete Database Migration resource.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription
migrationNamestringName of the migration.
resourceGroupNamestringName of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.
subscriptionIdstringSubscription ID that identifies an Azure subscription.
targetResourceNamestringThe name of the target resource/account.
forcebooleanOptional force delete boolean. If this is provided as true, migration will be deleted even if active.

SELECT examples

Get Database Migration resource.

SELECT
id,
name,
properties,
systemData,
type
FROM azure.data_migration.database_migrations_mongo_to_cosmos_db_ru_mongo
WHERE resourceGroupName = '{{ resourceGroupName }}' -- required
AND targetResourceName = '{{ targetResourceName }}' -- required
AND migrationName = '{{ migrationName }}' -- required
AND subscriptionId = '{{ subscriptionId }}' -- required
;

INSERT examples

Create or Update Database Migration resource.

INSERT INTO azure.data_migration.database_migrations_mongo_to_cosmos_db_ru_mongo (
data__properties,
resourceGroupName,
targetResourceName,
migrationName,
subscriptionId
)
SELECT
'{{ properties }}',
'{{ resourceGroupName }}',
'{{ targetResourceName }}',
'{{ migrationName }}',
'{{ subscriptionId }}'
RETURNING
id,
name,
properties,
systemData,
type
;

DELETE examples

Delete Database Migration resource.

DELETE FROM azure.data_migration.database_migrations_mongo_to_cosmos_db_ru_mongo
WHERE resourceGroupName = '{{ resourceGroupName }}' --required
AND targetResourceName = '{{ targetResourceName }}' --required
AND migrationName = '{{ migrationName }}' --required
AND subscriptionId = '{{ subscriptionId }}' --required
AND force = '{{ force }}'
;