CyberStore Upgrade Procedure

Before you Upgrade

• Turn off the website using the IIS Administration tool (Start > Run... > inetmgr)
• Backup the SQL Databases:
  • SYSPROCyberStore
  • SYSPROCyberStoreConsole
• Backup the CyberStore program files:
  • C:\Program Files\Dovetail\e-Commerce System\Ecommerce
  • C:\Program Files\Dovetail\e-Commerce System\Console
• Backup your Site directory
  • Generally, this is located at C:\Program Files\e-Commerce System\MyCompanySite
• Download all CyberStore build zip files for versions newer then the one installed. The build zip files can be found at http://www.dovetailinternet.com/CyberStore_Builds
  • To determine what version of CyberStore you are running, examine the Properties of Dovetail.Ecommerce.dll in the C:\Program Files\Dovetail\e-Commerce System\Ecommerce\bin folder
  • You may also check the version of CyberStore by clicking on the "About Us" link in the Console.

 The Upgrade Steps

• Apply each build zip file in order.
• Update the CyberStore program files by copying the contents of the SRC directory from the build zip file to the appropriate application install directory
  • For example, from a Command Prompt use the following command from within the patch directory: xcopy C:\1.9.xxx Patch\src\*.* to c:\Program Files\Dovetail\e-Commerce System\ /S /E
  • WARNING: Do not use Windows to "copy and paste" or "drag and drop" files into the CyberStore directories.  This operation may copy incorrect permissions to the CyberStore directory and cause CyberStore to stop working properly.  Please use a command line tool such as xcopy, as shown in the example above.
• Update the CyberStore databases by opening each SQL script in the DATA folder from the build zip file in SQL Query Analyzer, for Microsoft SQL 2000, or SQL Management Studio, for Microsoft SQL 2005, and executing it against the appropriate database
  • Please consult the included README.TXT file to determine if there is a special order in which to apply the SQL scripts
  • SQL Scripts prefaced with ECommerce should be applied to the SYSPROCyberStore database
  • SQL Scripts prefaced with Console should be applied to the SYSPROCyberStoreConsole database
• Determine if there are any configuration steps, such as updating the web.config file, by reading the Release Notes.
• Implement any design/site template changes by comparing any Template files in the update to the same files in your Site folder
  • For example: new css classes may be introduced and need to be added to c:\Program Files\Dovetail\e-Commerce System\MyCompanySite\themes\css)
• Customizations (If Applicable):  If you have customized controls then they need to be reviewed and any new changes retrofited into the customized version.  Controls are customized by copying them from the /Ecommerce/control folder into the Site/control folder and then modifying them.

After the Upgrade

• Turn back on the web site.
• Refresh the operator.
• Place a test order.

Version Specific Notes

• All Versions - When executing SQL Upgrade scripts, note that scripts beginning with ECommerce should be applied to the SYSPROCyberStore database while scripts with Console should be applied to the SYSPROCyberStoreConsole database.
• 1.6.25 - starting with 1.6.25, Release and Debug DLLs will be distributed for the ECommerce directory.  Please backup and remove all DLL's in the ECommerce\bin directory prior to applying patch 1.6.25. This also applies to the 1.6.32 cumulative update as well.
• 1.7.90 - starting with 1.7.90, Release and Debug DLLs will also be distributed for the Console directory.  Please backup and remove all DLL's in the Console\bin directory prior to applying patch 1.7.90.