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.
Copy the CurrentWare Database file (CWD) from your old CurrentWare Server to the new CurrentWare Server. Put it on the desktop for now.
On the new CurrentWare Server, go to Services (services.msc) and stop the CurrentWare Server service
Copy the CurrentWare Database file to the CurrentWare Server directory and overwrite the existing file.
Run Command Prompt (CMD) in Administrator mode.
Browse to the cwServer path in command prompt
“C:\Program Files(x86)\CurrentWare\cwServer”
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.
Your CurrentWare database is now upgraded
Go back to Services (services.msc) and start the CurrentWare Server service.
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 ...
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 ...
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 ...
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 ...
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 ...