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

    • 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 ...

    • 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 ...

    • Remote CurrentWare Console is unable to connect to CurrentWare Server using SQL database

      If you have setup a Remote CurrentWare Console to be able to access your CurrentWare server running off a SQL database and are having connection issues. This is usually caused by either Firewall blocking or SQL Server settings. Solutions Turn OFF ...

    • Backup and Restore the SQL Database

      It is important to back up your CurrentWare SQL database to ensure that you retain your historical information from CurrentWare’s solutions such as BrowseReporter and AccessPatrol. There are a few ways to back up the CurrentWare database. 1. Backup ...

    • Change the CurrentWare Database Backup Location

      Using the CurrentWare application to backup only gives you the option to use the default SQL folder backup location. The backup must be in the default folder for SQL to recognize it. This page will help you change the location for the backups. To use ...