DbVisualizer allows you to create tables, by adding the needed columns and restraints in several tabs, then pressing the 'Execute' button. Subsequently, you can choose the SQL files that you wish to open and analyze their contents, as well as perform any necessary modifications, then save the file or the current context. The contents of the database will then be displayed in the tree view mode, in the left side panel, enabling you to quickly access the section that interests you. You can then select the 'Database Driver' from the available list or add a new one using the 'Driver Manager'.Īfterward, press the 'Next' button, to enter additional information about the DB server, pinging it to verify if it can establish a connection, then click on to 'Finish' button to complete the process. In order to add a new connection, you will need to enter the alias, which will be used throughout the utility. Its user-friendly interface makes it quite simple to handle, allowing you to quickly open new database connections, either using the wizard or by inputting the required information yourself.
See the "Data Model" chapter for table-specific information.DbVisualizer is an efficient and easy to use software solution which aims to assist you in thoroughly managing and maintaining your database, with the least amount of effort for you.Īfter installing the application, you can launch it and begin working with it. See the "Supported SQL" chapter in the help documentation for more information on the supported SQL. Select the Database Connection, Database, and Schema from the available menus. To execute SQL queries, use the SQL Commander tool: Click SQL Commander -> New SQL Commander.
To browse through tables exposed by the DB2 JDBC Driver, right-click a table and click Open in New Tab.
Driver: Select the driver you just created.ĭatabase URL: Enter the full JDBC URL.If you selected the "No Wizard" option, select the Generic or Auto Detect option in the Database Type menu. Database Type: If you selected the wizard option, the database type is automatically detected.
In the Connection section, set the following options: In the Database tab, right-click the Database Connection node and click Create a Database Connection.In the Driver Class menu, select the DB2Driver class, 2Driver.ĭefine the Connection to the JDBC Data Sourceįollow the steps below to save connection properties in the JDBC URL.In the User Specified tab, click the Open File button and select the file, located in the lib subfolder of the installation directory.