DBVisualizer is one of the most useful Database IDE’s available. I have used it at many different companies and for personal projects as well. I like DBVisualizer it in part because its publisher DBVis Software offers both a free version for personal use and a pro version for businesses. Unlike most free tier software, DBVis has made the decision to unlock most of the applications functionality. Allowing individuals and companies to check out what their tool can do with no immediate risk to their pocket book. What is unique about DBVisualizer is its unique ability to be database neutral.
What is unique about DBVisualizer is its ability to be database neutral. Regardless of the Database you’re using, DBVisualizer will work the same. To do this, all the application requires is a compatible database JDBC driver. Do not take my word for it. Let me show you how easy it is to download and setup a Database connection using DBVisualizer.
- Click this link to go toDBVis Software download page.
- Download the executable that is compatible with your Operating System. Make sure to pick the one with the with Java VM to avoid incompatibilities or installation issues.
- Once the file has downloaded, go ahead and run the executable.
- Follow installation settings. During the installation steps, you will see a prompt to use the Connection Wizard. For now, click cancel. We will cover the connection wizard in the following steps on connecting to a database.
- DBVisualizer comes with a nifty DB Driver Finder tool. Go ahead and click start and let it search your system for valid JDBC drivers. When finished, click Close.
- That’s it your now installed and ready to use DBVisualizer.
Connection to a Database
Before we discuss connecting to a Database, we first need a database. So for the following steps, we will be using a test SQLite database. This database is a simple database containing three tables: Person, Address, and Phone. You can download this database from this link. Also, connecting to this database will not require a username or password.link for additional drivers.
Your new connection will now appear in the database tab Connection Window. To connect to your new database right-click on the connection and click connect. If your connection is successful, you will see a green check by your database. Otherwise, if you are unable to connect or the database was unavailable you will receive a red x. Typically when this happens, there will be a message somewhere on the screen telling you why the connection was unsuccessful. In most cases this happens because the connection setting was incorrect, so make sure to double check your configuration.
We have found these sources to be ideal for learning more about SQL and DBVisualizer: