Bulk Data Movement Guide

10.5.1
- 10.5.6
- 10.5.5
- 10.5.4
- 10.5.3
- 10.5.2
- 10.5
- 10.4.1
- 10.4.0 HotFix 1
- 10.4.0

Back Next

Configuring Microsoft SQL Server Bulk Data Movement

To configure PowerExchange for bulk data movement operations, complete the following tasks:

Verify that PowerExchange has read access to Microsoft SQL Server source tables. If the SQL Server database is on the system where PowerExchange runs, PowerExchange uses the Windows authorization for connections to SQL Server. If the SQL Server database is on a remote Windows system, PowerExchange uses the user ID under which the remote PowerExchange Listener runs.

Configure Microsoft SQL Server bulk data movement by defining the MSS_ERRORFILE statement in the DBMOVER configuration file.

Set up and test connectivity to SQL Server sources and targets.

Microsoft SQL Server Bulk Data Movement

Adding a Microsoft SQL Server Statement to the DBMOVER Configuration File

Setting Up and Testing Connectivity to a SQL Service Source or Target

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal