databases_databases

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

Overview

Name	databases_databases
Type	Resource
Id	azure.migrate_projects.databases_databases

Fields

vw_databases_databases

Name	Datatype	Description
id	text	Gets or sets the relative URL to get to this REST resource.
name	text	Gets or sets the name of this REST resource.
assessment_data	text	field from the properties object
databaseName	text	field from the properties object
last_updated_time	text	field from the properties object
migrateProjectName	text	field from the properties object
resourceGroupName	text	field from the properties object
subscriptionId	text	field from the properties object
type	text	Gets the type of this REST resource.

databases_databases

Name	Datatype	Description
id	string	Gets or sets the relative URL to get to this REST resource.
name	string	Gets or sets the name of this REST resource.
properties	object	Properties of the database resource.
type	string	Gets the type of this REST resource.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	databaseName, migrateProjectName, resourceGroupName, subscriptionId

SELECT examples

vw_databases_databases

SELECT
id,
name,
assessment_data,
databaseName,
last_updated_time,
migrateProjectName,
resourceGroupName,
subscriptionId,
type
FROM azure.migrate_projects.vw_databases_databases
WHERE databaseName = '{{ databaseName }}'
AND migrateProjectName = '{{ migrateProjectName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

databases_databases

SELECT
id,
name,
properties,
type
FROM azure.migrate_projects.databases_databases
WHERE databaseName = '{{ databaseName }}'
AND migrateProjectName = '{{ migrateProjectName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';