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

title	description	author	ms.author	ms.date	ms.service	ms.subservice	ms.topic	ms.collection	helpviewer_keywords
Creating the Server Connection Files (MySQLToSQL)	Creating the Server Connection Files (MySQLToSQL)	cpichuka	cpichuka	01/19/2017	sql	ssma	conceptual	sql-migration-content	Server connection file validation Server connection files

Creating the Server Connection Files (MySQLToSQL)

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:

<!--Sample of server connection file commands -->  
  
<mysql name ="<source-server-unique-name>">  
  
   <standard-mode>  
  
      <server value ="<server-name>"/>  
  
      <user-id value ="<user-name>"/>  
  
      <password value ="<password>"/>  
  
      <port value ="<port>"/>  
  
   </standard-mode>  
  
</mysql>  

<!--Connection to SQL Server-->  
  
<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>"/>  
  
      <encrypt value="<true/false>"/>  
  
      <trust-server-certificate value="<true/false>"/>  
  
   </sql-server-authentication>  
  
</sql-server>  

<!--Connection to SQL Azure-->  
  
<sql-azure name="<target-server-unique-name>">  
  
   <server value="<server-name>"/>  
  
   <database value="<database-name>"/>  
  
   <user-id value="<user-name>"/>  
  
   <password value="<password>"/>  
  
</sql-azure>  

Server Connection File Validation

The user can easily validate his/her server connection file against the schema definition file 'M2SSConsoleScriptServersSchema.xsd' available in the 'Schemas' folder.

Next Step

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

See Also

Executing the SSMA Console (MySQL)