License Warning on Startup

If you start Datical DB and a license is not installed, a warning is shown. 

Click OK to dismiss the warning. You can proceed to work in the GUI, but you cannot connect to databases until you install a license. 

Installing a License from the GUI

1. Obtain a license file from Datical Support and place it on the system where you are running an instance of Datical DB. 
2. Start Datical DB. Dismiss the license warning (click OK). 
3. In the GUI, choose File > License Manager. 
4. Select the type of license to install, then click Next.
   
   
   
5. Choose (Re)Install a license key, the click Next. 
   
    
6. Use the browser to choose the license file. 
   
   
   
7. Click Install License Key.
8. Click Finish. 

Displaying a License Key in the GUI

You can display the license key installation date and expiration date, as well as details about the license.

1. Start Datical DB.
2. In the GUI, choose File > License Manager. 
3. Select the type of license to display, then click Next.
   
   
   
4. Choose Display the installed license key, the click Next. 
   
   
   
5. Review the license information. Click Finish when done. 
   

Installing License using the Command Line (CLI)

If you have the repl subdirectory of your Datical installation on your path, you can run these hammer commands from any directory.  Or if you don't have it in your path, then you need to be in your "<Datical Installation>/repl" directory to run these commands from the command line:

Before installing your new license, you should uninstall all older licenses:

hammer uninstallLicense

The uninstall command will uninstall all of your Liquibase Enterprise/Datical DB licenses.

Copy the new license file to the location where you keep your license files.  

Run the following command to install your new license:

hammer installLicense <path_to_license_file>

For example:

hammer installLicense /opt/datical/license/<CompanyName>-<ExpirationDate>.lic

To check what license is currently installed run the following command:

hammer show license

Counting Licensed Objects

Datical DB is licensed by the number of DbDefs managed in a database object. The object licensed depends on the type of database. 

• Oracle - per instance
• SQL Server - per database
• EDB Postgres - per database
• DB2 LUW - per database

License counting is a routine part of verifying the number of database connections (DbDefs) that you are managing, compared to the number that you are licensed to manage. 

The license counter reports on the projects that are installed on a host by inspecting the project files.  

When you run the license counter, specify a starting directory.  It walks the file system from that point down and reports on all project files that are found in the hierarchy. 

To count licenses, do the following: 

1. Log on to a host where you have created Datical DB projects. 

2. Run the license counter. The output goes to stdout, so provide a redirection to a file. 

   Linux:   hammer licenseCounter ~/datical > DaticalLicenseCount.txt
    
   Windows: hammer.bat licenseCounter C:\Datical\Projects > DaticalLicenseCount.txt

3. Inspect the license file to determine the number of licenses in use on the host. The following example shows the format of the report. 

   DB2:
   jdbc:db2://192.168.156.21:50000/int_db
   jdbc:db2://ec2-35-175-43-211.compute-1.amazonaws.com:50000/REFDB
   Total Unique DB2 Databases: 2
   
   Oracle:
   jdbc:oracle:thin:@localhost:1523/orclsid
   jdbc:oracle:thin:@192.168.156.21:1521/orcl
   jdbc:oracle:thin:@localhost:1521/orcl.shusak.com
   jdbc:oracle:thin:@localhost:1523:orclsid
   jdbc:oracle:thin:@localhost:1521:orcl
   jdbc:oracle:thin:@localhost:1521/orcl
   Total Unique Oracle Databases: 6
   
   MSSQL:
   jdbc:sqlserver://localhost\MSSQLEXPRESS:1433;databaseName=AdventureWorks2014
   jdbc:sqlserver://localhost\SQLEXPRESS:49818;databaseName=mydb2
   jdbc:sqlserver://localhost\SQLEXPRESS:49818;databaseName=mydb
   Total Unique MSSQL Instances: 2
   Total Unique MSSQL Databases: 3
   
   Total Instances Managed: 10
   Total Databases Managed: 11