To successfully migrate DB2 databases and applications to SQL Server, you must establish a connection to both databases. You can do this using the Manage Connections tool, or a combination of other connection utilities.
For ODBC connectivity, we recommend that you always use the most recent supported version of the ODBC provider available when creating new connections. We also recommend that you upgrade existing connections to use the most recent provider when possible.
When creating a new SQL Server connection, HCOSS defaults the connection to the latest ODBC provider installed and supported on the system. For any SQL Server connection on the SQL Server Connection tab or Connection List tab, you can select from a drop-down list of installed and supported SQL Server ODBC providers. You can also set the ODBC provider for all SQL Server connections on the Connection List tab.
For information on supported ODBC drivers, see the HCO for SQL Server (HCOSS) topic under Additional Software Requirements.
To aid in ensuring the fastest performance during HCOSS data transfer, the Manage Connections tool checks to determine if any of the following OLE DB providers are available on your system:
Manage Connections does not directly create SQL Server OLE DB connections. Instead, it uses the ADO.NET provider System.Data.SqlClient and the ODBC provider selected. The Transfer Data tool converts the connection string for SQL Server connections created in Manage Connections to work with these specific OLE DB providers automatically to achieve the fastest data transfer performance. You can also use newer or alternative OLE DB providers by creating those connections in the ADO.NET connection editor. You can select one of these as the target connection in the Transfer Data tool.