connectionString
: the encrypted connection string. See ".NET Framework Data Provider for SQL Server" section on https://www.connectionstrings.com/sql-server/ for a sample.
schema
: the schema of the table, e.g. dbo
table
: the name of the domain and table e.g. dbo.employees_new
idColumn
: the name of the identity column that exists in the target (or a single column that is guaranteed to be unique and automatically populated for every new record)
idDataType
: the data type of the id column
<SqlServerTableTargetconnectionString="DDE1MhWuA0xYbwFvSnu1fEZ2uD2GpsMRdw9DMV/kmMAfLUdkhkdzrD0Ikk/9dd114wRu9VKrVPSztrcIcSyz2UEFRRANfocc8KJEQXfKDuU="schema="dbo"table="employees_new"idColumn="id_col"idDataType="Number"><ColumnMappings><ColumnMapping sourceColumn="employee_id" targetColumn="employee_id_new" /><ColumnMapping sourceColumn="name" targetColumn="name_new" /></ColumnMappings><SyncKey><SyncKeyColumnReference name="employee_id_new" /></SyncKey><NewRecordBehaviour type="INSERT" /><DroppedRecordBehaviour type="EXPIRE" expirationTimestampField="expiry_date_new" /></SqlServerTableTarget>
connectionString
: the encrypted connection string. See ".NET Framework Data Provider for SQL Server" section on https://www.connectionstrings.com/sql-server/ for a sample.
table
: the name of the table including the schema, e.g. dbo.employees
idColumn
: the name of the identity column that exists in the target (or a single column that is guaranteed to be unique and automatically populated for every new record)
idDataType
: the data type of the id column
<SqlServerTableTargetconnectionString="DDE1MhWuA0xYbwFvSnu1fEZ2uD2GpsMRdw9DMV/kmMAfLUdkhkdzrD0Ikk/9dd114wRu9VKrVPSztrcIcSyz2UEFRRANfocc8KJEQXfKDuU="table="dbo.employees_new"idColumn="id_col"idDataType="Number"><ColumnMappings><ColumnMapping sourceColumn="employee_id" targetColumn="employee_id_new" /><ColumnMapping sourceColumn="name" targetColumn="name_new" /></ColumnMappings><SyncKey><SyncKeyColumnReference name="employee_id_new" /></SyncKey><NewRecordBehaviour type="INSERT" /><DroppedRecordBehaviour type="EXPIRE" expirationTimestampField="expiry_date_new" /></SqlServerTableTarget>