Package software.amazon.awscdk.cfnpropertymixins.services.dms

Class CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty.Builder

java.lang.Object

software.amazon.awscdk.cfnpropertymixins.services.dms.CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty.Builder

All Implemented Interfaces:

software.amazon.jsii.Builder<CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty>

Enclosing interface:

CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty

@Stability(Stable)
public static final class CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty.Builder
extends Object
implements software.amazon.jsii.Builder<CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty>

A builder for CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty

Constructor Summary

Constructors

Constructor	Description
Builder()

Method Summary

Modifier and Type	Method	Description
CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty.Builder	bcpPacketSize(Number bcpPacketSize)	Sets the value of CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty.getBcpPacketSize()
CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty	build()	Builds the configured instance.
CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty.Builder	controlTablesFileGroup(String controlTablesFileGroup)	Sets the value of CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty.getControlTablesFileGroup()
CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty.Builder	databaseName(String databaseName)	Sets the value of CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty.getDatabaseName()
CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty.Builder	forceLobLookup(Boolean forceLobLookup)	Sets the value of CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty.getForceLobLookup()
CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty.Builder	forceLobLookup(IResolvable forceLobLookup)	Sets the value of CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty.getForceLobLookup()
CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty.Builder	password(String password)	Sets the value of CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty.getPassword()
CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty.Builder	port(Number port)	Sets the value of CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty.getPort()
CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty.Builder	querySingleAlwaysOnNode(Boolean querySingleAlwaysOnNode)	Sets the value of CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty.getQuerySingleAlwaysOnNode()
CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty.Builder	querySingleAlwaysOnNode(IResolvable querySingleAlwaysOnNode)	Sets the value of CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty.getQuerySingleAlwaysOnNode()
CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty.Builder	readBackupOnly(Boolean readBackupOnly)	Sets the value of CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty.getReadBackupOnly()
CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty.Builder	readBackupOnly(IResolvable readBackupOnly)	Sets the value of CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty.getReadBackupOnly()
CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty.Builder	safeguardPolicy(String safeguardPolicy)	Sets the value of CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty.getSafeguardPolicy()
CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty.Builder	secretsManagerAccessRoleArn(String secretsManagerAccessRoleArn)	Sets the value of CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty.getSecretsManagerAccessRoleArn()
CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty.Builder	secretsManagerSecretId(String secretsManagerSecretId)	Sets the value of CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty.getSecretsManagerSecretId()
CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty.Builder	serverName(String serverName)	Sets the value of CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty.getServerName()
CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty.Builder	tlogAccessMode(String tlogAccessMode)	Sets the value of CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty.getTlogAccessMode()
CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty.Builder	trimSpaceInChar(Boolean trimSpaceInChar)	Sets the value of CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty.getTrimSpaceInChar()
CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty.Builder	trimSpaceInChar(IResolvable trimSpaceInChar)	Sets the value of CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty.getTrimSpaceInChar()
CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty.Builder	useBcpFullLoad(Boolean useBcpFullLoad)	Sets the value of CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty.getUseBcpFullLoad()
CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty.Builder	useBcpFullLoad(IResolvable useBcpFullLoad)	Sets the value of CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty.getUseBcpFullLoad()
CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty.Builder	username(String username)	Sets the value of CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty.getUsername()
CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty.Builder	useThirdPartyBackupDevice(Boolean useThirdPartyBackupDevice)	Sets the value of CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty.getUseThirdPartyBackupDevice()
CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty.Builder	useThirdPartyBackupDevice(IResolvable useThirdPartyBackupDevice)	Sets the value of CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty.getUseThirdPartyBackupDevice()

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

Builder

public Builder()

Method Details

bcpPacketSize

@Stability(Stable)
public CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty.Builder bcpPacketSize(Number bcpPacketSize)

Sets the value of CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty.getBcpPacketSize()

Parameters:

bcpPacketSize - The maximum size of the packets (in bytes) used to transfer data using BCP.

Returns:

this

controlTablesFileGroup

@Stability(Stable)
public CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty.Builder controlTablesFileGroup(String controlTablesFileGroup)

Sets the value of CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty.getControlTablesFileGroup()

Parameters:

controlTablesFileGroup - Specifies a file group for the AWS DMS internal tables. When the replication task starts, all the internal AWS DMS control tables (awsdms_ apply_exception, awsdms_apply, awsdms_changes) are created for the specified file group.

Returns:

this

databaseName

@Stability(Stable)
public CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty.Builder databaseName(String databaseName)

Sets the value of CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty.getDatabaseName()

Parameters:

databaseName - Database name for the endpoint.

Returns:

this

forceLobLookup

@Stability(Stable)
public CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty.Builder forceLobLookup(Boolean forceLobLookup)

Sets the value of CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty.getForceLobLookup()

Parameters:

forceLobLookup - Forces LOB lookup on inline LOB.

Returns:

this

forceLobLookup

@Stability(Stable)
public CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty.Builder forceLobLookup(IResolvable forceLobLookup)

Sets the value of CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty.getForceLobLookup()

Parameters:

forceLobLookup - Forces LOB lookup on inline LOB.

Returns:

this

password

@Stability(Stable)
public CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty.Builder password(String password)

Sets the value of CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty.getPassword()

Parameters:

password - Endpoint connection password.

Returns:

this

port

@Stability(Stable)
public CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty.Builder port(Number port)

Sets the value of CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty.getPort()

Parameters:

port - Endpoint TCP port.

Returns:

this

querySingleAlwaysOnNode

@Stability(Stable)
public CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty.Builder querySingleAlwaysOnNode(Boolean querySingleAlwaysOnNode)

Sets the value of CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty.getQuerySingleAlwaysOnNode()

Parameters:

querySingleAlwaysOnNode - Cleans and recreates table metadata information on the replication instance when a mismatch occurs. An example is a situation where running an alter DDL statement on a table might result in different information about the table cached in the replication instance.

Returns:

this

querySingleAlwaysOnNode

@Stability(Stable)
public CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty.Builder querySingleAlwaysOnNode(IResolvable querySingleAlwaysOnNode)

Sets the value of CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty.getQuerySingleAlwaysOnNode()

Parameters:

querySingleAlwaysOnNode - Cleans and recreates table metadata information on the replication instance when a mismatch occurs. An example is a situation where running an alter DDL statement on a table might result in different information about the table cached in the replication instance.

Returns:

this

readBackupOnly

@Stability(Stable)
public CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty.Builder readBackupOnly(Boolean readBackupOnly)

Sets the value of CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty.getReadBackupOnly()

Parameters:

readBackupOnly - When this attribute is set to Y , AWS DMS only reads changes from transaction log backups and doesn't read from the active transaction log file during ongoing replication. Setting this parameter to Y enables you to control active transaction log file growth during full load and ongoing replication tasks. However, it can add some source latency to ongoing replication.

Returns:

this

readBackupOnly

@Stability(Stable)
public CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty.Builder readBackupOnly(IResolvable readBackupOnly)

Sets the value of CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty.getReadBackupOnly()

Parameters:

readBackupOnly - When this attribute is set to Y , AWS DMS only reads changes from transaction log backups and doesn't read from the active transaction log file during ongoing replication. Setting this parameter to Y enables you to control active transaction log file growth during full load and ongoing replication tasks. However, it can add some source latency to ongoing replication.

Returns:

this

safeguardPolicy

@Stability(Stable)
public CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty.Builder safeguardPolicy(String safeguardPolicy)

Sets the value of CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty.getSafeguardPolicy()

Parameters:

safeguardPolicy - Use this attribute to minimize the need to access the backup log and enable AWS DMS to prevent truncation using one of the following two methods. Start transactions in the database: This is the default method. When this method is used, AWS DMS prevents TLOG truncation by mimicking a transaction in the database. As long as such a transaction is open, changes that appear after the transaction started aren't truncated. If you need Microsoft Replication to be enabled in your database, then you must choose this method.

Exclusively use sp_repldone within a single task : When this method is used, AWS DMS reads the changes and then uses sp_repldone to mark the TLOG transactions as ready for truncation. Although this method doesn't involve any transactional activities, it can only be used when Microsoft Replication isn't running. Also, when using this method, only one AWS DMS task can access the database at any given time. Therefore, if you need to run parallel AWS DMS tasks against the same database, use the default method.

Returns:

this

secretsManagerAccessRoleArn

@Stability(Stable)
public CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty.Builder secretsManagerAccessRoleArn(String secretsManagerAccessRoleArn)

Sets the value of CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty.getSecretsManagerAccessRoleArn()

Parameters:

secretsManagerAccessRoleArn - The full Amazon Resource Name (ARN) of the IAM role that specifies AWS DMS as the trusted entity and grants the required permissions to access the value in SecretsManagerSecret . The role must allow the iam:PassRole action. SecretsManagerSecret has the value of the AWS Secrets Manager secret that allows access to the SQL Server endpoint.

You can specify one of two sets of values for these permissions. You can specify the values for this setting and SecretsManagerSecretId . Or you can specify clear-text values for UserName , Password , ServerName , and Port . You can't specify both.

For more information on creating this SecretsManagerSecret , the corresponding SecretsManagerAccessRoleArn , and the SecretsManagerSecretId that is required to access it, see Using secrets to access AWS Database Migration Service resources in the AWS Database Migration Service User Guide .

Returns:

this

secretsManagerSecretId

@Stability(Stable)
public CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty.Builder secretsManagerSecretId(String secretsManagerSecretId)

Sets the value of CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty.getSecretsManagerSecretId()

Parameters:

secretsManagerSecretId - The full ARN, partial ARN, or display name of the SecretsManagerSecret that contains the MicrosoftSQLServer endpoint connection details.

Returns:

this

serverName

@Stability(Stable)
public CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty.Builder serverName(String serverName)

Sets the value of CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty.getServerName()

Parameters:

serverName - Fully qualified domain name of the endpoint. For an Amazon RDS SQL Server instance, this is the output of DescribeDBInstances , in the [Endpoint](https://docs.aws.amazon.com/AmazonRDS/latest/APIReference/API_Endpoint.html) .Address field.

Returns:

this

tlogAccessMode

@Stability(Stable)
public CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty.Builder tlogAccessMode(String tlogAccessMode)

Sets the value of CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty.getTlogAccessMode()

Parameters:

tlogAccessMode - Indicates the mode used to fetch CDC data.

Returns:

this

trimSpaceInChar

@Stability(Stable)
public CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty.Builder trimSpaceInChar(Boolean trimSpaceInChar)

Sets the value of CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty.getTrimSpaceInChar()

Parameters:

trimSpaceInChar - Use the TrimSpaceInChar source endpoint setting to right-trim data on CHAR and NCHAR data types during migration. Setting TrimSpaceInChar does not left-trim data. The default value is true .

Returns:

this

trimSpaceInChar

@Stability(Stable)
public CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty.Builder trimSpaceInChar(IResolvable trimSpaceInChar)

Sets the value of CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty.getTrimSpaceInChar()

Parameters:

trimSpaceInChar - Use the TrimSpaceInChar source endpoint setting to right-trim data on CHAR and NCHAR data types during migration. Setting TrimSpaceInChar does not left-trim data. The default value is true .

Returns:

this

useBcpFullLoad

@Stability(Stable)
public CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty.Builder useBcpFullLoad(Boolean useBcpFullLoad)

Sets the value of CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty.getUseBcpFullLoad()

Parameters:

useBcpFullLoad - Use this to attribute to transfer data for full-load operations using BCP. When the target table contains an identity column that does not exist in the source table, you must disable the use BCP for loading table option.

Returns:

this

useBcpFullLoad

@Stability(Stable)
public CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty.Builder useBcpFullLoad(IResolvable useBcpFullLoad)

Sets the value of CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty.getUseBcpFullLoad()

Parameters:

useBcpFullLoad - Use this to attribute to transfer data for full-load operations using BCP. When the target table contains an identity column that does not exist in the source table, you must disable the use BCP for loading table option.

Returns:

this

username

@Stability(Stable)
public CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty.Builder username(String username)

Sets the value of CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty.getUsername()

Parameters:

username - Endpoint connection user name.

Returns:

this

useThirdPartyBackupDevice

@Stability(Stable)
public CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty.Builder useThirdPartyBackupDevice(Boolean useThirdPartyBackupDevice)

Sets the value of CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty.getUseThirdPartyBackupDevice()

Parameters:

useThirdPartyBackupDevice - When this attribute is set to Y , DMS processes third-party transaction log backups if they are created in native format.

Returns:

this

useThirdPartyBackupDevice

@Stability(Stable)
public CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty.Builder useThirdPartyBackupDevice(IResolvable useThirdPartyBackupDevice)

Sets the value of CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty.getUseThirdPartyBackupDevice()

Parameters:

useThirdPartyBackupDevice - When this attribute is set to Y , DMS processes third-party transaction log backups if they are created in native format.

Returns:

this

build

@Stability(Stable)
public CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty build()

Builds the configured instance.

Specified by:

build in interface software.amazon.jsii.Builder<CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty>

Returns:

a new instance of CfnEndpointPropsMixin.MicrosoftSqlServerSettingsProperty

Throws:

NullPointerException - if any required attribute was not provided