Licensing, billing and the DbSchema application: search the answers, or browse them below.
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, but the in that case you will have to use external tools. Git is integrated in DbSchema, so you can use it directly from the application, without the need of external tools.
Procurement and legal teams can download them directly:
The Customer Area lists every agreement, certificate and policy under EULA & Policies. For a vendor registration form or a security questionnaire, open a support ticket and attach it.
A perpetual license never expires. It runs every DbSchema version released within one year of the purchase, and includes maintenance and support for that year. To receive the versions released after that year, renew the Software Updates and Maintenance.
A renewal adds one more year of new versions, maintenance and support. We are constantly improving DbSchema with new features, tools, database support, bug fixes, library updates, drivers, and security updates.
A renewal is optional: without it, your license keeps working with every version released in the year you paid for, and nothing needs to be cancelled. The current renewal price is on the purchase page, and you can renew here or with Renew now in the Customer Area.
If you renew before the current year ends, the time left is added to the new year, so renewing early costs you nothing.
The version you installed was released after the year of updates that your license includes. Your license still works with the versions released within that year. Either renew the Software Updates and Maintenance, or install a version from your year of updates from Previous Releases and register it with the same key. If you install on a computer without internet access, download the key from Keys in the Customer Area.
Newly issued and renewed keys need a recent DbSchema version, and an older version rejects them with a message that asks for a renewal. Install the latest version from the download page and register the key there.
On the purchase page, use Get a quote under the edition you need. The quote includes the taxes for your country, and PayPro Global, our payment provider, sends it by email.
To pay by purchase order or bank transfer, choose Pay Later at checkout, then Purchase Order.
After the purchase, PayPro Global emails your license keys. In DbSchema, open Help / Registration and either sign in with your DbSchema Account, or paste the license key, or load it from a file. A license key spans several lines: paste all of them.
Yes. Sign in to the Customer Area with the email address used for the purchase, and open Keys next to the subscription.
Yes, by 15 days: enter your email on Extend Evaluation, and you receive a trial license key by email. If you need more time after that, open a support ticket.
A license key can be active on 2 computers. To move it to another computer, first use Help / Unregister on one of the computers where it is active.
Open a support ticket with the email address used for the purchase. We clear the activations of your license key, and you can register it again on the new computer.
The Customer Area shows your subscriptions, license keys, invoices and renewal links, and lets you assign licenses to users. It has no password: enter the email address used for the purchase, and open the sign-in link that we email you. If no email arrives, check the spam folder.
If the Customer Area shows no subscription, the license was probably purchased under a different email address.
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.
To assign a commercial subscription to a colleague, sign in to the Customer Area, open the ⋯ menu of the subscription, and choose Reassign end-user.
The Customer Area shows for each subscription whether it renews automatically. To stop the automatic renewal, or to cancel a monthly subscription, sign in to your PayPro Global account with the email address used for the purchase, or open a support ticket and we switch it to manual renewal.
A perpetual license whose renewal you do not pay needs no cancellation: it keeps working.
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.
Yes. Open a support ticket with the email addresses of the subscriptions and the number of licenses you need. We send one checkout link that renews and adds them together, with a single renewal date; licenses added in the middle of a term are priced for the time left.
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.
Orders and license keys belong to the email address used for the purchase. To move them to another address, open a support ticket from the current address. Once the order is moved, download the new keys from the Customer Area.
PayPro Global emails it after the payment. You can also download it from the Customer Area: open the ⋯ menu of the subscription and choose Invoice.
An order appears in the Customer Area, and its license keys are created, once PayPro Global confirms the payment. An order in Waiting status is still waiting for the payment, as happens with a bank transfer or a purchase order.
To see the status, sign in to your PayPro Global account with the email address used for the purchase. For a bank transfer, PayPro Global may ask for the bank's SWIFT confirmation to find your payment.
Yes. If your organization needs time to pay a purchase order, open a support ticket with the number of licenses and how long you need them. We send temporary keys that work until the payment arrives.
Your subscription still runs with our previous payment provider. Open a support ticket: we stop the old subscription and send you a renewal link with PayPro Global.
Yes, if you ask within 15 days of the charge. Open a support ticket from the email address used for the purchase, and we refund the charge and stop the automatic renewal if you wish.
PayPro Global, our payment provider and reseller of record, processes every order and issues the invoice. Payments go to PayPro Global's bank accounts.
Prices are set in US dollars. A quote or a checkout in another currency is converted at the current exchange rate, so the amount can change slightly between the quote and the payment. To pay exactly the quoted amount, choose US dollars.
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.
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:
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.
Get the quote with Get a quote on the purchase page, and complete the purchase. Then email [email protected] with your order reference and tax exemption certificate, and PayPro Global pays the taxes back.
You can register as a reseller by signing up on PayProGlobal. Once registered, you can manage purchases and discounts directly through your reseller account. The Resellers page explains how a reseller sale works.
Sign in to the Customer Area with the email address of your reseller account, open Purchase, and choose your reseller account. Under New license, choose the license type and usage, then Quote or Get purchase link. Your commission is credited automatically.
Every subscription sold through your reseller account is listed in the Customer Area with its own Quote and Renew now links, so a renewal needs no special link.
DbSchema is delivered electronically: once the payment is confirmed, PayPro Global emails the license keys to the email address entered at checkout. There is no shipment and no tracking number.
Resellers see every order placed through their account in the Customer Area. When you ask support about an order, give the purchase email or the PayPro Global order ID: we cannot find an order by your purchase order number.
We do not process purchase orders sent by email, because only PayPro Global's checkout applies the taxes for your country and issues the invoice. Get a quote or a purchase link from the purchase page, or from the Customer Area if you are a reseller. At checkout, choose Pay Later, then Purchase Order.
Teachers: open a support ticket from your school email address to request a free class license, which is renewed for each academic year on request. Sign in to the Customer Area and add each student's email address to the license.
Students: in DbSchema, open Help / Registration and sign in with your DbSchema Account, using the email address that the teacher added. If you need a license for a course, ask your teacher to request a class license.
Our installer and executable are created using Install4j and Exe4j. For debugging:
-Dinstall4j.log=<Path-to-File>DbSchema.exe /create-i4j-log (This will indicate where the log is created.)export INSTALL4J_LOG=yes /Applications/DbSchema/DbSchema.app/Contents/MacOS/JavaApplicationStub
/Applications/DbSchema/.install4j/jre.bundle/Contents/Home/bin/java -cp "lib/*" com.wisecoders.dbschema.DbSchema
If you need to run DbSchema scripts in headless mode you can download the monocle jar, place it in lib directory and start DbSchema like this:
jre/bin/java -Djava.awt.headless=true -Dglass.platform=Monocle -Dmonocle.platform=Headless -Dprism.order=sw -cp "lib/*" com.wisecoders.dbschema.DbSchema sample.groovy
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
DbSchema takes several steps to ensure the highest standards of security:
When a connection fails, DbSchema shows the driver's error with a DbSchema Advice for the errors it recognizes. Tips & Help in the connection dialog opens the setup notes for your database, and the connection documentation explains the common errors. 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 user data types, such as PostgreSQL domains and enum types, for the databases that can declare them. Create one from Model → Create Table, View... → Create User Data Type; the user data types documentation explains how.
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.