DbSchema Support

Login on customer area using your email address. Here you have full access on your data.

Go to customer area and login using your email address. Here you have full access on your data, can purchase renewal and edit your profile.

Go to customer area and login 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 an error, please send us an issue ticket.

Access your account. Please access the subscription management section from your 2Checkout cPanel using this URL https://secure.2checkout.com/cpanel/licenses_management.php Search for the subscriptions you wish to modify and once you locate the customers subscription click on the View button from the subscription details tab. You can click on extend subscription from the new page opened and modify the billing date for the subscription.

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 2checkout by EU shoppers are subject to a VAT rate according to the customer's country of residence or establishment. Sales made by 2checkout 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 intra-communitary taxes.

The verification of the VAT exemption number is carried out through the VIES service, a system for checking the validity of VAT registrations http://ec.europa.eu/taxation_customs/vies/vatResponse.html?locale=it

Some customers may present documents which except them from paying VAT taxes. Tax refund can be done in two ways:

1. Choose Wire Transfer as payment method during purchase and send us the tax exception certificate.
2. Do a normal purchase and send us the tax exception certificate. We will pay back the 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 pay@2checkout.com the tax exemption certificate and the order reference number.

Our installer and executable is created using Install4j and Exe4j. For debugging the installer you can use the variable -Dinstall4j.debug=true

For debugging the DbSchema.exe you can execute from command prompt DbSchema.exe /create-i4j-log This will indicate where the log is created.

On Mac DbSchema can be debugged by executing in terminal:

export INSTALL4J_LOG=yes
/Applications/DbSchema.app/Contents/MacOS/JavaApplicationStub

On Mac or Linux DbSchema can be started calling Java directly like this:

/Applications/DbSchema/.install4j/jre.bundle/Contents/Home/bin/java -cp "lib/*" com.wisecoders.dbs.DbSchema

In order to implement the best standards for data and software security, DbSchema does:

• The application has been migrated to the latest technologies: OpenJdk latest version and JavaFx latest version. This keeps the general Java security at a minimum risk.
• We do not send any data or receive any data from any other application. The single method we connect to the databases is through JDBC drivers. They are provided by the database software companies. Most of them implement their own security measures ( SSH, SSL, encryption, etc). However, the application does periodically check for new updates, which may require to connect to DbSchema web server. The documentation and few other drivers are also downloaded dynamically from the web server.
• We keep up to date with the latest German and European security standards, one of the highest in the world.
• Using the Help / Output Logs the client can read all application logs
• Our principle is to fast answer any issue from the customer support. Before any version release the software is tested and verified. Due the high number of the databases we support we still may have bugs or issues. We try to solve this as fast 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.

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 an 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.

If you refresh the schema you will not want to loose your comment in DbSchema. This difference will show only when you do a schema 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 can find at the moment. If you have an input on how can they be improved, please contact us.

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.dbs.DbSchema -x sample.groovy
                

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