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.
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): 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.
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.
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.
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.
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.
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.
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.
EU regulations require customers within the EU to pay VAT unless they provide a valid VAT ID, which exempts them. VAT rates are based on the customer's country of
residence.
Private individuals in the EU are always charged VAT.
Companies in the EU may be exempt if they qualify for intra-community tax rules.
For non-EU countries like Iceland, Norway, and Switzerland, VAT applies based on local regulations. VAT exemptions are verified through the VIES system.
If eligible, you can apply for a VAT refund in two ways:
Choose Wire Transfer as the payment method and send us the tax exemption certificate.
Complete a normal purchase and email the tax exemption certificate to us for a refund.
Note: VAT is applied based on delivery details, and to qualify, the order must be under an institution's name. Fill out the company form in the cart and
contact PayProGlobal, providing the certificate and order reference number to after purchase.
To facilitate future tax-exempt purchases, please ensure that you select the box labeled "Business purchase" on the checkout page and enter your VAT ID in the appropriate field.
By following these instructions, you will prevent VAT from being applied to your purchases.
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 takes several steps to ensure the highest standards of security:
The application is built with the latest technologies, including OpenJDK and JavaFX, minimizing security risks.
We do not send or receive data from other applications. We only connect to databases via JDBC drivers provided by the database software companies. These drivers
implement their own security measures like SSH, SSL, and encryption.
DbSchema periodically checks for updates, which may involve connecting to the DbSchema web server for updates, documentation, and additional drivers.
We adhere to strict German and European security standards, some of the highest in the world.
Users can access application logs through the Help / Output Logs feature to review any actions taken by the software.
Customer support responds quickly to any issues, and the software is thoroughly tested before any version release. While we support many databases and strive
for bug-free performance, occasional issues may arise, and we work to resolve them as quickly as possible.
For connectivity issues you can press the "Help me to connect" button from the connection dialog in the application. This will take you to the documentation where you
can find specific connection pages for each database.
If the problem can't be solved, please send us an issue ticket.
When refreshing the schema in DbSchema, the database may internally modify certain elements (e.g., default values with sequences in PostgreSQL), causing slight
differences.
These changes are beyond DbSchema's control. To resolve this, refresh the diff in DbSchema and review the changes.
DbSchema supports predefined data types (configured in the Connection/RDBMS Settings) and any user-defined types used in the current schema. For better management of
these types, we're developing a management console tailored to each database engine.
This console will be open source, enabling users to manage their custom data types more effectively.
When refreshing the schema, DbSchema preserves your comments, so they won't be lost.
The difference will only appear when performing a schema comparison from the menu.
Foreign keys support 'on delete' and 'on update' actions, which define what happens when a record in the primary key table is deleted. By default, if child records
exist, an error occurs (this is 'on delete no action'). 'On delete cascade' will delete the child records when the parent record is removed.
'On delete restrict' is similar to 'on delete no action' in most databases.
DbSchema uses JDBC driver methods to reverse-engineer the schema from the database. Procedures, triggers, and functions are loaded using configurable SQL queries in the
Connection/RDBMS Settings dialog.
These queries are the best available at the moment. If you have suggestions for improvements, please contact us.