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

Name	database_migrations_mongo_to_cosmos_db_ru_mongo
Type	Resource
Id	azure.data_migration.database_migrations_mongo_to_cosmos_db_ru_mongo

Fields

vw_database_migrations_mongo_to_cosmos_db_ru_mongo

Name	Datatype	Description
id	text	field from the properties object
name	text	field from the properties object
collection_list	text	field from the properties object
ended_on	text	field from the properties object
kind	text	field from the properties object
migrationName	text	field from the properties object
migration_failure_error	text	field from the properties object
migration_operation_id	text	field from the properties object
migration_service	text	field from the properties object
migration_status	text	field from the properties object
provisioning_error	text	field from the properties object
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
scope	text	field from the properties object
source_mongo_connection	text	field from the properties object
started_on	text	field from the properties object
subscriptionId	text	field from the properties object
system_data	text	field from the properties object
targetResourceName	text	field from the properties object
target_mongo_connection	text	field from the properties object
type	text	field from the properties object

database_migrations_mongo_to_cosmos_db_ru_mongo

Name	Datatype	Description
id	string
name	string
properties	object	Database Migration Resource properties for CosmosDb for Mongo.
systemData	object
type	string

Methods

Name	Accessible by	Required Params	Description
get	SELECT	migrationName, resourceGroupName, subscriptionId, targetResourceName	Get Database Migration resource.
create	INSERT	migrationName, resourceGroupName, subscriptionId, targetResourceName	Create or Update Database Migration resource.
delete	DELETE	migrationName, resourceGroupName, subscriptionId, targetResourceName	Delete Database Migration resource.

SELECT examples

Get Database Migration resource.

vw_database_migrations_mongo_to_cosmos_db_ru_mongo

SELECT
id,
name,
collection_list,
ended_on,
kind,
migrationName,
migration_failure_error,
migration_operation_id,
migration_service,
migration_status,
provisioning_error,
provisioning_state,
resourceGroupName,
scope,
source_mongo_connection,
started_on,
subscriptionId,
system_data,
targetResourceName,
target_mongo_connection,
type
FROM azure.data_migration.vw_database_migrations_mongo_to_cosmos_db_ru_mongo
WHERE migrationName = '{{ migrationName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND targetResourceName = '{{ targetResourceName }}';

database_migrations_mongo_to_cosmos_db_ru_mongo

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

INSERT example

Use the following StackQL query and manifest file to create a new database_migrations_mongo_to_cosmos_db_ru_mongo resource.

All Properties

/*+ create */
INSERT INTO azure.data_migration.database_migrations_mongo_to_cosmos_db_ru_mongo (
migrationName,
resourceGroupName,
subscriptionId,
targetResourceName,
properties
)
SELECT 
'{{ migrationName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ targetResourceName }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: id
      value: string
    - name: name
      value: string
    - name: type
      value: string
    - name: systemData
      value:
        - name: createdBy
          value: string
        - name: createdByType
          value: string
        - name: createdAt
          value: string
        - name: lastModifiedBy
          value: string
        - name: lastModifiedByType
          value: string
        - name: lastModifiedAt
          value: string
    - name: properties
      value:
        - name: kind
          value: string
        - name: scope
          value: string
        - name: provisioningState
          value: string
        - name: migrationStatus
          value: string
        - name: startedOn
          value: string
        - name: endedOn
          value: string
        - name: migrationService
          value: string
        - name: migrationOperationId
          value: string
        - name: migrationFailureError
          value:
            - name: code
              value: string
            - name: message
              value: string
        - name: provisioningError
          value: string
        - name: sourceMongoConnection
          value:
            - name: host
              value: string
            - name: port
              value: integer
            - name: userName
              value: string
            - name: password
              value: string
            - name: useSsl
              value: boolean
            - name: connectionString
              value: string
        - name: collectionList
          value:
            - - name: sourceDatabase
                value: string
              - name: sourceCollection
                value: string
              - name: targetDatabase
                value: string
              - name: targetCollection
                value: string
              - name: migrationProgressDetails
                value:
                  - name: migrationStatus
                    value: string
                  - name: migrationError
                    value: string
                  - name: sourceDocumentCount
                    value: integer
                  - name: processedDocumentCount
                    value: integer
                  - name: durationInSeconds
                    value: integer

DELETE example

Deletes the specified database_migrations_mongo_to_cosmos_db_ru_mongo resource.

/*+ delete */
DELETE FROM azure.data_migration.database_migrations_mongo_to_cosmos_db_ru_mongo
WHERE migrationName = '{{ migrationName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND targetResourceName = '{{ targetResourceName }}';