title: Is there a way to override the connection timeout when upgrading site from CMS 6 R2 to 7?
body: <p>I'm having a problem upgrading a site from CMS 6 R2 to 7. I'm getting a wait timeout error while upgrading using the Deployment Center. </p>
  
  <p>I already tried to add the following configuration in C:\Program Files (x86)\EPiServer\Shared\Install\EPiServerInstall.exe.config:</p>
  
  <pre><code> &lt;appSettings&gt;
    &lt;add key="commandTimeout" value="600"/&gt;
   &lt;/appSettings&gt;
  </code></pre>
  
  <p>but no avail.</p>
  
  <p>As much as I don't want to resort to manual upgrade, is there a way to override the connection timeout?</p>
  
  <p>Thanks in advance for any help.</p>
  
  <p><strong><em>Edit:</em></strong></p>
  
  <p>Upgrade log (too long so I cut it just to display the error message):</p>
  
  <pre><code>....
  Executing database script "C:\Program Files (x86)\EPiServer\CMS\7.0.586.1\Upgrade\Database\sql\0007_0000_0041_0000to0007_0000_0147_0000.sql"
  An error has occured and the transaction will be rolled back
  Rolledback
  The wait operation timed out
  The wait operation timed out
  
  An unhandled error has occured:
  The wait operation timed out
  When executing
  At C:\Program Files (x86)\EPiServer\CMS\7.0.586.1\Upgrade\System Scripts\Upgrad
  e Site Database (SqlServer).ps1:9 char:2
  +     Execute-EPiSqlSvrScript -EPiServerScript -ScriptPath $file -SqlServerName
   $dbCo ...
  +    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
  ~~~~~~
  
  =
  Get-EPiIsBulkInstalling
  At C:\Program Files (x86)\EPiServer\CMS\7.0.586.1\Upgrade\System Scripts\Upgrade Site Database (SqlServer).ps1:9 char:2
  +     Execute-EPiSqlSvrScript -EPiServerScript -ScriptPath $file -SqlServerName $dbCo ...
  +    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
  System.ComponentModel.Win32Exception (0x80004005): The wait operation timed out
     at EPiServer.Install.InstallationManager.Install(Installer installer)
     at EPiServer.Install.SqlServer.SqlServerInstallationManager.ExecuteDatabaseScript(String sqlServerName, Nullable`1 sqlServerPort, String databaseName, String loginName, String loginPassword, String scriptFilePath, Boolean avoidDbTransaction, Boolean isEPiServerScript, IDictionary parameters)
     at EPiServer.Install.SqlServer.Cmdlets.ExecuteSqlScriptCmdlet.ProcessRecord()
     at System.Management.Automation.Cmdlet.DoProcessRecord()
     at System.Management.Automation.CommandProcessor.ProcessRecord()
  </code></pre>