Preface
Introduction to Microsoft SQL Server Connector
- Microsoft SQL Server Connector assets
Connections for Microsoft SQL Server
Synchronization tasks with Microsoft SQL Server Connector
Mappings and mapping tasks with Microsoft SQL Server Connector
Replication tasks with Microsoft SQL Server
- Microsoft SQL Server sources in replication tasks
- Microsoft SQL Server targets in replication tasks
Data type reference
- Microsoft SQL Server and transformation data types

Microsoft SQL Server Connector

Back Next

Cross-schema SQL ELT optimization

Cross-schema
SQL ELT optimization

You can use cross-schema

SQL ELT optimization

for a

mapping

task to read from or write data to Microsoft SQL Server objects associated with different schemas within the same database.

To use cross-schema

SQL ELT optimization

, create two Microsoft SQL Server connections and specify the schema in each connection. Ensure that the schema in the source connection is different from the schema in the target connection, but both the schemas must belong to the same database. When you configure

SQL ELT optimization

for the

mapping

task, enable cross-schema

SQL ELT optimization

in the advanced session properties. By default, the check box is selected.

SQL ELT optimization

Configuring cross-schema SQL ELT optimization

Download Guide

Watch

Comments

Cloud Connectivity Homepage