Upgrading the CurrentWare database using CWSM.exe

Upgrading the CurrentWare database using CWSM.exe

The command line database upgrade will convert any older CurrentWare database (CWNPFB) to the CurrentWare version that is installed on your computer.

For example, if you have CurrentWare v5.5.3 installed on your computer, you can take any older database, put it in the cwServer folder, run the command line and upgrade it to version 5.5.3.

  1. Copy the CurrentWare Database file (CWD) from your old CurrentWare Server to the new CurrentWare Server. Put it on the desktop for now.
  2. On the new CurrentWare Server, go to Services (services.msc) and stop the CurrentWare Server service
  3. Copy the CurrentWare Database file to the CurrentWare Server directory and overwrite the existing file.
  4. Run Command Prompt (CMD) in Administrator mode.
  5. Browse to the cwServer path in command prompt
“C:\Program Files(x86)\CurrentWare\cwServer”
  1. Run this command line to perform the database upgrade:
CWSM.exe –update –silent

Note: If you get the message that CWSM.exe is not recognized as an internal or external command, you’ve made a typo in your commands.

  1. Your CurrentWare database is now upgraded
  2. Go back to Services (services.msc) and start the CurrentWare Server service.

    • Related Articles

    • Security & SQL Database Best Practices

      Security and Workflows Connection to the Web Console Starting with v8.0.1, the CurrentWare web console will have a preconfigured self-signed SSL certificate that is enabled by default. This will ensure that network communication to and from the ...

    • Create a fresh database

      By default, CurrentWare comes with SQL Express pre-installed, which has a 10 GB data limit. To avoid reaching this limit and still keep your historical data intact, you can opt to create a fresh database. Although you may have to reconfigure previous ...

    • Renamed The CurrentWare Server PC

      If you renamed your CurrentWare server PC and find yourself having issues opening your web console, it’s likely due to the backend SQL connection properties. The easiest way to fix this issue is to do a quick uninstall and reinstall of the server ...

    • What is DB caching in CWSM?

      The button to clear Database Cache is a best practice query that will run on your CurrentWare SQL Database to improve performance of table load times within your CurrentWare Console. It will run the “exec sp_updatestats” command which is used to ...

    • Adding CurrentWare to your BitDefenders Exclusion Lists

      Bitdefender Antivirus can sometimes interrupt with the functionalities of CurrentWare due to where the local files are hidden on the client PCs. RECOMMENDED: Temporarily Disable Bitdefender Prior to Upgrades If you have any of the Bitdefender ...