AWS Database Migration Service

2023/08/03 - AWS Database Migration Service - 27 new api methods

Changes  The release makes public API for DMS Schema Conversion feature.

ModifyMigrationProject (new) Link ¶

Modifies the specified migration project using the provided parameters.

Note

The migration project must be closed before you can modify it.

See also: AWS API Documentation

Request Syntax

client.modify_migration_project(
    MigrationProjectIdentifier='string',
    MigrationProjectName='string',
    SourceDataProviderDescriptors=[
        {
            'DataProviderIdentifier': 'string',
            'SecretsManagerSecretId': 'string',
            'SecretsManagerAccessRoleArn': 'string'
        },
    ],
    TargetDataProviderDescriptors=[
        {
            'DataProviderIdentifier': 'string',
            'SecretsManagerSecretId': 'string',
            'SecretsManagerAccessRoleArn': 'string'
        },
    ],
    InstanceProfileIdentifier='string',
    TransformationRules='string',
    Description='string',
    SchemaConversionApplicationAttributes={
        'S3BucketPath': 'string',
        'S3BucketRoleArn': 'string'
    }
)
type MigrationProjectIdentifier

string

param MigrationProjectIdentifier

[REQUIRED]

The identifier of the migration project. Identifiers must begin with a letter and must contain only ASCII letters, digits, and hyphens. They can't end with a hyphen, or contain two consecutive hyphens.

type MigrationProjectName

string

param MigrationProjectName

A user-friendly name for the migration project.

type SourceDataProviderDescriptors

list

param SourceDataProviderDescriptors

Information about the source data provider, including the name, ARN, and Amazon Web Services Secrets Manager parameters.

  • (dict) --

    Information about a data provider.

    • DataProviderIdentifier (string) -- [REQUIRED]

      The name or Amazon Resource Name (ARN) of the data provider.

    • SecretsManagerSecretId (string) --

      The identifier of the Amazon Web Services Secrets Manager Secret used to store access credentials for the data provider.

    • SecretsManagerAccessRoleArn (string) --

      The ARN of the role used to access Amazon Web Services Secrets Manager.

type TargetDataProviderDescriptors

list

param TargetDataProviderDescriptors

Information about the target data provider, including the name, ARN, and Amazon Web Services Secrets Manager parameters.

  • (dict) --

    Information about a data provider.

    • DataProviderIdentifier (string) -- [REQUIRED]

      The name or Amazon Resource Name (ARN) of the data provider.

    • SecretsManagerSecretId (string) --

      The identifier of the Amazon Web Services Secrets Manager Secret used to store access credentials for the data provider.

    • SecretsManagerAccessRoleArn (string) --

      The ARN of the role used to access Amazon Web Services Secrets Manager.

type InstanceProfileIdentifier

string

param InstanceProfileIdentifier

The name or Amazon Resource Name (ARN) for the instance profile.

type TransformationRules

string

param TransformationRules

The settings in JSON format for migration rules. Migration rules make it possible for you to change the object names according to the rules that you specify. For example, you can change an object name to lowercase or uppercase, add or remove a prefix or suffix, or rename objects.

type Description

string

param Description

A user-friendly description of the migration project.

type SchemaConversionApplicationAttributes

dict

param SchemaConversionApplicationAttributes

The schema conversion application attributes, including the Amazon S3 bucket name and Amazon S3 role ARN.

  • S3BucketPath (string) --

    The path for the Amazon S3 bucket that the application uses for exporting assessment reports.

  • S3BucketRoleArn (string) --

    The ARN for the role the application uses to access its Amazon S3 bucket.

rtype

dict

returns

Response Syntax

{
    'MigrationProject': {
        'MigrationProjectName': 'string',
        'MigrationProjectArn': 'string',
        'MigrationProjectCreationTime': datetime(2015, 1, 1),
        'SourceDataProviderDescriptors': [
            {
                'SecretsManagerSecretId': 'string',
                'SecretsManagerAccessRoleArn': 'string',
                'DataProviderName': 'string',
                'DataProviderArn': 'string'
            },
        ],
        'TargetDataProviderDescriptors': [
            {
                'SecretsManagerSecretId': 'string',
                'SecretsManagerAccessRoleArn': 'string',
                'DataProviderName': 'string',
                'DataProviderArn': 'string'
            },
        ],
        'InstanceProfileArn': 'string',
        'InstanceProfileName': 'string',
        'TransformationRules': 'string',
        'Description': 'string',
        'SchemaConversionApplicationAttributes': {
            'S3BucketPath': 'string',
            'S3BucketRoleArn': 'string'
        }
    }
}

Response Structure

  • (dict) --

    • MigrationProject (dict) --

      The migration project that was modified.

      • MigrationProjectName (string) --

        The name of the migration project.

      • MigrationProjectArn (string) --

        The ARN string that uniquely identifies the migration project.

      • MigrationProjectCreationTime (datetime) --

        The time when the migration project was created.

      • SourceDataProviderDescriptors (list) --

        Information about the source data provider, including the name or ARN, and Secrets Manager parameters.

        • (dict) --

          Information about a data provider.

          • SecretsManagerSecretId (string) --

            The identifier of the Amazon Web Services Secrets Manager Secret used to store access credentials for the data provider.

          • SecretsManagerAccessRoleArn (string) --

            The ARN of the role used to access Amazon Web Services Secrets Manager.

          • DataProviderName (string) --

            The user-friendly name of the data provider.

          • DataProviderArn (string) --

            The Amazon Resource Name (ARN) of the data provider.

      • TargetDataProviderDescriptors (list) --

        Information about the target data provider, including the name or ARN, and Secrets Manager parameters.

        • (dict) --

          Information about a data provider.

          • SecretsManagerSecretId (string) --

            The identifier of the Amazon Web Services Secrets Manager Secret used to store access credentials for the data provider.

          • SecretsManagerAccessRoleArn (string) --

            The ARN of the role used to access Amazon Web Services Secrets Manager.

          • DataProviderName (string) --

            The user-friendly name of the data provider.

          • DataProviderArn (string) --

            The Amazon Resource Name (ARN) of the data provider.

      • InstanceProfileArn (string) --

        The Amazon Resource Name (ARN) of the instance profile for your migration project.

      • InstanceProfileName (string) --

        The name of the associated instance profile.

      • TransformationRules (string) --

        The settings in JSON format for migration rules. Migration rules make it possible for you to change the object names according to the rules that you specify. For example, you can change an object name to lowercase or uppercase, add or remove a prefix or suffix, or rename objects.

      • Description (string) --

        A user-friendly description of the migration project.

      • SchemaConversionApplicationAttributes (dict) --

        The schema conversion application attributes, including the Amazon S3 bucket name and Amazon S3 role ARN.

        • S3BucketPath (string) --

          The path for the Amazon S3 bucket that the application uses for exporting assessment reports.

        • S3BucketRoleArn (string) --

          The ARN for the role the application uses to access its Amazon S3 bucket.

CreateInstanceProfile (new) Link ¶

Creates the instance profile using the specified parameters.

See also: AWS API Documentation

Request Syntax

client.create_instance_profile(
    AvailabilityZone='string',
    KmsKeyArn='string',
    PubliclyAccessible=True|False,
    Tags=[
        {
            'Key': 'string',
            'Value': 'string',
            'ResourceArn': 'string'
        },
    ],
    NetworkType='string',
    InstanceProfileName='string',
    Description='string',
    SubnetGroupIdentifier='string',
    VpcSecurityGroups=[
        'string',
    ]
)
type AvailabilityZone

string

param AvailabilityZone

The Availability Zone where the instance profile will be created. The default value is a random, system-chosen Availability Zone in the Amazon Web Services Region where your data provider is created, for examplem us-east-1d .

type KmsKeyArn

string

param KmsKeyArn

The Amazon Resource Name (ARN) of the KMS key that is used to encrypt the connection parameters for the instance profile.

If you don't specify a value for the KmsKeyArn parameter, then DMS uses your default encryption key.

KMS creates the default encryption key for your Amazon Web Services account. Your Amazon Web Services account has a different default encryption key for each Amazon Web Services Region.

type PubliclyAccessible

boolean

param PubliclyAccessible

Specifies the accessibility options for the instance profile. A value of true represents an instance profile with a public IP address. A value of false represents an instance profile with a private IP address. The default value is true .

type Tags

list

param Tags

One or more tags to be assigned to the instance profile.

  • (dict) --

    A user-defined key-value pair that describes metadata added to an DMS resource and that is used by operations such as the following:

    • AddTagsToResource

    • ListTagsForResource

    • RemoveTagsFromResource

    • Key (string) --

      A key is the required name of the tag. The string value can be 1-128 Unicode characters in length and can't be prefixed with "aws:" or "dms:". The string can only contain only the set of Unicode letters, digits, white-space, '_', '.', '/', '=', '+', '-' (Java regular expressions: "^([\p{L}\p{Z}\p{N}_.:/=+\-]*)$").

    • Value (string) --

      A value is the optional value of the tag. The string value can be 1-256 Unicode characters in length and can't be prefixed with "aws:" or "dms:". The string can only contain only the set of Unicode letters, digits, white-space, '_', '.', '/', '=', '+', '-' (Java regular expressions: "^([\p{L}\p{Z}\p{N}_.:/=+\-]*)$").

    • ResourceArn (string) --

      The Amazon Resource Name (ARN) string that uniquely identifies the resource for which the tag is created.

type NetworkType

string

param NetworkType

Specifies the network type for the instance profile. A value of IPV4 represents an instance profile with IPv4 network type and only supports IPv4 addressing. A value of IPV6 represents an instance profile with IPv6 network type and only supports IPv6 addressing. A value of DUAL represents an instance profile with dual network type that supports IPv4 and IPv6 addressing.

type InstanceProfileName

string

param InstanceProfileName

A user-friendly name for the instance profile.

type Description

string

param Description

A user-friendly description of the instance profile.

type SubnetGroupIdentifier

string

param SubnetGroupIdentifier

A subnet group to associate with the instance profile.

type VpcSecurityGroups

list

param VpcSecurityGroups

Specifies the VPC security group names to be used with the instance profile. The VPC security group must work with the VPC containing the instance profile.

  • (string) --

rtype

dict

returns

Response Syntax

{
    'InstanceProfile': {
        'InstanceProfileArn': 'string',
        'AvailabilityZone': 'string',
        'KmsKeyArn': 'string',
        'PubliclyAccessible': True|False,
        'NetworkType': 'string',
        'InstanceProfileName': 'string',
        'Description': 'string',
        'InstanceProfileCreationTime': datetime(2015, 1, 1),
        'SubnetGroupIdentifier': 'string',
        'VpcSecurityGroups': [
            'string',
        ]
    }
}

Response Structure

  • (dict) --

    • InstanceProfile (dict) --

      The instance profile that was created.

      • InstanceProfileArn (string) --

        The Amazon Resource Name (ARN) string that uniquely identifies the instance profile.

      • AvailabilityZone (string) --

        The Availability Zone where the instance profile runs.

      • KmsKeyArn (string) --

        The Amazon Resource Name (ARN) of the KMS key that is used to encrypt the connection parameters for the instance profile.

        If you don't specify a value for the KmsKeyArn parameter, then DMS uses your default encryption key.

        KMS creates the default encryption key for your Amazon Web Services account. Your Amazon Web Services account has a different default encryption key for each Amazon Web Services Region.

      • PubliclyAccessible (boolean) --

        Specifies the accessibility options for the instance profile. A value of true represents an instance profile with a public IP address. A value of false represents an instance profile with a private IP address. The default value is true .

      • NetworkType (string) --

        Specifies the network type for the instance profile. A value of IPV4 represents an instance profile with IPv4 network type and only supports IPv4 addressing. A value of IPV6 represents an instance profile with IPv6 network type and only supports IPv6 addressing. A value of DUAL represents an instance profile with dual network type that supports IPv4 and IPv6 addressing.

      • InstanceProfileName (string) --

        The user-friendly name for the instance profile.

      • Description (string) --

        A description of the instance profile. Descriptions can have up to 31 characters. A description can contain only ASCII letters, digits, and hyphens ('-'). Also, it can't end with a hyphen or contain two consecutive hyphens, and can only begin with a letter.

      • InstanceProfileCreationTime (datetime) --

        The time the instance profile was created.

      • SubnetGroupIdentifier (string) --

        The identifier of the subnet group that is associated with the instance profile.

      • VpcSecurityGroups (list) --

        The VPC security groups that are used with the instance profile. The VPC security group must work with the VPC containing the instance profile.

        • (string) --

ModifyDataProvider (new) Link ¶

Modifies the specified data provider using the provided settings.

Note

You must remove the data provider from all migration projects before you can modify it.

See also: AWS API Documentation

Request Syntax

client.modify_data_provider(
    DataProviderIdentifier='string',
    DataProviderName='string',
    Description='string',
    Engine='string',
    ExactSettings=True|False,
    Settings={
        'PostgreSqlSettings': {
            'ServerName': 'string',
            'Port': 123,
            'DatabaseName': 'string',
            'SslMode': 'none'|'require'|'verify-ca'|'verify-full',
            'CertificateArn': 'string'
        },
        'MySqlSettings': {
            'ServerName': 'string',
            'Port': 123,
            'SslMode': 'none'|'require'|'verify-ca'|'verify-full',
            'CertificateArn': 'string'
        },
        'OracleSettings': {
            'ServerName': 'string',
            'Port': 123,
            'DatabaseName': 'string',
            'SslMode': 'none'|'require'|'verify-ca'|'verify-full',
            'CertificateArn': 'string',
            'AsmServer': 'string',
            'SecretsManagerOracleAsmSecretId': 'string',
            'SecretsManagerOracleAsmAccessRoleArn': 'string',
            'SecretsManagerSecurityDbEncryptionSecretId': 'string',
            'SecretsManagerSecurityDbEncryptionAccessRoleArn': 'string'
        },
        'MicrosoftSqlServerSettings': {
            'ServerName': 'string',
            'Port': 123,
            'DatabaseName': 'string',
            'SslMode': 'none'|'require'|'verify-ca'|'verify-full',
            'CertificateArn': 'string'
        }
    }
)
type DataProviderIdentifier

string

param DataProviderIdentifier

[REQUIRED]

The identifier of the data provider. Identifiers must begin with a letter and must contain only ASCII letters, digits, and hyphens. They can't end with a hyphen, or contain two consecutive hyphens.

type DataProviderName

string

param DataProviderName

The name of the data provider.

type Description

string

param Description

A user-friendly description of the data provider.

type Engine

string

param Engine

The type of database engine for the data provider. Valid values include "aurora" , "aurora_postgresql" , "mysql" , "oracle" , "postgres" , and "sqlserver" . A value of "aurora" represents Amazon Aurora MySQL-Compatible Edition.

type ExactSettings

boolean

param ExactSettings

If this attribute is Y, the current call to ModifyDataProvider replaces all existing data provider settings with the exact settings that you specify in this call. If this attribute is N, the current call to ModifyDataProvider does two things:

  • It replaces any data provider settings that already exist with new values, for settings with the same names.

  • It creates new data provider settings that you specify in the call, for settings with different names.

type Settings

dict

param Settings

The settings in JSON format for a data provider.

  • PostgreSqlSettings (dict) --

    Provides information that defines a PostgreSQL data provider.

    • ServerName (string) --

      The name of the PostgreSQL server.

    • Port (integer) --

      The port value for the PostgreSQL data provider.

    • DatabaseName (string) --

      The database name on the PostgreSQL data provider.

    • SslMode (string) --

      The SSL mode used to connect to the PostgreSQL data provider. The default value is none .

    • CertificateArn (string) --

      The Amazon Resource Name (ARN) of the certificate used for SSL connection.

  • MySqlSettings (dict) --

    Provides information that defines a MySQL data provider.

    • ServerName (string) --

      The name of the MySQL server.

    • Port (integer) --

      The port value for the MySQL data provider.

    • SslMode (string) --

      The SSL mode used to connect to the MySQL data provider. The default value is none .

    • CertificateArn (string) --

      The Amazon Resource Name (ARN) of the certificate used for SSL connection.

  • OracleSettings (dict) --

    Provides information that defines an Oracle data provider.

    • ServerName (string) --

      The name of the Oracle server.

    • Port (integer) --

      The port value for the Oracle data provider.

    • DatabaseName (string) --

      The database name on the Oracle data provider.

    • SslMode (string) --

      The SSL mode used to connect to the Oracle data provider. The default value is none .

    • CertificateArn (string) --

      The Amazon Resource Name (ARN) of the certificate used for SSL connection.

    • AsmServer (string) --

      The address of your Oracle Automatic Storage Management (ASM) server. You can set this value from the asm_server value. You set asm_server as part of the extra connection attribute string to access an Oracle server with Binary Reader that uses ASM. For more information, see Configuration for change data capture (CDC) on an Oracle source database .

    • SecretsManagerOracleAsmSecretId (string) --

      The identifier of the secret in Secrets Manager that contains the Oracle ASM connection details.

      Required only if your data provider uses the Oracle ASM server.

    • SecretsManagerOracleAsmAccessRoleArn (string) --

      The ARN of the IAM role that provides access to the secret in Secrets Manager that contains the Oracle ASM connection details.

    • SecretsManagerSecurityDbEncryptionSecretId (string) --

      The identifier of the secret in Secrets Manager that contains the transparent data encryption (TDE) password. DMS requires this password to access Oracle redo logs encrypted by TDE using Binary Reader.

    • SecretsManagerSecurityDbEncryptionAccessRoleArn (string) --

      The ARN of the IAM role that provides access to the secret in Secrets Manager that contains the TDE password.

  • MicrosoftSqlServerSettings (dict) --

    Provides information that defines a Microsoft SQL Server data provider.

    • ServerName (string) --

      The name of the Microsoft SQL Server server.

    • Port (integer) --

      The port value for the Microsoft SQL Server data provider.

    • DatabaseName (string) --

      The database name on the Microsoft SQL Server data provider.

    • SslMode (string) --

      The SSL mode used to connect to the Microsoft SQL Server data provider. The default value is none .

    • CertificateArn (string) --

      The Amazon Resource Name (ARN) of the certificate used for SSL connection.

rtype

dict

returns

Response Syntax

{
    'DataProvider': {
        'DataProviderName': 'string',
        'DataProviderArn': 'string',
        'DataProviderCreationTime': datetime(2015, 1, 1),
        'Description': 'string',
        'Engine': 'string',
        'Settings': {
            'PostgreSqlSettings': {
                'ServerName': 'string',
                'Port': 123,
                'DatabaseName': 'string',
                'SslMode': 'none'|'require'|'verify-ca'|'verify-full',
                'CertificateArn': 'string'
            },
            'MySqlSettings': {
                'ServerName': 'string',
                'Port': 123,
                'SslMode': 'none'|'require'|'verify-ca'|'verify-full',
                'CertificateArn': 'string'
            },
            'OracleSettings': {
                'ServerName': 'string',
                'Port': 123,
                'DatabaseName': 'string',
                'SslMode': 'none'|'require'|'verify-ca'|'verify-full',
                'CertificateArn': 'string',
                'AsmServer': 'string',
                'SecretsManagerOracleAsmSecretId': 'string',
                'SecretsManagerOracleAsmAccessRoleArn': 'string',
                'SecretsManagerSecurityDbEncryptionSecretId': 'string',
                'SecretsManagerSecurityDbEncryptionAccessRoleArn': 'string'
            },
            'MicrosoftSqlServerSettings': {
                'ServerName': 'string',
                'Port': 123,
                'DatabaseName': 'string',
                'SslMode': 'none'|'require'|'verify-ca'|'verify-full',
                'CertificateArn': 'string'
            }
        }
    }
}

Response Structure

  • (dict) --

    • DataProvider (dict) --

      The data provider that was modified.

      • DataProviderName (string) --

        The name of the data provider.

      • DataProviderArn (string) --

        The Amazon Resource Name (ARN) string that uniquely identifies the data provider.

      • DataProviderCreationTime (datetime) --

        The time the data provider was created.

      • Description (string) --

        A description of the data provider. Descriptions can have up to 31 characters. A description can contain only ASCII letters, digits, and hyphens ('-'). Also, it can't end with a hyphen or contain two consecutive hyphens, and can only begin with a letter.

      • Engine (string) --

        The type of database engine for the data provider. Valid values include "aurora" , "aurora_postgresql" , "mysql" , "oracle" , "postgres" , and "sqlserver" . A value of "aurora" represents Amazon Aurora MySQL-Compatible Edition.

      • Settings (dict) --

        The settings in JSON format for a data provider.

        • PostgreSqlSettings (dict) --

          Provides information that defines a PostgreSQL data provider.

          • ServerName (string) --

            The name of the PostgreSQL server.

          • Port (integer) --

            The port value for the PostgreSQL data provider.

          • DatabaseName (string) --

            The database name on the PostgreSQL data provider.

          • SslMode (string) --

            The SSL mode used to connect to the PostgreSQL data provider. The default value is none .

          • CertificateArn (string) --

            The Amazon Resource Name (ARN) of the certificate used for SSL connection.

        • MySqlSettings (dict) --

          Provides information that defines a MySQL data provider.

          • ServerName (string) --

            The name of the MySQL server.

          • Port (integer) --

            The port value for the MySQL data provider.

          • SslMode (string) --

            The SSL mode used to connect to the MySQL data provider. The default value is none .

          • CertificateArn (string) --

            The Amazon Resource Name (ARN) of the certificate used for SSL connection.

        • OracleSettings (dict) --

          Provides information that defines an Oracle data provider.

          • ServerName (string) --

            The name of the Oracle server.

          • Port (integer) --

            The port value for the Oracle data provider.

          • DatabaseName (string) --

            The database name on the Oracle data provider.

          • SslMode (string) --

            The SSL mode used to connect to the Oracle data provider. The default value is none .

          • CertificateArn (string) --

            The Amazon Resource Name (ARN) of the certificate used for SSL connection.

          • AsmServer (string) --

            The address of your Oracle Automatic Storage Management (ASM) server. You can set this value from the asm_server value. You set asm_server as part of the extra connection attribute string to access an Oracle server with Binary Reader that uses ASM. For more information, see Configuration for change data capture (CDC) on an Oracle source database .

          • SecretsManagerOracleAsmSecretId (string) --

            The identifier of the secret in Secrets Manager that contains the Oracle ASM connection details.

            Required only if your data provider uses the Oracle ASM server.

          • SecretsManagerOracleAsmAccessRoleArn (string) --

            The ARN of the IAM role that provides access to the secret in Secrets Manager that contains the Oracle ASM connection details.

          • SecretsManagerSecurityDbEncryptionSecretId (string) --

            The identifier of the secret in Secrets Manager that contains the transparent data encryption (TDE) password. DMS requires this password to access Oracle redo logs encrypted by TDE using Binary Reader.

          • SecretsManagerSecurityDbEncryptionAccessRoleArn (string) --

            The ARN of the IAM role that provides access to the secret in Secrets Manager that contains the TDE password.

        • MicrosoftSqlServerSettings (dict) --

          Provides information that defines a Microsoft SQL Server data provider.

          • ServerName (string) --

            The name of the Microsoft SQL Server server.

          • Port (integer) --

            The port value for the Microsoft SQL Server data provider.

          • DatabaseName (string) --

            The database name on the Microsoft SQL Server data provider.

          • SslMode (string) --

            The SSL mode used to connect to the Microsoft SQL Server data provider. The default value is none .

          • CertificateArn (string) --

            The Amazon Resource Name (ARN) of the certificate used for SSL connection.

DeleteDataProvider (new) Link ¶

Deletes the specified data provider.

Note

All migration projects associated with the data provider must be deleted or modified before you can delete the data provider.

See also: AWS API Documentation

Request Syntax

client.delete_data_provider(
    DataProviderIdentifier='string'
)
type DataProviderIdentifier

string

param DataProviderIdentifier

[REQUIRED]

The identifier of the data provider to delete.

rtype

dict

returns

Response Syntax

{
    'DataProvider': {
        'DataProviderName': 'string',
        'DataProviderArn': 'string',
        'DataProviderCreationTime': datetime(2015, 1, 1),
        'Description': 'string',
        'Engine': 'string',
        'Settings': {
            'PostgreSqlSettings': {
                'ServerName': 'string',
                'Port': 123,
                'DatabaseName': 'string',
                'SslMode': 'none'|'require'|'verify-ca'|'verify-full',
                'CertificateArn': 'string'
            },
            'MySqlSettings': {
                'ServerName': 'string',
                'Port': 123,
                'SslMode': 'none'|'require'|'verify-ca'|'verify-full',
                'CertificateArn': 'string'
            },
            'OracleSettings': {
                'ServerName': 'string',
                'Port': 123,
                'DatabaseName': 'string',
                'SslMode': 'none'|'require'|'verify-ca'|'verify-full',
                'CertificateArn': 'string',
                'AsmServer': 'string',
                'SecretsManagerOracleAsmSecretId': 'string',
                'SecretsManagerOracleAsmAccessRoleArn': 'string',
                'SecretsManagerSecurityDbEncryptionSecretId': 'string',
                'SecretsManagerSecurityDbEncryptionAccessRoleArn': 'string'
            },
            'MicrosoftSqlServerSettings': {
                'ServerName': 'string',
                'Port': 123,
                'DatabaseName': 'string',
                'SslMode': 'none'|'require'|'verify-ca'|'verify-full',
                'CertificateArn': 'string'
            }
        }
    }
}

Response Structure

  • (dict) --

    • DataProvider (dict) --

      The data provider that was deleted.

      • DataProviderName (string) --

        The name of the data provider.

      • DataProviderArn (string) --

        The Amazon Resource Name (ARN) string that uniquely identifies the data provider.

      • DataProviderCreationTime (datetime) --

        The time the data provider was created.

      • Description (string) --

        A description of the data provider. Descriptions can have up to 31 characters. A description can contain only ASCII letters, digits, and hyphens ('-'). Also, it can't end with a hyphen or contain two consecutive hyphens, and can only begin with a letter.

      • Engine (string) --

        The type of database engine for the data provider. Valid values include "aurora" , "aurora_postgresql" , "mysql" , "oracle" , "postgres" , and "sqlserver" . A value of "aurora" represents Amazon Aurora MySQL-Compatible Edition.

      • Settings (dict) --

        The settings in JSON format for a data provider.

        • PostgreSqlSettings (dict) --

          Provides information that defines a PostgreSQL data provider.

          • ServerName (string) --

            The name of the PostgreSQL server.

          • Port (integer) --

            The port value for the PostgreSQL data provider.

          • DatabaseName (string) --

            The database name on the PostgreSQL data provider.

          • SslMode (string) --

            The SSL mode used to connect to the PostgreSQL data provider. The default value is none .

          • CertificateArn (string) --

            The Amazon Resource Name (ARN) of the certificate used for SSL connection.

        • MySqlSettings (dict) --

          Provides information that defines a MySQL data provider.

          • ServerName (string) --

            The name of the MySQL server.

          • Port (integer) --

            The port value for the MySQL data provider.

          • SslMode (string) --

            The SSL mode used to connect to the MySQL data provider. The default value is none .

          • CertificateArn (string) --

            The Amazon Resource Name (ARN) of the certificate used for SSL connection.

        • OracleSettings (dict) --

          Provides information that defines an Oracle data provider.

          • ServerName (string) --

            The name of the Oracle server.

          • Port (integer) --

            The port value for the Oracle data provider.

          • DatabaseName (string) --

            The database name on the Oracle data provider.

          • SslMode (string) --

            The SSL mode used to connect to the Oracle data provider. The default value is none .

          • CertificateArn (string) --

            The Amazon Resource Name (ARN) of the certificate used for SSL connection.

          • AsmServer (string) --

            The address of your Oracle Automatic Storage Management (ASM) server. You can set this value from the asm_server value. You set asm_server as part of the extra connection attribute string to access an Oracle server with Binary Reader that uses ASM. For more information, see Configuration for change data capture (CDC) on an Oracle source database .

          • SecretsManagerOracleAsmSecretId (string) --

            The identifier of the secret in Secrets Manager that contains the Oracle ASM connection details.

            Required only if your data provider uses the Oracle ASM server.

          • SecretsManagerOracleAsmAccessRoleArn (string) --

            The ARN of the IAM role that provides access to the secret in Secrets Manager that contains the Oracle ASM connection details.

          • SecretsManagerSecurityDbEncryptionSecretId (string) --

            The identifier of the secret in Secrets Manager that contains the transparent data encryption (TDE) password. DMS requires this password to access Oracle redo logs encrypted by TDE using Binary Reader.

          • SecretsManagerSecurityDbEncryptionAccessRoleArn (string) --

            The ARN of the IAM role that provides access to the secret in Secrets Manager that contains the TDE password.

        • MicrosoftSqlServerSettings (dict) --

          Provides information that defines a Microsoft SQL Server data provider.

          • ServerName (string) --

            The name of the Microsoft SQL Server server.

          • Port (integer) --

            The port value for the Microsoft SQL Server data provider.

          • DatabaseName (string) --

            The database name on the Microsoft SQL Server data provider.

          • SslMode (string) --

            The SSL mode used to connect to the Microsoft SQL Server data provider. The default value is none .

          • CertificateArn (string) --

            The Amazon Resource Name (ARN) of the certificate used for SSL connection.

StartMetadataModelExportToTarget (new) Link ¶

Applies converted database objects to your target database.

See also: AWS API Documentation

Request Syntax

client.start_metadata_model_export_to_target(
    MigrationProjectIdentifier='string',
    SelectionRules='string',
    OverwriteExtensionPack=True|False
)
type MigrationProjectIdentifier

string

param MigrationProjectIdentifier

[REQUIRED]

The migration project name or Amazon Resource Name (ARN).

type SelectionRules

string

param SelectionRules

[REQUIRED]

A value that specifies the database objects to export.

type OverwriteExtensionPack

boolean

param OverwriteExtensionPack

Whether to overwrite the migration project extension pack. An extension pack is an add-on module that emulates functions present in a source database that are required when converting objects to the target database.

rtype

dict

returns

Response Syntax

{
    'RequestIdentifier': 'string'
}

Response Structure

  • (dict) --

    • RequestIdentifier (string) --

      The identifier for the export operation.

DescribeInstanceProfiles (new) Link ¶

Returns a paginated list of instance profiles for your account in the current region.

See also: AWS API Documentation

Request Syntax

client.describe_instance_profiles(
    Filters=[
        {
            'Name': 'string',
            'Values': [
                'string',
            ]
        },
    ],
    MaxRecords=123,
    Marker='string'
)
type Filters

list

param Filters

Filters applied to the instance profiles described in the form of key-value pairs.

  • (dict) --

    Identifies the name and value of a filter object. This filter is used to limit the number and type of DMS objects that are returned for a particular Describe* call or similar operation. Filters are used as an optional parameter for certain API operations.

    • Name (string) -- [REQUIRED]

      The name of the filter as specified for a Describe* or similar operation.

    • Values (list) -- [REQUIRED]

      The filter value, which can specify one or more values used to narrow the returned results.

      • (string) --

type MaxRecords

integer

param MaxRecords

The maximum number of records to include in the response. If more records exist than the specified MaxRecords value, DMS includes a pagination token in the response so that you can retrieve the remaining results.

type Marker

string

param Marker

Specifies the unique pagination token that makes it possible to display the next page of results. If this parameter is specified, the response includes only records beyond the marker, up to the value specified by MaxRecords .

If Marker is returned by a previous response, there are more results available. The value of Marker is a unique pagination token for each page. To retrieve the next page, make the call again using the returned token and keeping all other arguments unchanged.

rtype

dict

returns

Response Syntax

{
    'Marker': 'string',
    'InstanceProfiles': [
        {
            'InstanceProfileArn': 'string',
            'AvailabilityZone': 'string',
            'KmsKeyArn': 'string',
            'PubliclyAccessible': True|False,
            'NetworkType': 'string',
            'InstanceProfileName': 'string',
            'Description': 'string',
            'InstanceProfileCreationTime': datetime(2015, 1, 1),
            'SubnetGroupIdentifier': 'string',
            'VpcSecurityGroups': [
                'string',
            ]
        },
    ]
}

Response Structure

  • (dict) --

    • Marker (string) --

      Specifies the unique pagination token that makes it possible to display the next page of results. If this parameter is specified, the response includes only records beyond the marker, up to the value specified by MaxRecords .

      If Marker is returned by a previous response, there are more results available. The value of Marker is a unique pagination token for each page. To retrieve the next page, make the call again using the returned token and keeping all other arguments unchanged.

    • InstanceProfiles (list) --

      A description of instance profiles.

      • (dict) --

        Provides information that defines an instance profile.

        • InstanceProfileArn (string) --

          The Amazon Resource Name (ARN) string that uniquely identifies the instance profile.

        • AvailabilityZone (string) --

          The Availability Zone where the instance profile runs.

        • KmsKeyArn (string) --

          The Amazon Resource Name (ARN) of the KMS key that is used to encrypt the connection parameters for the instance profile.

          If you don't specify a value for the KmsKeyArn parameter, then DMS uses your default encryption key.

          KMS creates the default encryption key for your Amazon Web Services account. Your Amazon Web Services account has a different default encryption key for each Amazon Web Services Region.

        • PubliclyAccessible (boolean) --

          Specifies the accessibility options for the instance profile. A value of true represents an instance profile with a public IP address. A value of false represents an instance profile with a private IP address. The default value is true .

        • NetworkType (string) --

          Specifies the network type for the instance profile. A value of IPV4 represents an instance profile with IPv4 network type and only supports IPv4 addressing. A value of IPV6 represents an instance profile with IPv6 network type and only supports IPv6 addressing. A value of DUAL represents an instance profile with dual network type that supports IPv4 and IPv6 addressing.

        • InstanceProfileName (string) --

          The user-friendly name for the instance profile.

        • Description (string) --

          A description of the instance profile. Descriptions can have up to 31 characters. A description can contain only ASCII letters, digits, and hyphens ('-'). Also, it can't end with a hyphen or contain two consecutive hyphens, and can only begin with a letter.

        • InstanceProfileCreationTime (datetime) --

          The time the instance profile was created.

        • SubnetGroupIdentifier (string) --

          The identifier of the subnet group that is associated with the instance profile.

        • VpcSecurityGroups (list) --

          The VPC security groups that are used with the instance profile. The VPC security group must work with the VPC containing the instance profile.

          • (string) --

StartMetadataModelImport (new) Link ¶

Loads the metadata for all the dependent database objects of the parent object.

This operation uses your project's Amazon S3 bucket as a metadata cache to improve performance.

See also: AWS API Documentation

Request Syntax

client.start_metadata_model_import(
    MigrationProjectIdentifier='string',
    SelectionRules='string',
    Origin='SOURCE'|'TARGET',
    Refresh=True|False
)
type MigrationProjectIdentifier

string

param MigrationProjectIdentifier

[REQUIRED]

The migration project name or Amazon Resource Name (ARN).

type SelectionRules

string

param SelectionRules

[REQUIRED]

A value that specifies the database objects to import.

type Origin

string

param Origin

[REQUIRED]

Whether to load metadata to the source or target database.

type Refresh

boolean

param Refresh

If true , DMS loads metadata for the specified objects from the source database.

rtype

dict

returns

Response Syntax

{
    'RequestIdentifier': 'string'
}

Response Structure

  • (dict) --

    • RequestIdentifier (string) --

      The identifier for the import operation.

ModifyInstanceProfile (new) Link ¶

Modifies the specified instance profile using the provided parameters.

Note

All migration projects associated with the instance profile must be deleted or modified before you can modify the instance profile.

See also: AWS API Documentation

Request Syntax

client.modify_instance_profile(
    InstanceProfileIdentifier='string',
    AvailabilityZone='string',
    KmsKeyArn='string',
    PubliclyAccessible=True|False,
    NetworkType='string',
    InstanceProfileName='string',
    Description='string',
    SubnetGroupIdentifier='string',
    VpcSecurityGroups=[
        'string',
    ]
)
type InstanceProfileIdentifier

string

param InstanceProfileIdentifier

[REQUIRED]

The identifier of the instance profile. Identifiers must begin with a letter and must contain only ASCII letters, digits, and hyphens. They can't end with a hyphen, or contain two consecutive hyphens.

type AvailabilityZone

string

param AvailabilityZone

The Availability Zone where the instance profile runs.

type KmsKeyArn

string

param KmsKeyArn

The Amazon Resource Name (ARN) of the KMS key that is used to encrypt the connection parameters for the instance profile.

If you don't specify a value for the KmsKeyArn parameter, then DMS uses your default encryption key.

KMS creates the default encryption key for your Amazon Web Services account. Your Amazon Web Services account has a different default encryption key for each Amazon Web Services Region.

type PubliclyAccessible

boolean

param PubliclyAccessible

Specifies the accessibility options for the instance profile. A value of true represents an instance profile with a public IP address. A value of false represents an instance profile with a private IP address. The default value is true .

type NetworkType

string

param NetworkType

Specifies the network type for the instance profile. A value of IPV4 represents an instance profile with IPv4 network type and only supports IPv4 addressing. A value of IPV6 represents an instance profile with IPv6 network type and only supports IPv6 addressing. A value of DUAL represents an instance profile with dual network type that supports IPv4 and IPv6 addressing.

type InstanceProfileName

string

param InstanceProfileName

A user-friendly name for the instance profile.

type Description

string

param Description

A user-friendly description for the instance profile.

type SubnetGroupIdentifier

string

param SubnetGroupIdentifier

A subnet group to associate with the instance profile.

type VpcSecurityGroups

list

param VpcSecurityGroups

Specifies the VPC security groups to be used with the instance profile. The VPC security group must work with the VPC containing the instance profile.

  • (string) --

rtype

dict

returns

Response Syntax

{
    'InstanceProfile': {
        'InstanceProfileArn': 'string',
        'AvailabilityZone': 'string',
        'KmsKeyArn': 'string',
        'PubliclyAccessible': True|False,
        'NetworkType': 'string',
        'InstanceProfileName': 'string',
        'Description': 'string',
        'InstanceProfileCreationTime': datetime(2015, 1, 1),
        'SubnetGroupIdentifier': 'string',
        'VpcSecurityGroups': [
            'string',
        ]
    }
}

Response Structure

  • (dict) --

    • InstanceProfile (dict) --

      The instance profile that was modified.

      • InstanceProfileArn (string) --

        The Amazon Resource Name (ARN) string that uniquely identifies the instance profile.

      • AvailabilityZone (string) --

        The Availability Zone where the instance profile runs.

      • KmsKeyArn (string) --

        The Amazon Resource Name (ARN) of the KMS key that is used to encrypt the connection parameters for the instance profile.

        If you don't specify a value for the KmsKeyArn parameter, then DMS uses your default encryption key.

        KMS creates the default encryption key for your Amazon Web Services account. Your Amazon Web Services account has a different default encryption key for each Amazon Web Services Region.

      • PubliclyAccessible (boolean) --

        Specifies the accessibility options for the instance profile. A value of true represents an instance profile with a public IP address. A value of false represents an instance profile with a private IP address. The default value is true .

      • NetworkType (string) --

        Specifies the network type for the instance profile. A value of IPV4 represents an instance profile with IPv4 network type and only supports IPv4 addressing. A value of IPV6 represents an instance profile with IPv6 network type and only supports IPv6 addressing. A value of DUAL represents an instance profile with dual network type that supports IPv4 and IPv6 addressing.

      • InstanceProfileName (string) --

        The user-friendly name for the instance profile.

      • Description (string) --

        A description of the instance profile. Descriptions can have up to 31 characters. A description can contain only ASCII letters, digits, and hyphens ('-'). Also, it can't end with a hyphen or contain two consecutive hyphens, and can only begin with a letter.

      • InstanceProfileCreationTime (datetime) --

        The time the instance profile was created.

      • SubnetGroupIdentifier (string) --

        The identifier of the subnet group that is associated with the instance profile.

      • VpcSecurityGroups (list) --

        The VPC security groups that are used with the instance profile. The VPC security group must work with the VPC containing the instance profile.

        • (string) --

StartExtensionPackAssociation (new) Link ¶

Applies the extension pack to your target database. An extension pack is an add-on module that emulates functions present in a source database that are required when converting objects to the target database.

See also: AWS API Documentation

Request Syntax

client.start_extension_pack_association(
    MigrationProjectIdentifier='string'
)
type MigrationProjectIdentifier

string

param MigrationProjectIdentifier

[REQUIRED]

The migration project name or Amazon Resource Name (ARN).

rtype

dict

returns

Response Syntax

{
    'RequestIdentifier': 'string'
}

Response Structure

  • (dict) --

    • RequestIdentifier (string) --

      The identifier for the request operation.

StartMetadataModelAssessment (new) Link ¶

Creates a database migration assessment report by assessing the migration complexity for your source database. A database migration assessment report summarizes all of the schema conversion tasks. It also details the action items for database objects that can't be converted to the database engine of your target database instance.

See also: AWS API Documentation

Request Syntax

client.start_metadata_model_assessment(
    MigrationProjectIdentifier='string',
    SelectionRules='string'
)
type MigrationProjectIdentifier

string

param MigrationProjectIdentifier

[REQUIRED]

The migration project name or Amazon Resource Name (ARN).

type SelectionRules

string

param SelectionRules

[REQUIRED]

A value that specifies the database objects to assess.

rtype

dict

returns

Response Syntax

{
    'RequestIdentifier': 'string'
}

Response Structure

  • (dict) --

    • RequestIdentifier (string) --

      The identifier for the assessment operation.

DescribeMigrationProjects (new) Link ¶

Returns a paginated list of migration projects for your account in the current region.

See also: AWS API Documentation

Request Syntax

client.describe_migration_projects(
    Filters=[
        {
            'Name': 'string',
            'Values': [
                'string',
            ]
        },
    ],
    MaxRecords=123,
    Marker='string'
)
type Filters

list

param Filters

Filters applied to the migration projects described in the form of key-value pairs.

  • (dict) --

    Identifies the name and value of a filter object. This filter is used to limit the number and type of DMS objects that are returned for a particular Describe* call or similar operation. Filters are used as an optional parameter for certain API operations.

    • Name (string) -- [REQUIRED]

      The name of the filter as specified for a Describe* or similar operation.

    • Values (list) -- [REQUIRED]

      The filter value, which can specify one or more values used to narrow the returned results.

      • (string) --

type MaxRecords

integer

param MaxRecords

The maximum number of records to include in the response. If more records exist than the specified MaxRecords value, DMS includes a pagination token in the response so that you can retrieve the remaining results.

type Marker

string

param Marker

Specifies the unique pagination token that makes it possible to display the next page of results. If this parameter is specified, the response includes only records beyond the marker, up to the value specified by MaxRecords .

If Marker is returned by a previous response, there are more results available. The value of Marker is a unique pagination token for each page. To retrieve the next page, make the call again using the returned token and keeping all other arguments unchanged.

rtype

dict

returns

Response Syntax

{
    'Marker': 'string',
    'MigrationProjects': [
        {
            'MigrationProjectName': 'string',
            'MigrationProjectArn': 'string',
            'MigrationProjectCreationTime': datetime(2015, 1, 1),
            'SourceDataProviderDescriptors': [
                {
                    'SecretsManagerSecretId': 'string',
                    'SecretsManagerAccessRoleArn': 'string',
                    'DataProviderName': 'string',
                    'DataProviderArn': 'string'
                },
            ],
            'TargetDataProviderDescriptors': [
                {
                    'SecretsManagerSecretId': 'string',
                    'SecretsManagerAccessRoleArn': 'string',
                    'DataProviderName': 'string',
                    'DataProviderArn': 'string'
                },
            ],
            'InstanceProfileArn': 'string',
            'InstanceProfileName': 'string',
            'TransformationRules': 'string',
            'Description': 'string',
            'SchemaConversionApplicationAttributes': {
                'S3BucketPath': 'string',
                'S3BucketRoleArn': 'string'
            }
        },
    ]
}

Response Structure

  • (dict) --

    • Marker (string) --

      Specifies the unique pagination token that makes it possible to display the next page of results. If this parameter is specified, the response includes only records beyond the marker, up to the value specified by MaxRecords .

      If Marker is returned by a previous response, there are more results available. The value of Marker is a unique pagination token for each page. To retrieve the next page, make the call again using the returned token and keeping all other arguments unchanged.

    • MigrationProjects (list) --

      A description of migration projects.

      • (dict) --

        Provides information that defines a migration project.

        • MigrationProjectName (string) --

          The name of the migration project.

        • MigrationProjectArn (string) --

          The ARN string that uniquely identifies the migration project.

        • MigrationProjectCreationTime (datetime) --

          The time when the migration project was created.

        • SourceDataProviderDescriptors (list) --

          Information about the source data provider, including the name or ARN, and Secrets Manager parameters.

          • (dict) --

            Information about a data provider.

            • SecretsManagerSecretId (string) --

              The identifier of the Amazon Web Services Secrets Manager Secret used to store access credentials for the data provider.

            • SecretsManagerAccessRoleArn (string) --

              The ARN of the role used to access Amazon Web Services Secrets Manager.

            • DataProviderName (string) --

              The user-friendly name of the data provider.

            • DataProviderArn (string) --

              The Amazon Resource Name (ARN) of the data provider.

        • TargetDataProviderDescriptors (list) --

          Information about the target data provider, including the name or ARN, and Secrets Manager parameters.

          • (dict) --

            Information about a data provider.

            • SecretsManagerSecretId (string) --

              The identifier of the Amazon Web Services Secrets Manager Secret used to store access credentials for the data provider.

            • SecretsManagerAccessRoleArn (string) --

              The ARN of the role used to access Amazon Web Services Secrets Manager.

            • DataProviderName (string) --

              The user-friendly name of the data provider.

            • DataProviderArn (string) --

              The Amazon Resource Name (ARN) of the data provider.

        • InstanceProfileArn (string) --

          The Amazon Resource Name (ARN) of the instance profile for your migration project.

        • InstanceProfileName (string) --

          The name of the associated instance profile.

        • TransformationRules (string) --

          The settings in JSON format for migration rules. Migration rules make it possible for you to change the object names according to the rules that you specify. For example, you can change an object name to lowercase or uppercase, add or remove a prefix or suffix, or rename objects.

        • Description (string) --

          A user-friendly description of the migration project.

        • SchemaConversionApplicationAttributes (dict) --

          The schema conversion application attributes, including the Amazon S3 bucket name and Amazon S3 role ARN.

          • S3BucketPath (string) --

            The path for the Amazon S3 bucket that the application uses for exporting assessment reports.

          • S3BucketRoleArn (string) --

            The ARN for the role the application uses to access its Amazon S3 bucket.

DescribeDataProviders (new) Link ¶

Returns a paginated list of data providers for your account in the current region.

See also: AWS API Documentation

Request Syntax

client.describe_data_providers(
    Filters=[
        {
            'Name': 'string',
            'Values': [
                'string',
            ]
        },
    ],
    MaxRecords=123,
    Marker='string'
)
type Filters

list

param Filters

Filters applied to the data providers described in the form of key-value pairs.

  • (dict) --

    Identifies the name and value of a filter object. This filter is used to limit the number and type of DMS objects that are returned for a particular Describe* call or similar operation. Filters are used as an optional parameter for certain API operations.

    • Name (string) -- [REQUIRED]

      The name of the filter as specified for a Describe* or similar operation.

    • Values (list) -- [REQUIRED]

      The filter value, which can specify one or more values used to narrow the returned results.

      • (string) --

type MaxRecords

integer

param MaxRecords

The maximum number of records to include in the response. If more records exist than the specified MaxRecords value, DMS includes a pagination token in the response so that you can retrieve the remaining results.

type Marker

string

param Marker

Specifies the unique pagination token that makes it possible to display the next page of results. If this parameter is specified, the response includes only records beyond the marker, up to the value specified by MaxRecords .

If Marker is returned by a previous response, there are more results available. The value of Marker is a unique pagination token for each page. To retrieve the next page, make the call again using the returned token and keeping all other arguments unchanged.

rtype

dict

returns

Response Syntax

{
    'Marker': 'string',
    'DataProviders': [
        {
            'DataProviderName': 'string',
            'DataProviderArn': 'string',
            'DataProviderCreationTime': datetime(2015, 1, 1),
            'Description': 'string',
            'Engine': 'string',
            'Settings': {
                'PostgreSqlSettings': {
                    'ServerName': 'string',
                    'Port': 123,
                    'DatabaseName': 'string',
                    'SslMode': 'none'|'require'|'verify-ca'|'verify-full',
                    'CertificateArn': 'string'
                },
                'MySqlSettings': {
                    'ServerName': 'string',
                    'Port': 123,
                    'SslMode': 'none'|'require'|'verify-ca'|'verify-full',
                    'CertificateArn': 'string'
                },
                'OracleSettings': {
                    'ServerName': 'string',
                    'Port': 123,
                    'DatabaseName': 'string',
                    'SslMode': 'none'|'require'|'verify-ca'|'verify-full',
                    'CertificateArn': 'string',
                    'AsmServer': 'string',
                    'SecretsManagerOracleAsmSecretId': 'string',
                    'SecretsManagerOracleAsmAccessRoleArn': 'string',
                    'SecretsManagerSecurityDbEncryptionSecretId': 'string',
                    'SecretsManagerSecurityDbEncryptionAccessRoleArn': 'string'
                },
                'MicrosoftSqlServerSettings': {
                    'ServerName': 'string',
                    'Port': 123,
                    'DatabaseName': 'string',
                    'SslMode': 'none'|'require'|'verify-ca'|'verify-full',
                    'CertificateArn': 'string'
                }
            }
        },
    ]
}

Response Structure

  • (dict) --

    • Marker (string) --

      Specifies the unique pagination token that makes it possible to display the next page of results. If this parameter is specified, the response includes only records beyond the marker, up to the value specified by MaxRecords .

      If Marker is returned by a previous response, there are more results available. The value of Marker is a unique pagination token for each page. To retrieve the next page, make the call again using the returned token and keeping all other arguments unchanged.

    • DataProviders (list) --

      A description of data providers.

      • (dict) --

        Provides information that defines a data provider.

        • DataProviderName (string) --

          The name of the data provider.

        • DataProviderArn (string) --

          The Amazon Resource Name (ARN) string that uniquely identifies the data provider.

        • DataProviderCreationTime (datetime) --

          The time the data provider was created.

        • Description (string) --

          A description of the data provider. Descriptions can have up to 31 characters. A description can contain only ASCII letters, digits, and hyphens ('-'). Also, it can't end with a hyphen or contain two consecutive hyphens, and can only begin with a letter.

        • Engine (string) --

          The type of database engine for the data provider. Valid values include "aurora" , "aurora_postgresql" , "mysql" , "oracle" , "postgres" , and "sqlserver" . A value of "aurora" represents Amazon Aurora MySQL-Compatible Edition.

        • Settings (dict) --

          The settings in JSON format for a data provider.

          • PostgreSqlSettings (dict) --

            Provides information that defines a PostgreSQL data provider.

            • ServerName (string) --

              The name of the PostgreSQL server.

            • Port (integer) --

              The port value for the PostgreSQL data provider.

            • DatabaseName (string) --

              The database name on the PostgreSQL data provider.

            • SslMode (string) --

              The SSL mode used to connect to the PostgreSQL data provider. The default value is none .

            • CertificateArn (string) --

              The Amazon Resource Name (ARN) of the certificate used for SSL connection.

          • MySqlSettings (dict) --

            Provides information that defines a MySQL data provider.

            • ServerName (string) --

              The name of the MySQL server.

            • Port (integer) --

              The port value for the MySQL data provider.

            • SslMode (string) --

              The SSL mode used to connect to the MySQL data provider. The default value is none .

            • CertificateArn (string) --

              The Amazon Resource Name (ARN) of the certificate used for SSL connection.

          • OracleSettings (dict) --

            Provides information that defines an Oracle data provider.

            • ServerName (string) --

              The name of the Oracle server.

            • Port (integer) --

              The port value for the Oracle data provider.

            • DatabaseName (string) --

              The database name on the Oracle data provider.

            • SslMode (string) --

              The SSL mode used to connect to the Oracle data provider. The default value is none .

            • CertificateArn (string) --

              The Amazon Resource Name (ARN) of the certificate used for SSL connection.

            • AsmServer (string) --

              The address of your Oracle Automatic Storage Management (ASM) server. You can set this value from the asm_server value. You set asm_server as part of the extra connection attribute string to access an Oracle server with Binary Reader that uses ASM. For more information, see Configuration for change data capture (CDC) on an Oracle source database .

            • SecretsManagerOracleAsmSecretId (string) --

              The identifier of the secret in Secrets Manager that contains the Oracle ASM connection details.

              Required only if your data provider uses the Oracle ASM server.

            • SecretsManagerOracleAsmAccessRoleArn (string) --

              The ARN of the IAM role that provides access to the secret in Secrets Manager that contains the Oracle ASM connection details.

            • SecretsManagerSecurityDbEncryptionSecretId (string) --

              The identifier of the secret in Secrets Manager that contains the transparent data encryption (TDE) password. DMS requires this password to access Oracle redo logs encrypted by TDE using Binary Reader.

            • SecretsManagerSecurityDbEncryptionAccessRoleArn (string) --

              The ARN of the IAM role that provides access to the secret in Secrets Manager that contains the TDE password.

          • MicrosoftSqlServerSettings (dict) --

            Provides information that defines a Microsoft SQL Server data provider.

            • ServerName (string) --

              The name of the Microsoft SQL Server server.

            • Port (integer) --

              The port value for the Microsoft SQL Server data provider.

            • DatabaseName (string) --

              The database name on the Microsoft SQL Server data provider.

            • SslMode (string) --

              The SSL mode used to connect to the Microsoft SQL Server data provider. The default value is none .

            • CertificateArn (string) --

              The Amazon Resource Name (ARN) of the certificate used for SSL connection.

DescribeMetadataModelImports (new) Link ¶

Returns a paginated list of metadata model imports.

See also: AWS API Documentation

Request Syntax

client.describe_metadata_model_imports(
    MigrationProjectIdentifier='string',
    Filters=[
        {
            'Name': 'string',
            'Values': [
                'string',
            ]
        },
    ],
    Marker='string',
    MaxRecords=123
)
type MigrationProjectIdentifier

string

param MigrationProjectIdentifier

[REQUIRED]

The migration project name or Amazon Resource Name (ARN).

type Filters

list

param Filters

Filters applied to the metadata model imports described in the form of key-value pairs.

  • (dict) --

    Identifies the name and value of a filter object. This filter is used to limit the number and type of DMS objects that are returned for a particular Describe* call or similar operation. Filters are used as an optional parameter for certain API operations.

    • Name (string) -- [REQUIRED]

      The name of the filter as specified for a Describe* or similar operation.

    • Values (list) -- [REQUIRED]

      The filter value, which can specify one or more values used to narrow the returned results.

      • (string) --

type Marker

string

param Marker

Specifies the unique pagination token that makes it possible to display the next page of results. If this parameter is specified, the response includes only records beyond the marker, up to the value specified by MaxRecords .

If Marker is returned by a previous response, there are more results available. The value of Marker is a unique pagination token for each page. To retrieve the next page, make the call again using the returned token and keeping all other arguments unchanged.

type MaxRecords

integer

param MaxRecords

A paginated list of metadata model imports.

rtype

dict

returns

Response Syntax

{
    'Marker': 'string',
    'Requests': [
        {
            'Status': 'string',
            'RequestIdentifier': 'string',
            'MigrationProjectArn': 'string',
            'Error': {
                'defaultErrorDetails': {
                    'Message': 'string'
                }
            },
            'ExportSqlDetails': {
                'S3ObjectKey': 'string',
                'ObjectURL': 'string'
            }
        },
    ]
}

Response Structure

  • (dict) --

    • Marker (string) --

      Specifies the unique pagination token that makes it possible to display the next page of results. If this parameter is specified, the response includes only records beyond the marker, up to the value specified by MaxRecords .

      If Marker is returned by a previous response, there are more results available. The value of Marker is a unique pagination token for each page. To retrieve the next page, make the call again using the returned token and keeping all other arguments unchanged.

    • Requests (list) --

      A paginated list of metadata model imports.

      • (dict) --

        Provides information about a schema conversion action.

        • Status (string) --

          The schema conversion action status.

        • RequestIdentifier (string) --

          The identifier for the schema conversion action.

        • MigrationProjectArn (string) --

          The migration project ARN.

        • Error (dict) --

          Provides error information about a project.

          • defaultErrorDetails (dict) --

            Error information about a project.

            • Message (string) --

              The error message.

        • ExportSqlDetails (dict) --

          Provides information about a metadata model assessment exported to SQL.

          • S3ObjectKey (string) --

            The Amazon S3 object key for the object containing the exported metadata model assessment.

          • ObjectURL (string) --

            The URL for the object containing the exported metadata model assessment.

DeleteInstanceProfile (new) Link ¶

Deletes the specified instance profile.

Note

All migration projects associated with the instance profile must be deleted or modified before you can delete the instance profile.

See also: AWS API Documentation

Request Syntax

client.delete_instance_profile(
    InstanceProfileIdentifier='string'
)
type InstanceProfileIdentifier

string

param InstanceProfileIdentifier

[REQUIRED]

The identifier of the instance profile to delete.

rtype

dict

returns

Response Syntax

{
    'InstanceProfile': {
        'InstanceProfileArn': 'string',
        'AvailabilityZone': 'string',
        'KmsKeyArn': 'string',
        'PubliclyAccessible': True|False,
        'NetworkType': 'string',
        'InstanceProfileName': 'string',
        'Description': 'string',
        'InstanceProfileCreationTime': datetime(2015, 1, 1),
        'SubnetGroupIdentifier': 'string',
        'VpcSecurityGroups': [
            'string',
        ]
    }
}

Response Structure

  • (dict) --

    • InstanceProfile (dict) --

      The instance profile that was deleted.

      • InstanceProfileArn (string) --

        The Amazon Resource Name (ARN) string that uniquely identifies the instance profile.

      • AvailabilityZone (string) --

        The Availability Zone where the instance profile runs.

      • KmsKeyArn (string) --

        The Amazon Resource Name (ARN) of the KMS key that is used to encrypt the connection parameters for the instance profile.

        If you don't specify a value for the KmsKeyArn parameter, then DMS uses your default encryption key.

        KMS creates the default encryption key for your Amazon Web Services account. Your Amazon Web Services account has a different default encryption key for each Amazon Web Services Region.

      • PubliclyAccessible (boolean) --

        Specifies the accessibility options for the instance profile. A value of true represents an instance profile with a public IP address. A value of false represents an instance profile with a private IP address. The default value is true .

      • NetworkType (string) --

        Specifies the network type for the instance profile. A value of IPV4 represents an instance profile with IPv4 network type and only supports IPv4 addressing. A value of IPV6 represents an instance profile with IPv6 network type and only supports IPv6 addressing. A value of DUAL represents an instance profile with dual network type that supports IPv4 and IPv6 addressing.

      • InstanceProfileName (string) --

        The user-friendly name for the instance profile.

      • Description (string) --

        A description of the instance profile. Descriptions can have up to 31 characters. A description can contain only ASCII letters, digits, and hyphens ('-'). Also, it can't end with a hyphen or contain two consecutive hyphens, and can only begin with a letter.

      • InstanceProfileCreationTime (datetime) --

        The time the instance profile was created.

      • SubnetGroupIdentifier (string) --

        The identifier of the subnet group that is associated with the instance profile.

      • VpcSecurityGroups (list) --

        The VPC security groups that are used with the instance profile. The VPC security group must work with the VPC containing the instance profile.

        • (string) --

StartMetadataModelConversion (new) Link ¶

Converts your source database objects to a format compatible with the target database.

See also: AWS API Documentation

Request Syntax

client.start_metadata_model_conversion(
    MigrationProjectIdentifier='string',
    SelectionRules='string'
)
type MigrationProjectIdentifier

string

param MigrationProjectIdentifier

[REQUIRED]

The migration project name or Amazon Resource Name (ARN).

type SelectionRules

string

param SelectionRules

[REQUIRED]

A value that specifies the database objects to convert.

rtype

dict

returns

Response Syntax

{
    'RequestIdentifier': 'string'
}

Response Structure

  • (dict) --

    • RequestIdentifier (string) --

      The identifier for the conversion operation.

DescribeConversionConfiguration (new) Link ¶

Returns configuration parameters for a schema conversion project.

See also: AWS API Documentation

Request Syntax

client.describe_conversion_configuration(
    MigrationProjectIdentifier='string'
)
type MigrationProjectIdentifier

string

param MigrationProjectIdentifier

[REQUIRED]

The name or Amazon Resource Name (ARN) for the schema conversion project to describe.

rtype

dict

returns

Response Syntax

{
    'MigrationProjectIdentifier': 'string',
    'ConversionConfiguration': 'string'
}

Response Structure

  • (dict) --

    • MigrationProjectIdentifier (string) --

      The name or Amazon Resource Name (ARN) for the schema conversion project.

    • ConversionConfiguration (string) --

      The configuration parameters for the schema conversion project.

DescribeMetadataModelExportsToTarget (new) Link ¶

Returns a paginated list of metadata model exports.

See also: AWS API Documentation

Request Syntax

client.describe_metadata_model_exports_to_target(
    MigrationProjectIdentifier='string',
    Filters=[
        {
            'Name': 'string',
            'Values': [
                'string',
            ]
        },
    ],
    Marker='string',
    MaxRecords=123
)
type MigrationProjectIdentifier

string

param MigrationProjectIdentifier

[REQUIRED]

The migration project name or Amazon Resource Name (ARN).

type Filters

list

param Filters

Filters applied to the metadata model exports described in the form of key-value pairs.

  • (dict) --

    Identifies the name and value of a filter object. This filter is used to limit the number and type of DMS objects that are returned for a particular Describe* call or similar operation. Filters are used as an optional parameter for certain API operations.

    • Name (string) -- [REQUIRED]

      The name of the filter as specified for a Describe* or similar operation.

    • Values (list) -- [REQUIRED]

      The filter value, which can specify one or more values used to narrow the returned results.

      • (string) --

type Marker

string

param Marker

Specifies the unique pagination token that makes it possible to display the next page of results. If this parameter is specified, the response includes only records beyond the marker, up to the value specified by MaxRecords .

If Marker is returned by a previous response, there are more results available. The value of Marker is a unique pagination token for each page. To retrieve the next page, make the call again using the returned token and keeping all other arguments unchanged.

type MaxRecords

integer

param MaxRecords

The maximum number of records to include in the response. If more records exist than the specified MaxRecords value, DMS includes a pagination token in the response so that you can retrieve the remaining results.

rtype

dict

returns

Response Syntax

{
    'Marker': 'string',
    'Requests': [
        {
            'Status': 'string',
            'RequestIdentifier': 'string',
            'MigrationProjectArn': 'string',
            'Error': {
                'defaultErrorDetails': {
                    'Message': 'string'
                }
            },
            'ExportSqlDetails': {
                'S3ObjectKey': 'string',
                'ObjectURL': 'string'
            }
        },
    ]
}

Response Structure

  • (dict) --

    • Marker (string) --

      Specifies the unique pagination token that makes it possible to display the next page of results. If this parameter is specified, the response includes only records beyond the marker, up to the value specified by MaxRecords .

      If Marker is returned by a previous response, there are more results available. The value of Marker is a unique pagination token for each page. To retrieve the next page, make the call again using the returned token and keeping all other arguments unchanged.

    • Requests (list) --

      A paginated list of metadata model exports.

      • (dict) --

        Provides information about a schema conversion action.

        • Status (string) --

          The schema conversion action status.

        • RequestIdentifier (string) --

          The identifier for the schema conversion action.

        • MigrationProjectArn (string) --

          The migration project ARN.

        • Error (dict) --

          Provides error information about a project.

          • defaultErrorDetails (dict) --

            Error information about a project.

            • Message (string) --

              The error message.

        • ExportSqlDetails (dict) --

          Provides information about a metadata model assessment exported to SQL.

          • S3ObjectKey (string) --

            The Amazon S3 object key for the object containing the exported metadata model assessment.

          • ObjectURL (string) --

            The URL for the object containing the exported metadata model assessment.

CreateMigrationProject (new) Link ¶

Creates the migration project using the specified parameters.

You can run this action only after you create an instance profile and data providers using CreateInstanceProfile and CreateDataProvider .

See also: AWS API Documentation

Request Syntax

client.create_migration_project(
    MigrationProjectName='string',
    SourceDataProviderDescriptors=[
        {
            'DataProviderIdentifier': 'string',
            'SecretsManagerSecretId': 'string',
            'SecretsManagerAccessRoleArn': 'string'
        },
    ],
    TargetDataProviderDescriptors=[
        {
            'DataProviderIdentifier': 'string',
            'SecretsManagerSecretId': 'string',
            'SecretsManagerAccessRoleArn': 'string'
        },
    ],
    InstanceProfileIdentifier='string',
    TransformationRules='string',
    Description='string',
    Tags=[
        {
            'Key': 'string',
            'Value': 'string',
            'ResourceArn': 'string'
        },
    ],
    SchemaConversionApplicationAttributes={
        'S3BucketPath': 'string',
        'S3BucketRoleArn': 'string'
    }
)
type MigrationProjectName

string

param MigrationProjectName

A user-friendly name for the migration project.

type SourceDataProviderDescriptors

list

param SourceDataProviderDescriptors

[REQUIRED]

Information about the source data provider, including the name, ARN, and Secrets Manager parameters.

  • (dict) --

    Information about a data provider.

    • DataProviderIdentifier (string) -- [REQUIRED]

      The name or Amazon Resource Name (ARN) of the data provider.

    • SecretsManagerSecretId (string) --

      The identifier of the Amazon Web Services Secrets Manager Secret used to store access credentials for the data provider.

    • SecretsManagerAccessRoleArn (string) --

      The ARN of the role used to access Amazon Web Services Secrets Manager.

type TargetDataProviderDescriptors

list

param TargetDataProviderDescriptors

[REQUIRED]

Information about the target data provider, including the name, ARN, and Amazon Web Services Secrets Manager parameters.

  • (dict) --

    Information about a data provider.

    • DataProviderIdentifier (string) -- [REQUIRED]

      The name or Amazon Resource Name (ARN) of the data provider.

    • SecretsManagerSecretId (string) --

      The identifier of the Amazon Web Services Secrets Manager Secret used to store access credentials for the data provider.

    • SecretsManagerAccessRoleArn (string) --

      The ARN of the role used to access Amazon Web Services Secrets Manager.

type InstanceProfileIdentifier

string

param InstanceProfileIdentifier

[REQUIRED]

The identifier of the associated instance profile. Identifiers must begin with a letter and must contain only ASCII letters, digits, and hyphens. They can't end with a hyphen, or contain two consecutive hyphens.

type TransformationRules

string

param TransformationRules

The settings in JSON format for migration rules. Migration rules make it possible for you to change the object names according to the rules that you specify. For example, you can change an object name to lowercase or uppercase, add or remove a prefix or suffix, or rename objects.

type Description

string

param Description

A user-friendly description of the migration project.

type Tags

list

param Tags

One or more tags to be assigned to the migration project.

  • (dict) --

    A user-defined key-value pair that describes metadata added to an DMS resource and that is used by operations such as the following:

    • AddTagsToResource

    • ListTagsForResource

    • RemoveTagsFromResource

    • Key (string) --

      A key is the required name of the tag. The string value can be 1-128 Unicode characters in length and can't be prefixed with "aws:" or "dms:". The string can only contain only the set of Unicode letters, digits, white-space, '_', '.', '/', '=', '+', '-' (Java regular expressions: "^([\p{L}\p{Z}\p{N}_.:/=+\-]*)$").

    • Value (string) --

      A value is the optional value of the tag. The string value can be 1-256 Unicode characters in length and can't be prefixed with "aws:" or "dms:". The string can only contain only the set of Unicode letters, digits, white-space, '_', '.', '/', '=', '+', '-' (Java regular expressions: "^([\p{L}\p{Z}\p{N}_.:/=+\-]*)$").

    • ResourceArn (string) --

      The Amazon Resource Name (ARN) string that uniquely identifies the resource for which the tag is created.

type SchemaConversionApplicationAttributes

dict

param SchemaConversionApplicationAttributes

The schema conversion application attributes, including the Amazon S3 bucket name and Amazon S3 role ARN.

  • S3BucketPath (string) --

    The path for the Amazon S3 bucket that the application uses for exporting assessment reports.

  • S3BucketRoleArn (string) --

    The ARN for the role the application uses to access its Amazon S3 bucket.

rtype

dict

returns

Response Syntax

{
    'MigrationProject': {
        'MigrationProjectName': 'string',
        'MigrationProjectArn': 'string',
        'MigrationProjectCreationTime': datetime(2015, 1, 1),
        'SourceDataProviderDescriptors': [
            {
                'SecretsManagerSecretId': 'string',
                'SecretsManagerAccessRoleArn': 'string',
                'DataProviderName': 'string',
                'DataProviderArn': 'string'
            },
        ],
        'TargetDataProviderDescriptors': [
            {
                'SecretsManagerSecretId': 'string',
                'SecretsManagerAccessRoleArn': 'string',
                'DataProviderName': 'string',
                'DataProviderArn': 'string'
            },
        ],
        'InstanceProfileArn': 'string',
        'InstanceProfileName': 'string',
        'TransformationRules': 'string',
        'Description': 'string',
        'SchemaConversionApplicationAttributes': {
            'S3BucketPath': 'string',
            'S3BucketRoleArn': 'string'
        }
    }
}

Response Structure

  • (dict) --

    • MigrationProject (dict) --

      The migration project that was created.

      • MigrationProjectName (string) --

        The name of the migration project.

      • MigrationProjectArn (string) --

        The ARN string that uniquely identifies the migration project.

      • MigrationProjectCreationTime (datetime) --

        The time when the migration project was created.

      • SourceDataProviderDescriptors (list) --

        Information about the source data provider, including the name or ARN, and Secrets Manager parameters.

        • (dict) --

          Information about a data provider.

          • SecretsManagerSecretId (string) --

            The identifier of the Amazon Web Services Secrets Manager Secret used to store access credentials for the data provider.

          • SecretsManagerAccessRoleArn (string) --

            The ARN of the role used to access Amazon Web Services Secrets Manager.

          • DataProviderName (string) --

            The user-friendly name of the data provider.

          • DataProviderArn (string) --

            The Amazon Resource Name (ARN) of the data provider.

      • TargetDataProviderDescriptors (list) --

        Information about the target data provider, including the name or ARN, and Secrets Manager parameters.

        • (dict) --

          Information about a data provider.

          • SecretsManagerSecretId (string) --

            The identifier of the Amazon Web Services Secrets Manager Secret used to store access credentials for the data provider.

          • SecretsManagerAccessRoleArn (string) --

            The ARN of the role used to access Amazon Web Services Secrets Manager.

          • DataProviderName (string) --

            The user-friendly name of the data provider.

          • DataProviderArn (string) --

            The Amazon Resource Name (ARN) of the data provider.

      • InstanceProfileArn (string) --

        The Amazon Resource Name (ARN) of the instance profile for your migration project.

      • InstanceProfileName (string) --

        The name of the associated instance profile.

      • TransformationRules (string) --

        The settings in JSON format for migration rules. Migration rules make it possible for you to change the object names according to the rules that you specify. For example, you can change an object name to lowercase or uppercase, add or remove a prefix or suffix, or rename objects.

      • Description (string) --

        A user-friendly description of the migration project.

      • SchemaConversionApplicationAttributes (dict) --

        The schema conversion application attributes, including the Amazon S3 bucket name and Amazon S3 role ARN.

        • S3BucketPath (string) --

          The path for the Amazon S3 bucket that the application uses for exporting assessment reports.

        • S3BucketRoleArn (string) --

          The ARN for the role the application uses to access its Amazon S3 bucket.

DescribeMetadataModelConversions (new) Link ¶

Returns a paginated list of metadata model conversions for a migration project.

See also: AWS API Documentation

Request Syntax

client.describe_metadata_model_conversions(
    MigrationProjectIdentifier='string',
    Filters=[
        {
            'Name': 'string',
            'Values': [
                'string',
            ]
        },
    ],
    Marker='string',
    MaxRecords=123
)
type MigrationProjectIdentifier

string

param MigrationProjectIdentifier

[REQUIRED]

The migration project name or Amazon Resource Name (ARN).

type Filters

list

param Filters

Filters applied to the metadata model conversions described in the form of key-value pairs.

  • (dict) --

    Identifies the name and value of a filter object. This filter is used to limit the number and type of DMS objects that are returned for a particular Describe* call or similar operation. Filters are used as an optional parameter for certain API operations.

    • Name (string) -- [REQUIRED]

      The name of the filter as specified for a Describe* or similar operation.

    • Values (list) -- [REQUIRED]

      The filter value, which can specify one or more values used to narrow the returned results.

      • (string) --

type Marker

string

param Marker

Specifies the unique pagination token that makes it possible to display the next page of results. If this parameter is specified, the response includes only records beyond the marker, up to the value specified by MaxRecords .

If Marker is returned by a previous response, there are more results available. The value of Marker is a unique pagination token for each page. To retrieve the next page, make the call again using the returned token and keeping all other arguments unchanged.

type MaxRecords

integer

param MaxRecords

The maximum number of records to include in the response. If more records exist than the specified MaxRecords value, DMS includes a pagination token in the response so that you can retrieve the remaining results.

rtype

dict

returns

Response Syntax

{
    'Marker': 'string',
    'Requests': [
        {
            'Status': 'string',
            'RequestIdentifier': 'string',
            'MigrationProjectArn': 'string',
            'Error': {
                'defaultErrorDetails': {
                    'Message': 'string'
                }
            },
            'ExportSqlDetails': {
                'S3ObjectKey': 'string',
                'ObjectURL': 'string'
            }
        },
    ]
}

Response Structure

  • (dict) --

    • Marker (string) --

      Specifies the unique pagination token that makes it possible to display the next page of results. If this parameter is specified, the response includes only records beyond the marker, up to the value specified by MaxRecords .

      If Marker is returned by a previous response, there are more results available. The value of Marker is a unique pagination token for each page. To retrieve the next page, make the call again using the returned token and keeping all other arguments unchanged.

    • Requests (list) --

      A paginated list of metadata model conversions.

      • (dict) --

        Provides information about a schema conversion action.

        • Status (string) --

          The schema conversion action status.

        • RequestIdentifier (string) --

          The identifier for the schema conversion action.

        • MigrationProjectArn (string) --

          The migration project ARN.

        • Error (dict) --

          Provides error information about a project.

          • defaultErrorDetails (dict) --

            Error information about a project.

            • Message (string) --

              The error message.

        • ExportSqlDetails (dict) --

          Provides information about a metadata model assessment exported to SQL.

          • S3ObjectKey (string) --

            The Amazon S3 object key for the object containing the exported metadata model assessment.

          • ObjectURL (string) --

            The URL for the object containing the exported metadata model assessment.

ModifyConversionConfiguration (new) Link ¶

Modifies the specified schema conversion configuration using the provided parameters.

See also: AWS API Documentation

Request Syntax

client.modify_conversion_configuration(
    MigrationProjectIdentifier='string',
    ConversionConfiguration='string'
)
type MigrationProjectIdentifier

string

param MigrationProjectIdentifier

[REQUIRED]

The migration project name or Amazon Resource Name (ARN).

type ConversionConfiguration

string

param ConversionConfiguration

[REQUIRED]

The new conversion configuration.

rtype

dict

returns

Response Syntax

{
    'MigrationProjectIdentifier': 'string'
}

Response Structure

  • (dict) --

    • MigrationProjectIdentifier (string) --

      The name or Amazon Resource Name (ARN) of the modified configuration.

DeleteMigrationProject (new) Link ¶

Deletes the specified migration project.

Note

The migration project must be closed before you can delete it.

See also: AWS API Documentation

Request Syntax

client.delete_migration_project(
    MigrationProjectIdentifier='string'
)
type MigrationProjectIdentifier

string

param MigrationProjectIdentifier

[REQUIRED]

The name or Amazon Resource Name (ARN) of the migration project to delete.

rtype

dict

returns

Response Syntax

{
    'MigrationProject': {
        'MigrationProjectName': 'string',
        'MigrationProjectArn': 'string',
        'MigrationProjectCreationTime': datetime(2015, 1, 1),
        'SourceDataProviderDescriptors': [
            {
                'SecretsManagerSecretId': 'string',
                'SecretsManagerAccessRoleArn': 'string',
                'DataProviderName': 'string',
                'DataProviderArn': 'string'
            },
        ],
        'TargetDataProviderDescriptors': [
            {
                'SecretsManagerSecretId': 'string',
                'SecretsManagerAccessRoleArn': 'string',
                'DataProviderName': 'string',
                'DataProviderArn': 'string'
            },
        ],
        'InstanceProfileArn': 'string',
        'InstanceProfileName': 'string',
        'TransformationRules': 'string',
        'Description': 'string',
        'SchemaConversionApplicationAttributes': {
            'S3BucketPath': 'string',
            'S3BucketRoleArn': 'string'
        }
    }
}

Response Structure

  • (dict) --

    • MigrationProject (dict) --

      The migration project that was deleted.

      • MigrationProjectName (string) --

        The name of the migration project.

      • MigrationProjectArn (string) --

        The ARN string that uniquely identifies the migration project.

      • MigrationProjectCreationTime (datetime) --

        The time when the migration project was created.

      • SourceDataProviderDescriptors (list) --

        Information about the source data provider, including the name or ARN, and Secrets Manager parameters.

        • (dict) --

          Information about a data provider.

          • SecretsManagerSecretId (string) --

            The identifier of the Amazon Web Services Secrets Manager Secret used to store access credentials for the data provider.

          • SecretsManagerAccessRoleArn (string) --

            The ARN of the role used to access Amazon Web Services Secrets Manager.

          • DataProviderName (string) --

            The user-friendly name of the data provider.

          • DataProviderArn (string) --

            The Amazon Resource Name (ARN) of the data provider.

      • TargetDataProviderDescriptors (list) --

        Information about the target data provider, including the name or ARN, and Secrets Manager parameters.

        • (dict) --

          Information about a data provider.

          • SecretsManagerSecretId (string) --

            The identifier of the Amazon Web Services Secrets Manager Secret used to store access credentials for the data provider.

          • SecretsManagerAccessRoleArn (string) --

            The ARN of the role used to access Amazon Web Services Secrets Manager.

          • DataProviderName (string) --

            The user-friendly name of the data provider.

          • DataProviderArn (string) --

            The Amazon Resource Name (ARN) of the data provider.

      • InstanceProfileArn (string) --

        The Amazon Resource Name (ARN) of the instance profile for your migration project.

      • InstanceProfileName (string) --

        The name of the associated instance profile.

      • TransformationRules (string) --

        The settings in JSON format for migration rules. Migration rules make it possible for you to change the object names according to the rules that you specify. For example, you can change an object name to lowercase or uppercase, add or remove a prefix or suffix, or rename objects.

      • Description (string) --

        A user-friendly description of the migration project.

      • SchemaConversionApplicationAttributes (dict) --

        The schema conversion application attributes, including the Amazon S3 bucket name and Amazon S3 role ARN.

        • S3BucketPath (string) --

          The path for the Amazon S3 bucket that the application uses for exporting assessment reports.

        • S3BucketRoleArn (string) --

          The ARN for the role the application uses to access its Amazon S3 bucket.

CreateDataProvider (new) Link ¶

Creates a data provider using the provided settings. A data provider stores a data store type and location information about your database.

See also: AWS API Documentation

Request Syntax

client.create_data_provider(
    DataProviderName='string',
    Description='string',
    Engine='string',
    Settings={
        'PostgreSqlSettings': {
            'ServerName': 'string',
            'Port': 123,
            'DatabaseName': 'string',
            'SslMode': 'none'|'require'|'verify-ca'|'verify-full',
            'CertificateArn': 'string'
        },
        'MySqlSettings': {
            'ServerName': 'string',
            'Port': 123,
            'SslMode': 'none'|'require'|'verify-ca'|'verify-full',
            'CertificateArn': 'string'
        },
        'OracleSettings': {
            'ServerName': 'string',
            'Port': 123,
            'DatabaseName': 'string',
            'SslMode': 'none'|'require'|'verify-ca'|'verify-full',
            'CertificateArn': 'string',
            'AsmServer': 'string',
            'SecretsManagerOracleAsmSecretId': 'string',
            'SecretsManagerOracleAsmAccessRoleArn': 'string',
            'SecretsManagerSecurityDbEncryptionSecretId': 'string',
            'SecretsManagerSecurityDbEncryptionAccessRoleArn': 'string'
        },
        'MicrosoftSqlServerSettings': {
            'ServerName': 'string',
            'Port': 123,
            'DatabaseName': 'string',
            'SslMode': 'none'|'require'|'verify-ca'|'verify-full',
            'CertificateArn': 'string'
        }
    },
    Tags=[
        {
            'Key': 'string',
            'Value': 'string',
            'ResourceArn': 'string'
        },
    ]
)
type DataProviderName

string

param DataProviderName

A user-friendly name for the data provider.

type Description

string

param Description

A user-friendly description of the data provider.

type Engine

string

param Engine

[REQUIRED]

The type of database engine for the data provider. Valid values include "aurora" , "aurora_postgresql" , "mysql" , "oracle" , "postgres" , and "sqlserver" . A value of "aurora" represents Amazon Aurora MySQL-Compatible Edition.

type Settings

dict

param Settings

[REQUIRED]

The settings in JSON format for a data provider.

  • PostgreSqlSettings (dict) --

    Provides information that defines a PostgreSQL data provider.

    • ServerName (string) --

      The name of the PostgreSQL server.

    • Port (integer) --

      The port value for the PostgreSQL data provider.

    • DatabaseName (string) --

      The database name on the PostgreSQL data provider.

    • SslMode (string) --

      The SSL mode used to connect to the PostgreSQL data provider. The default value is none .

    • CertificateArn (string) --

      The Amazon Resource Name (ARN) of the certificate used for SSL connection.

  • MySqlSettings (dict) --

    Provides information that defines a MySQL data provider.

    • ServerName (string) --

      The name of the MySQL server.

    • Port (integer) --

      The port value for the MySQL data provider.

    • SslMode (string) --

      The SSL mode used to connect to the MySQL data provider. The default value is none .

    • CertificateArn (string) --

      The Amazon Resource Name (ARN) of the certificate used for SSL connection.

  • OracleSettings (dict) --

    Provides information that defines an Oracle data provider.

    • ServerName (string) --

      The name of the Oracle server.

    • Port (integer) --

      The port value for the Oracle data provider.

    • DatabaseName (string) --

      The database name on the Oracle data provider.

    • SslMode (string) --

      The SSL mode used to connect to the Oracle data provider. The default value is none .

    • CertificateArn (string) --

      The Amazon Resource Name (ARN) of the certificate used for SSL connection.

    • AsmServer (string) --

      The address of your Oracle Automatic Storage Management (ASM) server. You can set this value from the asm_server value. You set asm_server as part of the extra connection attribute string to access an Oracle server with Binary Reader that uses ASM. For more information, see Configuration for change data capture (CDC) on an Oracle source database .

    • SecretsManagerOracleAsmSecretId (string) --

      The identifier of the secret in Secrets Manager that contains the Oracle ASM connection details.

      Required only if your data provider uses the Oracle ASM server.

    • SecretsManagerOracleAsmAccessRoleArn (string) --

      The ARN of the IAM role that provides access to the secret in Secrets Manager that contains the Oracle ASM connection details.

    • SecretsManagerSecurityDbEncryptionSecretId (string) --

      The identifier of the secret in Secrets Manager that contains the transparent data encryption (TDE) password. DMS requires this password to access Oracle redo logs encrypted by TDE using Binary Reader.

    • SecretsManagerSecurityDbEncryptionAccessRoleArn (string) --

      The ARN of the IAM role that provides access to the secret in Secrets Manager that contains the TDE password.

  • MicrosoftSqlServerSettings (dict) --

    Provides information that defines a Microsoft SQL Server data provider.

    • ServerName (string) --

      The name of the Microsoft SQL Server server.

    • Port (integer) --

      The port value for the Microsoft SQL Server data provider.

    • DatabaseName (string) --

      The database name on the Microsoft SQL Server data provider.

    • SslMode (string) --

      The SSL mode used to connect to the Microsoft SQL Server data provider. The default value is none .

    • CertificateArn (string) --

      The Amazon Resource Name (ARN) of the certificate used for SSL connection.

type Tags

list

param Tags

One or more tags to be assigned to the data provider.

  • (dict) --

    A user-defined key-value pair that describes metadata added to an DMS resource and that is used by operations such as the following:

    • AddTagsToResource

    • ListTagsForResource

    • RemoveTagsFromResource

    • Key (string) --

      A key is the required name of the tag. The string value can be 1-128 Unicode characters in length and can't be prefixed with "aws:" or "dms:". The string can only contain only the set of Unicode letters, digits, white-space, '_', '.', '/', '=', '+', '-' (Java regular expressions: "^([\p{L}\p{Z}\p{N}_.:/=+\-]*)$").

    • Value (string) --

      A value is the optional value of the tag. The string value can be 1-256 Unicode characters in length and can't be prefixed with "aws:" or "dms:". The string can only contain only the set of Unicode letters, digits, white-space, '_', '.', '/', '=', '+', '-' (Java regular expressions: "^([\p{L}\p{Z}\p{N}_.:/=+\-]*)$").

    • ResourceArn (string) --

      The Amazon Resource Name (ARN) string that uniquely identifies the resource for which the tag is created.

rtype

dict

returns

Response Syntax

{
    'DataProvider': {
        'DataProviderName': 'string',
        'DataProviderArn': 'string',
        'DataProviderCreationTime': datetime(2015, 1, 1),
        'Description': 'string',
        'Engine': 'string',
        'Settings': {
            'PostgreSqlSettings': {
                'ServerName': 'string',
                'Port': 123,
                'DatabaseName': 'string',
                'SslMode': 'none'|'require'|'verify-ca'|'verify-full',
                'CertificateArn': 'string'
            },
            'MySqlSettings': {
                'ServerName': 'string',
                'Port': 123,
                'SslMode': 'none'|'require'|'verify-ca'|'verify-full',
                'CertificateArn': 'string'
            },
            'OracleSettings': {
                'ServerName': 'string',
                'Port': 123,
                'DatabaseName': 'string',
                'SslMode': 'none'|'require'|'verify-ca'|'verify-full',
                'CertificateArn': 'string',
                'AsmServer': 'string',
                'SecretsManagerOracleAsmSecretId': 'string',
                'SecretsManagerOracleAsmAccessRoleArn': 'string',
                'SecretsManagerSecurityDbEncryptionSecretId': 'string',
                'SecretsManagerSecurityDbEncryptionAccessRoleArn': 'string'
            },
            'MicrosoftSqlServerSettings': {
                'ServerName': 'string',
                'Port': 123,
                'DatabaseName': 'string',
                'SslMode': 'none'|'require'|'verify-ca'|'verify-full',
                'CertificateArn': 'string'
            }
        }
    }
}

Response Structure

  • (dict) --

    • DataProvider (dict) --

      The data provider that was created.

      • DataProviderName (string) --

        The name of the data provider.

      • DataProviderArn (string) --

        The Amazon Resource Name (ARN) string that uniquely identifies the data provider.

      • DataProviderCreationTime (datetime) --

        The time the data provider was created.

      • Description (string) --

        A description of the data provider. Descriptions can have up to 31 characters. A description can contain only ASCII letters, digits, and hyphens ('-'). Also, it can't end with a hyphen or contain two consecutive hyphens, and can only begin with a letter.

      • Engine (string) --

        The type of database engine for the data provider. Valid values include "aurora" , "aurora_postgresql" , "mysql" , "oracle" , "postgres" , and "sqlserver" . A value of "aurora" represents Amazon Aurora MySQL-Compatible Edition.

      • Settings (dict) --

        The settings in JSON format for a data provider.

        • PostgreSqlSettings (dict) --

          Provides information that defines a PostgreSQL data provider.

          • ServerName (string) --

            The name of the PostgreSQL server.

          • Port (integer) --

            The port value for the PostgreSQL data provider.

          • DatabaseName (string) --

            The database name on the PostgreSQL data provider.

          • SslMode (string) --

            The SSL mode used to connect to the PostgreSQL data provider. The default value is none .

          • CertificateArn (string) --

            The Amazon Resource Name (ARN) of the certificate used for SSL connection.

        • MySqlSettings (dict) --

          Provides information that defines a MySQL data provider.

          • ServerName (string) --

            The name of the MySQL server.

          • Port (integer) --

            The port value for the MySQL data provider.

          • SslMode (string) --

            The SSL mode used to connect to the MySQL data provider. The default value is none .

          • CertificateArn (string) --

            The Amazon Resource Name (ARN) of the certificate used for SSL connection.

        • OracleSettings (dict) --

          Provides information that defines an Oracle data provider.

          • ServerName (string) --

            The name of the Oracle server.

          • Port (integer) --

            The port value for the Oracle data provider.

          • DatabaseName (string) --

            The database name on the Oracle data provider.

          • SslMode (string) --

            The SSL mode used to connect to the Oracle data provider. The default value is none .

          • CertificateArn (string) --

            The Amazon Resource Name (ARN) of the certificate used for SSL connection.

          • AsmServer (string) --

            The address of your Oracle Automatic Storage Management (ASM) server. You can set this value from the asm_server value. You set asm_server as part of the extra connection attribute string to access an Oracle server with Binary Reader that uses ASM. For more information, see Configuration for change data capture (CDC) on an Oracle source database .

          • SecretsManagerOracleAsmSecretId (string) --

            The identifier of the secret in Secrets Manager that contains the Oracle ASM connection details.

            Required only if your data provider uses the Oracle ASM server.

          • SecretsManagerOracleAsmAccessRoleArn (string) --

            The ARN of the IAM role that provides access to the secret in Secrets Manager that contains the Oracle ASM connection details.

          • SecretsManagerSecurityDbEncryptionSecretId (string) --

            The identifier of the secret in Secrets Manager that contains the transparent data encryption (TDE) password. DMS requires this password to access Oracle redo logs encrypted by TDE using Binary Reader.

          • SecretsManagerSecurityDbEncryptionAccessRoleArn (string) --

            The ARN of the IAM role that provides access to the secret in Secrets Manager that contains the TDE password.

        • MicrosoftSqlServerSettings (dict) --

          Provides information that defines a Microsoft SQL Server data provider.

          • ServerName (string) --

            The name of the Microsoft SQL Server server.

          • Port (integer) --

            The port value for the Microsoft SQL Server data provider.

          • DatabaseName (string) --

            The database name on the Microsoft SQL Server data provider.

          • SslMode (string) --

            The SSL mode used to connect to the Microsoft SQL Server data provider. The default value is none .

          • CertificateArn (string) --

            The Amazon Resource Name (ARN) of the certificate used for SSL connection.

ExportMetadataModelAssessment (new) Link ¶

Saves a copy of a database migration assessment report to your Amazon S3 bucket. DMS can save your assessment report as a comma-separated value (CSV) or a PDF file.

See also: AWS API Documentation

Request Syntax

client.export_metadata_model_assessment(
    MigrationProjectIdentifier='string',
    SelectionRules='string',
    FileName='string',
    AssessmentReportTypes=[
        'pdf'|'csv',
    ]
)
type MigrationProjectIdentifier

string

param MigrationProjectIdentifier

[REQUIRED]

The migration project name or Amazon Resource Name (ARN).

type SelectionRules

string

param SelectionRules

[REQUIRED]

A value that specifies the database objects to assess.

type FileName

string

param FileName

The name of the assessment file to create in your Amazon S3 bucket.

type AssessmentReportTypes

list

param AssessmentReportTypes

The file format of the assessment file.

  • (string) --

rtype

dict

returns

Response Syntax

{
    'PdfReport': {
        'S3ObjectKey': 'string',
        'ObjectURL': 'string'
    },
    'CsvReport': {
        'S3ObjectKey': 'string',
        'ObjectURL': 'string'
    }
}

Response Structure

  • (dict) --

    • PdfReport (dict) --

      The Amazon S3 details for an assessment exported in PDF format.

      • S3ObjectKey (string) --

        The object key for the object containing the exported metadata model assessment.

      • ObjectURL (string) --

        The URL for the object containing the exported metadata model assessment.

    • CsvReport (dict) --

      The Amazon S3 details for an assessment exported in CSV format.

      • S3ObjectKey (string) --

        The object key for the object containing the exported metadata model assessment.

      • ObjectURL (string) --

        The URL for the object containing the exported metadata model assessment.

StartMetadataModelExportAsScript (new) Link ¶

Saves your converted code to a file as a SQL script, and stores this file on your Amazon S3 bucket.

See also: AWS API Documentation

Request Syntax

client.start_metadata_model_export_as_script(
    MigrationProjectIdentifier='string',
    SelectionRules='string',
    Origin='SOURCE'|'TARGET',
    FileName='string'
)
type MigrationProjectIdentifier

string

param MigrationProjectIdentifier

[REQUIRED]

The migration project name or Amazon Resource Name (ARN).

type SelectionRules

string

param SelectionRules

[REQUIRED]

A value that specifies the database objects to export.

type Origin

string

param Origin

[REQUIRED]

Whether to export the metadata model from the source or the target.

type FileName

string

param FileName

The name of the model file to create in the Amazon S3 bucket.

rtype

dict

returns

Response Syntax

{
    'RequestIdentifier': 'string'
}

Response Structure

  • (dict) --

    • RequestIdentifier (string) --

      The identifier for the export operation.

DescribeMetadataModelExportsAsScript (new) Link ¶

Returns a paginated list of metadata model exports.

See also: AWS API Documentation

Request Syntax

client.describe_metadata_model_exports_as_script(
    MigrationProjectIdentifier='string',
    Filters=[
        {
            'Name': 'string',
            'Values': [
                'string',
            ]
        },
    ],
    Marker='string',
    MaxRecords=123
)
type MigrationProjectIdentifier

string

param MigrationProjectIdentifier

[REQUIRED]

The migration project name or Amazon Resource Name (ARN).

type Filters

list

param Filters

Filters applied to the metadata model exports described in the form of key-value pairs.

  • (dict) --

    Identifies the name and value of a filter object. This filter is used to limit the number and type of DMS objects that are returned for a particular Describe* call or similar operation. Filters are used as an optional parameter for certain API operations.

    • Name (string) -- [REQUIRED]

      The name of the filter as specified for a Describe* or similar operation.

    • Values (list) -- [REQUIRED]

      The filter value, which can specify one or more values used to narrow the returned results.

      • (string) --

type Marker

string

param Marker

Specifies the unique pagination token that makes it possible to display the next page of results. If this parameter is specified, the response includes only records beyond the marker, up to the value specified by MaxRecords .

If Marker is returned by a previous response, there are more results available. The value of Marker is a unique pagination token for each page. To retrieve the next page, make the call again using the returned token and keeping all other arguments unchanged.

type MaxRecords

integer

param MaxRecords

The maximum number of records to include in the response. If more records exist than the specified MaxRecords value, DMS includes a pagination token in the response so that you can retrieve the remaining results.

rtype

dict

returns

Response Syntax

{
    'Marker': 'string',
    'Requests': [
        {
            'Status': 'string',
            'RequestIdentifier': 'string',
            'MigrationProjectArn': 'string',
            'Error': {
                'defaultErrorDetails': {
                    'Message': 'string'
                }
            },
            'ExportSqlDetails': {
                'S3ObjectKey': 'string',
                'ObjectURL': 'string'
            }
        },
    ]
}

Response Structure

  • (dict) --

    • Marker (string) --

      Specifies the unique pagination token that makes it possible to display the next page of results. If this parameter is specified, the response includes only records beyond the marker, up to the value specified by MaxRecords .

      If Marker is returned by a previous response, there are more results available. The value of Marker is a unique pagination token for each page. To retrieve the next page, make the call again using the returned token and keeping all other arguments unchanged.

    • Requests (list) --

      A paginated list of metadata model exports.

      • (dict) --

        Provides information about a schema conversion action.

        • Status (string) --

          The schema conversion action status.

        • RequestIdentifier (string) --

          The identifier for the schema conversion action.

        • MigrationProjectArn (string) --

          The migration project ARN.

        • Error (dict) --

          Provides error information about a project.

          • defaultErrorDetails (dict) --

            Error information about a project.

            • Message (string) --

              The error message.

        • ExportSqlDetails (dict) --

          Provides information about a metadata model assessment exported to SQL.

          • S3ObjectKey (string) --

            The Amazon S3 object key for the object containing the exported metadata model assessment.

          • ObjectURL (string) --

            The URL for the object containing the exported metadata model assessment.

DescribeExtensionPackAssociations (new) Link ¶

Returns a paginated list of extension pack associations for the specified migration project. An extension pack is an add-on module that emulates functions present in a source database that are required when converting objects to the target database.

See also: AWS API Documentation

Request Syntax

client.describe_extension_pack_associations(
    MigrationProjectIdentifier='string',
    Filters=[
        {
            'Name': 'string',
            'Values': [
                'string',
            ]
        },
    ],
    Marker='string',
    MaxRecords=123
)
type MigrationProjectIdentifier

string

param MigrationProjectIdentifier

[REQUIRED]

The name or Amazon Resource Name (ARN) for the migration project.

type Filters

list

param Filters

Filters applied to the extension pack associations described in the form of key-value pairs.

  • (dict) --

    Identifies the name and value of a filter object. This filter is used to limit the number and type of DMS objects that are returned for a particular Describe* call or similar operation. Filters are used as an optional parameter for certain API operations.

    • Name (string) -- [REQUIRED]

      The name of the filter as specified for a Describe* or similar operation.

    • Values (list) -- [REQUIRED]

      The filter value, which can specify one or more values used to narrow the returned results.

      • (string) --

type Marker

string

param Marker

Specifies the unique pagination token that makes it possible to display the next page of results. If this parameter is specified, the response includes only records beyond the marker, up to the value specified by MaxRecords .

If Marker is returned by a previous response, there are more results available. The value of Marker is a unique pagination token for each page. To retrieve the next page, make the call again using the returned token and keeping all other arguments unchanged.

type MaxRecords

integer

param MaxRecords

The maximum number of records to include in the response. If more records exist than the specified MaxRecords value, DMS includes a pagination token in the response so that you can retrieve the remaining results.

rtype

dict

returns

Response Syntax

{
    'Marker': 'string',
    'Requests': [
        {
            'Status': 'string',
            'RequestIdentifier': 'string',
            'MigrationProjectArn': 'string',
            'Error': {
                'defaultErrorDetails': {
                    'Message': 'string'
                }
            },
            'ExportSqlDetails': {
                'S3ObjectKey': 'string',
                'ObjectURL': 'string'
            }
        },
    ]
}

Response Structure

  • (dict) --

    • Marker (string) --

      Specifies the unique pagination token that makes it possible to display the next page of results. If this parameter is specified, the response includes only records beyond the marker, up to the value specified by MaxRecords .

      If Marker is returned by a previous response, there are more results available. The value of Marker is a unique pagination token for each page. To retrieve the next page, make the call again using the returned token and keeping all other arguments unchanged.

    • Requests (list) --

      A paginated list of extension pack associations for the specified migration project.

      • (dict) --

        Provides information about a schema conversion action.

        • Status (string) --

          The schema conversion action status.

        • RequestIdentifier (string) --

          The identifier for the schema conversion action.

        • MigrationProjectArn (string) --

          The migration project ARN.

        • Error (dict) --

          Provides error information about a project.

          • defaultErrorDetails (dict) --

            Error information about a project.

            • Message (string) --

              The error message.

        • ExportSqlDetails (dict) --

          Provides information about a metadata model assessment exported to SQL.

          • S3ObjectKey (string) --

            The Amazon S3 object key for the object containing the exported metadata model assessment.

          • ObjectURL (string) --

            The URL for the object containing the exported metadata model assessment.

DescribeMetadataModelAssessments (new) Link ¶

Returns a paginated list of metadata model assessments for your account in the current region.

See also: AWS API Documentation

Request Syntax

client.describe_metadata_model_assessments(
    MigrationProjectIdentifier='string',
    Filters=[
        {
            'Name': 'string',
            'Values': [
                'string',
            ]
        },
    ],
    Marker='string',
    MaxRecords=123
)
type MigrationProjectIdentifier

string

param MigrationProjectIdentifier

[REQUIRED]

The name or Amazon Resource Name (ARN) of the migration project.

type Filters

list

param Filters

Filters applied to the metadata model assessments described in the form of key-value pairs.

  • (dict) --

    Identifies the name and value of a filter object. This filter is used to limit the number and type of DMS objects that are returned for a particular Describe* call or similar operation. Filters are used as an optional parameter for certain API operations.

    • Name (string) -- [REQUIRED]

      The name of the filter as specified for a Describe* or similar operation.

    • Values (list) -- [REQUIRED]

      The filter value, which can specify one or more values used to narrow the returned results.

      • (string) --

type Marker

string

param Marker

Specifies the unique pagination token that makes it possible to display the next page of results. If this parameter is specified, the response includes only records beyond the marker, up to the value specified by MaxRecords .

If Marker is returned by a previous response, there are more results available. The value of Marker is a unique pagination token for each page. To retrieve the next page, make the call again using the returned token and keeping all other arguments unchanged.

type MaxRecords

integer

param MaxRecords

The maximum number of records to include in the response. If more records exist than the specified MaxRecords value, DMS includes a pagination token in the response so that you can retrieve the remaining results.

rtype

dict

returns

Response Syntax

{
    'Marker': 'string',
    'Requests': [
        {
            'Status': 'string',
            'RequestIdentifier': 'string',
            'MigrationProjectArn': 'string',
            'Error': {
                'defaultErrorDetails': {
                    'Message': 'string'
                }
            },
            'ExportSqlDetails': {
                'S3ObjectKey': 'string',
                'ObjectURL': 'string'
            }
        },
    ]
}

Response Structure

  • (dict) --

    • Marker (string) --

      Specifies the unique pagination token that makes it possible to display the next page of results. If this parameter is specified, the response includes only records beyond the marker, up to the value specified by MaxRecords .

      If Marker is returned by a previous response, there are more results available. The value of Marker is a unique pagination token for each page. To retrieve the next page, make the call again using the returned token and keeping all other arguments unchanged.

    • Requests (list) --

      A paginated list of metadata model assessments for the specified migration project.

      • (dict) --

        Provides information about a schema conversion action.

        • Status (string) --

          The schema conversion action status.

        • RequestIdentifier (string) --

          The identifier for the schema conversion action.

        • MigrationProjectArn (string) --

          The migration project ARN.

        • Error (dict) --

          Provides error information about a project.

          • defaultErrorDetails (dict) --

            Error information about a project.

            • Message (string) --

              The error message.

        • ExportSqlDetails (dict) --

          Provides information about a metadata model assessment exported to SQL.

          • S3ObjectKey (string) --

            The Amazon S3 object key for the object containing the exported metadata model assessment.

          • ObjectURL (string) --

            The URL for the object containing the exported metadata model assessment.