Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Liquibase Business was formerly known as Datical DB.

...

Table of Contents

License Warning on Startup

If you start Datical DB Liquibase Business and a license is not installed, a warning is shown. Image Removed

...

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 in the Desktop Client/Eclipse GUI

  1. Obtain a license file from

    Datical

    Liquibase Support and place it on the system where you are running an instance of

    Datical DB

    Liquibase Business

  2. Start

    Datical DB

    the GUI. 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.

    Image RemovedImage Added

  5. Choose (Re)Install a license key, the click Next

    Image RemovedImage Added

     

  6. Use the browser to choose the license file. 

    Image RemovedImage Added

  7. Click Finish

Displaying a License Key in the Desktop Client/Eclipse GUI

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

  1. Start

    Datical DB.

    the GUI

  2. In the GUI, choose File > License Manager

  3. Select the type of license to display, then click Next.

    Image RemovedImage Added

  4. Choose Display the installed license key, the click Next

    Image RemovedImage Added

  5. Review the license information. Click Finish when done. 


    Image Removed


    Image Added

Update license from CLI (using "hammer" command):

Just before installing your new license, you can run an uninstall command to uninstall all older licenses:

hammer uninstallLicense

Run the following command to install your new license:

hammer installLicense <path_to_license_file>

For example:

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

Displaying license from CLI:

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

hammer show license

Counting Licensed Objects

Datical DB Liquibase business is licensed by the number of DbDefs connections managed in a database objectan organization. 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. 

...

To count licenses, do the following: 

  1. Log on to a host where you have created

    Datical DB

    Liquibase Business projects. 

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

    Code Block
    Linux:   hammer licenseCounter ~/datical > DaticalLicenseCountLBBLicenseCount.txt
     
    Windows: hammer.bat licenseCounter C:\DaticalLBBusiness\Projects > DaticalLicenseCountLBBLicenseCount.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. 

    Code Block
    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


...