Create a fresh database

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 settings, there are several benefits of starting a fresh database:

No legacy data: A fresh database has no legacy data to deal with and maintain.

Improved data integrity: Starting with a clean slate allows you to enforce data integrity and consistency from the beginning, ensuring accurate data representation.

Better performance: Without legacy data and constraints, a fresh database can be optimized for performance, leading to faster query times and reduced load on the system.

Cost savings: Starting a fresh database is less expensive than upgrading to a SQL standard license.

Troubleshooting: By creating a new database, you can confirm if you are having any permission related issues with logon accounts.

How to create a fresh database

  1. From your server PC run a windows search for “cwsm.exe” or go to C:\program files(x86)\CurrentWare\cwServer\ and run the “cwsm.exe” application.
  2. Go to the “Database” tab
  3. Go to the section labeled “SQL Database Name“.
  4. Press the “Edit” button.
  5. Change the name to “CWNPSQL1“.
  6. This will recreate a database connection and prompt you to enter an operator user name and password
  7. The new database is created and you can now log in to your console running a fresh database.


    • Related Articles

    • Move the CurrentWare server to another computer with network SQL database

      When moving your CurrentWare software to a new server/PC you need to make sure you do not have both consoles connecting to the same networked database. Here are the steps to take. #1 Back up your existing cwServer Database Before you migrate your ...

    • How to recover your CurrentWare Console password

      During the CurrentWare installation or upgrade process you are prompted to create an operator account and password. The user information is encrypted and stored on your local database. If you have forgotten your account information the CurrentWare ...

    • Which databases does the CurrentWare Server support?

      The CurrentWare Server is compatible with the following databases: SQL Server Express (default) SQL Server Standard SQL Server Enterprise SQL Server As of v6.0.1, SQL Server is necessary as a database for Currentware. Please see our informative guide ...

    • How do I Setup CurrentWare with SQL Express

      Welcome to the SQL Express Database Installation and Setup page. Benefits of using a SQL Database with the cwServer are an increase in overall performance and stability of client connections. Here are the steps to download, setup and configure your ...

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