database_migrations_sql_vms

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

Overview

Name	database_migrations_sql_vms
Type	Resource
Id	azure.data_migration.database_migrations_sql_vms

Fields

vw_database_migrations_sql_vms

Name	Datatype	Description
id	text	field from the properties object
name	text	field from the properties object
backup_configuration	text	field from the properties object
migration_status_details	text	field from the properties object
offline_configuration	text	field from the properties object
resourceGroupName	text	field from the properties object
source_database_name	text	field from the properties object
source_server_name	text	field from the properties object
source_sql_connection	text	field from the properties object
sqlVirtualMachineName	text	field from the properties object
subscriptionId	text	field from the properties object
system_data	text	field from the properties object
targetDbName	text	field from the properties object
target_database_collation	text	field from the properties object
type	text	field from the properties object

database_migrations_sql_vms

Name	Datatype	Description
id	string
name	string
properties	object	Database Migration Resource properties for SQL Virtual Machine.
systemData	object
type	string

Methods

Name	Accessible by	Required Params	Description
get	SELECT	resourceGroupName, sqlVirtualMachineName, subscriptionId, targetDbName	Retrieve the specified database migration for a given SQL VM.
create_or_update	INSERT	resourceGroupName, sqlVirtualMachineName, subscriptionId, targetDbName	Create a new database migration to a given SQL VM.
cancel	EXEC	resourceGroupName, sqlVirtualMachineName, subscriptionId, targetDbName	Stop in-progress database migration to SQL VM.
cutover	EXEC	resourceGroupName, sqlVirtualMachineName, subscriptionId, targetDbName	Initiate cutover for in-progress online database migration to SQL VM.

SELECT examples

Retrieve the specified database migration for a given SQL VM.

vw_database_migrations_sql_vms

SELECT
id,
name,
backup_configuration,
migration_status_details,
offline_configuration,
resourceGroupName,
source_database_name,
source_server_name,
source_sql_connection,
sqlVirtualMachineName,
subscriptionId,
system_data,
targetDbName,
target_database_collation,
type
FROM azure.data_migration.vw_database_migrations_sql_vms
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND sqlVirtualMachineName = '{{ sqlVirtualMachineName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND targetDbName = '{{ targetDbName }}';

database_migrations_sql_vms

SELECT
id,
name,
properties,
systemData,
type
FROM azure.data_migration.database_migrations_sql_vms
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND sqlVirtualMachineName = '{{ sqlVirtualMachineName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND targetDbName = '{{ targetDbName }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.data_migration.database_migrations_sql_vms (
resourceGroupName,
sqlVirtualMachineName,
subscriptionId,
targetDbName,
properties
)
SELECT 
'{{ resourceGroupName }}',
'{{ sqlVirtualMachineName }}',
'{{ subscriptionId }}',
'{{ targetDbName }}',
'{{ 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: sourceSqlConnection
          value:
            - name: dataSource
              value: string
            - name: authentication
              value: string
            - name: userName
              value: string
            - name: password
              value: string
            - name: encryptConnection
              value: boolean
            - name: trustServerCertificate
              value: boolean
        - name: sourceDatabaseName
          value: string
        - name: sourceServerName
          value: string
        - name: targetDatabaseCollation
          value: string
        - name: migrationStatusDetails
          value:
            - name: migrationState
              value: string
            - name: fullBackupSetInfo
              value:
                - name: backupSetId
                  value: string
                - name: firstLSN
                  value: string
                - name: lastLSN
                  value: string
                - name: backupType
                  value: string
                - name: listOfBackupFiles
                  value:
                    - - name: fileName
                        value: string
                      - name: status
                        value: string
                      - name: totalSize
                        value: integer
                      - name: dataRead
                        value: integer
                      - name: dataWritten
                        value: integer
                      - name: copyThroughput
                        value: number
                      - name: copyDuration
                        value: integer
                      - name: familySequenceNumber
                        value: integer
                - name: backupStartDate
                  value: string
                - name: backupFinishDate
                  value: string
                - name: isBackupRestored
                  value: boolean
                - name: hasBackupChecksums
                  value: boolean
                - name: familyCount
                  value: integer
                - name: ignoreReasons
                  value:
                    - string
            - name: activeBackupSets
              value:
                - - name: backupSetId
                    value: string
                  - name: firstLSN
                    value: string
                  - name: lastLSN
                    value: string
                  - name: backupType
                    value: string
                  - name: listOfBackupFiles
                    value:
                      - - name: fileName
                          value: string
                        - name: status
                          value: string
                        - name: totalSize
                          value: integer
                        - name: dataRead
                          value: integer
                        - name: dataWritten
                          value: integer
                        - name: copyThroughput
                          value: number
                        - name: copyDuration
                          value: integer
                        - name: familySequenceNumber
                          value: integer
                  - name: backupStartDate
                    value: string
                  - name: backupFinishDate
                    value: string
                  - name: isBackupRestored
                    value: boolean
                  - name: hasBackupChecksums
                    value: boolean
                  - name: familyCount
                    value: integer
                  - name: ignoreReasons
                    value:
                      - string
            - name: invalidFiles
              value:
                - string
            - name: blobContainerName
              value: string
            - name: isFullBackupRestored
              value: boolean
            - name: restoreBlockingReason
              value: string
            - name: completeRestoreErrorMessage
              value: string
            - name: fileUploadBlockingErrors
              value:
                - string
            - name: currentRestoringFilename
              value: string
            - name: lastRestoredFilename
              value: string
            - name: pendingLogBackupsCount
              value: integer
        - name: backupConfiguration
          value:
            - name: sourceLocation
              value:
                - name: fileShare
                  value:
                    - name: path
                      value: string
                    - name: username
                      value: string
                    - name: password
                      value: string
                - name: azureBlob
                  value:
                    - name: storageAccountResourceId
                      value: string
                    - name: accountKey
                      value: string
                    - name: blobContainerName
                      value: string
                - name: fileStorageType
                  value: string
            - name: targetLocation
              value:
                - name: storageAccountResourceId
                  value: string
                - name: accountKey
                  value: string
        - name: offlineConfiguration
          value:
            - name: offline
              value: boolean
            - name: lastBackupName
              value: string