Frequently Asked Questions

▶ Licensing Details
- ▶ Security & Certifications
  - ▶ Certifications and Security
    
    DbSchema is ISO-27001 certified. DbSchema is a desktop application, written in JavaFX, build to support large databases with over 10.000 tables. For security reasons we use Git as collaboration method, which means our customers will always keep their data inside their organization. As stated in our EULA, we don't transmit any data outside the application.
    
    The communication with the database is done through JDBC drivers, provided by the same companies who wrote the database software. Most of the offer a high level of encryption, MFA authentication, SSL, etc.
  - ▶ Why is Git as Collaboration Solution the best solution?
    
    There are database designers offering cloud solutions as collaboration method. We consider this as unsecure, since there are many levels where the security can be broken: communication with the cloud, cloud web server, etc.
    
    We use Git as collaboration solution ( can be an internal company server or a Git provider: Github, Bitbucket, etc.). This are market established solutions offering a high level of security. Using company internal Git servers is the most secure approach. Alternatively, you can use any other versioning system.
  - ▶ Export Control Classification Number (ECCN)
    - Export Control Classification Number (ECCN): DbSchema is classified as EAR99, meaning it is not listed on the Commerce Control List (CCL) and is subject to minimal export restrictions under the U.S. Export Administration Regulations (EAR).
    - Classification Method: DbSchema has been self-classified as EAR99 and has not been classified via a Commodity Classification Automated Tracking System (CCATS) submission to the U.S. Bureau of Industry and Security (BIS).
    - Additional Information: As EAR99 software, DbSchema can generally be exported without a license except to restricted countries, prohibited end-users, or for prohibited end-uses as defined by U.S. export control laws.
- ▶ Licensing & Registration
  - ▶ Perpetual License
    
    Our licenses are perpetual and never expire. They include one year of free upgrades to newly released versions, as well as maintenance and support. After the first year, you can continue to receive the latest updates by purchasing a renewal license.
  - ▶ Renewal & Maintenance
    
    After one year of purchasing your license, you will have the option to renew in order to continue receiving the latest updates. You can easily purchase a renewal license at a reasonable price.
    
    We are constantly improving DbSchema with new features, tools, database support, bug fixes, library updates, drivers, and security updates.
  - ▶ Request a Quote (Pro-Forma Invoice)
    - Please choose 'Purchase Order' as a payment method in the purchase form. You will receive the quote in an email from PayProGlobal.com.
  - ▶ How do I register DbSchema?
    - After purchase, you'll receive your license key(s) via email from payproglobal.com. Copy the keys into the Help / Registration dialog, or use the option to load them from a file.
  - ▶ I’ve registered but lost my license key. Can I recover it?
    - Yes, login on customer area with your email address to access your license key and other details.
  ▶ Account & Subscription Management
  - ▶ Is the license transferable to another user? How can I transfer it?
    - License keys are per person and must remain within the same organization. If an employee leaves, you can transfer the license by using Help / Unregister on the old computer and Help / Register on the new one.
  - ▶ Can I update my profile's email address?
    - Yes, go to the customer area and log in with your email address. You can access your data, purchase renewals, and edit your profile there.
  - ▶ Can I align multiple purchases to a single renewal account?
    - Log in to your account. In the control panel, you'll find an "Align invoice details" option next to each subscription. Click the link to align them. If you encounter any issues, please submit a support ticket.
  - ▶ Can I change the number of renewed licenses?
    - Log in to your account via the PayProGlobal cPanel. Find the subscription you wish to modify, click View under the subscription details, and then select Extend subscription to adjust the billing and license details.
  ▶ Billing & VAT
  - ▶ Why do I have to pay VAT?
- ▶ Resellers
  - ▶ How can I register as a Reseller?
    - You can register as a reseller by signing up on PayProGlobal. Once registered, you can manage purchases and discounts directly through your reseller account.
▶ DbSchema Application
- ▶ Installation & Execution
  - ▶ Can I start the DbSchema installer or executable in debug mode?
  - ▶ Can I execute DbSchema in Headless mode (no display)?
  - ▶ Java 1.8 is already installed, but DbSchema is using an older version of Java.
    - Please check this post for detailed solutions. Below is the most important fix for macOS:
      
      Check your current Java version:
```
whereis java
```
      This will return /usr/bin/java, which typically points to Apple's older Java 1.6 version:
```
/System/Library/Frameworks/JavaVM.framework/Versions/A/Commands/java
```
      To use the new Java version, update the symlink:
```
sudo rm /usr/bin/java
sudo ln -s /Library/Internet\ Plug-Ins/JavaAppletPlugin.plugin/Contents/Home/bin/java /usr/bin/java
```
  ▶ Security & Connectivity
  - ▶ What are DbSchema's security measures?
  - ▶ How can I fix connectivity errors?
  ▶ Schema & Database Management
  - ▶Schema Differences on Refresh
  - ▶User-Defined Data Types in DbSchema
  - ▶Commented Field Behavior
  - ▶Foreign Key 'On Delete' Action
  - ▶Reverse-Engineering of Procedures, Triggers, and Functions