Frequently Asked Questions

Registration Issues

Login on customer area using your email address. Here you have full access on your data.
Login on customer area using your email address. Here you have full access on your data, can purchase renewal and edit your profile.
Login on customer area using your email address. Here you have full access on your data, can purchase renewal and edit your profile.
Login into your account. Then you may follow this steps. Near each subscription listed in the control panel you have an option to 'Align invoice details'. Just follow this link. In case of issues please contact the direct online support in the interface.
Login into your account. Then use the 'upgrade' option. Here you may change the number of licenses. You will get new licenses, same as using renewal option.
According to EU regulations, all customers located within the EU are required to pay VAT unless they have a valid VAT ID, in which case they are exempt from VAT. Purchases made through Avangate by EU shoppers are subject to a VAT rate according to the customer's country of residence or establishment. Sales made by Avangate to shoppers established in Iceland, Norway and Switzerland (outside of the EU) are subject to each country's VAT.

For EU countries, If you place the order as a private person, it will charge you VAT. If you place as a company, it should not charge you VAT, if you pay intracommunitary taxes.

Please note that we do not support a tax exemption flow during checkout, however once the order is finalized, based on a valid tax exemption certificate we can initiate a refund for the charged sales tax. One important thing is that taxes are being applied based on delivery details and in order to qualify for a tax exemption flow the order has to be registered under the Institution name. In the shopping cart the customer must fill out the company form. After the order is placed the customer must send us at the tax exemption certificate and the order reference number.

General Issues

Our installer and executable is created using Install4j and Exe4j. For debugging the installer you can start use the variable '-Dinstall4j.debug=true'. For debugging the DbSchema.exe you can execute from command prompt 'DbSchema.exe /create-i4j-log'. This will report where the log file is created. Please report us any issue you got.

Database Connectivity & Schema Synchronization

Check the application help for the database you connect. The problem can be in database configuration, firewall, etc. Contact support for help.
We apply the modification as it is in the database and store it in DbSchema as well. The database may slightly re-write it, and by next refresh is reported as being different. As example default values using sequences in Postgres may look different after refresh. We cannot influence this and you should refresh the diff in DbSchema.
DbSchema knows only some predefined data types ( configured in Connection / Rdbms Settings ) plus the one which are used in the current database schema. Based on the forms and reports engine we are currently developing, we build a management console for each database. This will allow to manage the user defined data types. The management console will be open source software.
True. If you refresh the schema you will not want to loose your comment in DbSchema. This difference will show only when you do a schmea compare from the menu.
Foreign key support 'on delete' and 'on update' actions, which specifies what should be done when a record from the primary key table is deleted. By default if a children record exists, an error is shown ( this is on delete no action ). 'On delete cascade' will drop the children records when the pk record is removed. 'On delete restrict' is for the most of the databases similar with 'on delete no action'.
DbSchema use JDBC driver methods to reverse engineer the schema from the database. Procedures, triggers and functions are loaded using configurable SQL queries listed in Connection / Rdbms Settings dialog. They are the best queries we could found searching the internet. If you have any clue how the queries can be improved please write us.

Mac OS Issues

Please check this post. There are explained few different ways of linking the Java in the Mac OS. The most important is this :
Execute in terminal
whereis java
will return /usr/bin/java which in turn points to /System/Library/Frameworks/JavaVM.framework/Versions/A/Commands/java, which is Apple's 1.6 version.

So, if you want to use the new java version, replace the /usr/bin/java symlink so that it points to /Library/Internet\ Plug-Ins/JavaAppletPlugin.plugin/Contents/Home/bin/java instead:

sudo rm /usr/bin/java
sudo ln -s /Library/Internet\ Plug-Ins/JavaAppletPlugin.plugin/Contents/Home/bin/java /usr/bin


Table inherit allows defining one table based on the definition of another table. In practice they are two distinct tables and JDBC will report the structure of each table distinct, without inheritance. You may create one table in DbSchema, and creating the second table specify the inheritance in the table storage panel. On refresh the diagram will get all columns, as it is physically in the database . Since we trust on JDBC implementation which does not consider the inheritance, there is no way for us to support it deeper.
Enter in the column default value something like "nextval('products_product_no_seq')". Database does not allocate a sequence to a certain column, therefore DbSchema won't do it as well. After a refresh you will see the default value slightly different in the database - Postgres does rewrite its definition. You have just to apply the difference in the local project.
In the connector editor choose to enter a custom URL. There you can enter something like "jdbc:postgresql://localhost/test?user=fred&password=secret&ssl=true". See more samples here.


No, there is no difference in DbSchema. The EE adds features to replication, online index rebuild, etc. in Oracle, which are mostly admin features. DbSchema is compatible with both versions.


Kerberos can be configured outside DbSchema, something like here. Then edit dbschema.bat to include the library as in documentation and start it using dbschema.bat.


Our interface is based on libraries. Jide announced Nimbus is not compatible with their infrastructure.