• Scroll to top of this topic Scroll to Top of Page

  • Print the current topic Print Topic

  • No expanding elements on this page Show/Hide Expanders

Command and connection timeout parameters

You can change command and connection timeout parameters for the Database Compare Tool application. They are listed in the configuration file DBBest.DataSuite.Application.exe.config, which is located in the root of the application folder. To make changes to command and connection parameters, you have to edit this file.

  1. Open the configuration file DBBest.DataSuite.Application.exe.config from the root of the application folder.
  2. Command timeouts are listed in the following rows:

    <add key=”azure.command.timeout” value=”0″/>

    <add key=”azuredwh.command.timeout” value=”0″/>

    <add key=”db2.command.timeout” value=”0″/>

    <add key=”greenplum.command.timeout” value=”0″/>

    <add key=”mysql.command.timeout” value=”0″/>

    <add key=”netezza.command.timeout” value=”0″/>

    <add key=”oracle.command.timeout” value=”2147483″/>

    <add key=”postgresql.command.timeout” value=”0″/>

    <add key=”redshift.command.timeout” value=”0″/>

    <add key=”sqlserver.command.timeout” value=”0″/>

    <add key=”sybasease.command.timeout” value=”0″/>

    <add key=”sybaseiq.command.timeout” value=”0″/>

    <add key=”teradata.command.timeout” value=”0″/>

    <add key=”vertica.command.timeout” value=”0″/>

    You can change values of command timeouts for each database platform.

  3. Connection timeouts are listed in the following rows:

    <add key=”azure.connection.timeout” value=”30″/>

    <add key=”azuredwh.connection.timeout” value=”30″/>

    <add key=”db2.connection.timeout” value=”30″/>

    <add key=”greenplum.connection.timeout” value=”30″/>

    <add key=”mysql.connection.timeout” value=”30″/>

    <add key=”netezza.connection.timeout” value=”30″/>

    <add key=”oracle.connection.timeout” value=”30″/>

    <add key=”postgresql.connection.timeout” value=”30″/>

    <add key=”redshift.connection.timeout” value=”30″/>

    <add key=”sqlserver.connection.timeout” value=”30″/>

    <add key=”sybasease.connection.timeout” value=”30″/>

    <add key=”sybaseiq.connection.timeout” value=”30″/>

    <add key=”teradata.connection.timeout” value=”30″/>

    <add key=”vertica.connection.timeout” value=”30″/>

    You can change values of connection timeouts for each database platform.

  4. Please note that the timeouts are specified in seconds. 0 value means infinite timeout. For Oracle command timeout, you can use values from 1 to 2147483; zero value for command timeout can be used in ODAC 12c Release 1 and later versions.