creating-the-server-connection-files-db2tosql.md

title	Creating the Server Connection Files (DB2ToSQL) | Microsoft Docs
ms.prod	sql
ms.custom
ms.date	01/19/2017
ms.reviewer
ms.technology	ssma
ms.topic	conceptual
ms.assetid	685419f6-8606-462c-be12-8bace45bede6
author	Shamikg
ms.author	Shamikg

Creating the Server Connection Files (DB2ToSQL)

Server information can be specified either in the servers section of the script file or in a separate server connection file. The command line parameter for the server connection file is, -c <serverconnectionfile>. If the same server id is present in both the script file and server connection file, then the server definition in the script file is considered.

Example: 1

<!--Sample of server connection file commands -->  
  
<db2 name="<source-server-unique-name>">  
  
    <standard-mode>  
  
      <connection-provider value ="OleDB Provider"/>  
  
      <!-- Defines server manager to connect.  
  
              Available manager attribute values  
  
              • zOs      - upgrades the project (default)  
  
              • LUW       - displays an error and halts the execution-->  
  
      <database-manager value="$Db2Manager$"/>  
  
      <server-name value="$Db2HostName$" />  
  
      <port value="$Db2Port$" />  
  
      <initial-catalog value="$Db2Instance$" />  
  
      <user-id value="$Db2UserName$" />  
  
      <password value="$Db2Password$"/>  
  
    </standard-mode>  
  
</db2>  

<sql-server name="<target-server-unique-name>">  
  
  <sql-server-authentication>  
  
    <server value="<server-name>"/>  
  
    <database value="<database-name>"/>  
  
    <user-id value="<user-name>"/>  
  
    <password value="<password>"/>  
  
  </sql-server-authentication>  
  
</sql-server>  

Next Step

The next step in operating the console is Executing the SSMA Console (DB2ToSQL)

See Also

Executing the SSMA Console