MDAA TS Docs
    Preparing search index...

    Interface MicrosoftSqlServerSettingsProperty

    Provides information that defines a Microsoft SQL Server endpoint. Modified from the equivalent L1 Construct to prevent use of plaintext credentials and enforce use of KMS encryption. This information includes the output format of records applied to the endpoint and details of transaction and control table data information. For information about other available settings, see Extra connection attributes when using SQL Server as a source for AWS DMS and Extra connection attributes when using SQL Server as a target for AWS DMS in the AWS Database Migration Service User Guide .

    See: http://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-properties-dms-endpoint-microsoftsqlserversettings.html

    interface MicrosoftSqlServerSettingsProperty {
        bcpPacketSize?: number;
        controlTablesFileGroup?: string;
        databaseName?: string;
        forceLobLookup?: boolean;
        port?: number;
        querySingleAlwaysOnNode?: boolean;
        readBackupOnly?: boolean;
        safeguardPolicy?: string;
        secretsManagerAccessRoleArn?: string;
        secretsManagerSecretArn: string;
        secretsManagerSecretKMSArn?: string;
        serverName?: string;
        tlogAccessMode?: string;
        trimSpaceInChar?: boolean;
        useBcpFullLoad?: boolean;
        useThirdPartyBackupDevice?: boolean;
    }
    Index

    Properties

    bcpPacketSize? controlTablesFileGroup? databaseName? forceLobLookup? port? querySingleAlwaysOnNode? readBackupOnly? safeguardPolicy? secretsManagerAccessRoleArn? secretsManagerSecretArn secretsManagerSecretKMSArn? serverName? tlogAccessMode? trimSpaceInChar? useBcpFullLoad? useThirdPartyBackupDevice?

    Properties

    bcpPacketSize?: number

    BCP packet size in bytes for SQL Server data transfer optimization enabling performance

    controlTablesFileGroup?: string
    databaseName?: string

    Database name for SQL Server endpoint connectivity enabling specific database targeting

    forceLobLookup?: boolean
    port?: number

    TCP port number for SQL Server endpoint connectivity enabling custom port configuration for

    querySingleAlwaysOnNode?: boolean
    readBackupOnly?: boolean

    Flag to read changes only from transaction log backups enabling controlled transaction log

    safeguardPolicy?: string
    secretsManagerAccessRoleArn?: string

    IAM role ARN for DMS to access Secrets Manager secret containing SQL Server credentials

    secretsManagerSecretArn: string
    secretsManagerSecretKMSArn?: string

    KMS key ARN for encrypting Secrets Manager secret containing SQL Server credentials

    serverName?: string
    tlogAccessMode?: string

    Transaction log access mode for CDC data fetching enabling optimized change data capture in

    trimSpaceInChar?: boolean
    useBcpFullLoad?: boolean

    Flag to use BCP for full-load operations enabling optimized bulk data transfer in SQL Server migration

    useThirdPartyBackupDevice?: boolean

    Settings

    Member Visibility

    On This Page

    Properties