use jdbc:monetdb://localhost:50000/db for a MonetDB server instance running on localhost port 50000 serving database db.Įnter the username and password for the databaseĬlick on "OK" to confirm the connection, and you are good to go.
#Dbvisualizer manual driver
Selected the MonetDB driver from the "Driver" drop-down menu.Įnter the details of the desired database connection by replacing the hostname, port and database name in the sample URL, e.g. Right-click the database that you wish to backup, point to Tasks, and then select Back Up. Expand Databases, and either select a user database or expand System Databases and select a system database. Next, to connect to a MonetDB database instance, open the "File->Connect" window. After connecting to the appropriate instance of the Microsoft SQL Server Database Engine, in Object Explorer, expand the server tree. Type in a sample URL for the database connection, e.g. The class name nl. should be automatically filled in. "MonetDB".Ĭlick on the folder-like icon and navigate to the previously downloaded JDBC. Cancel this wizard and open the driver manager using the menu "File->Manage Drivers".Īdd a new Driver by clicking on the button in the top-left corner of the dialogue and typing in a name for the driver, e.g. Table data is easily managed using a powerful spreadsheet like editing feature. Database objects are simple to create using powerful actions in DbVisualizer requiring no manual SQL to be written. Free, personal use versions are available from their website. It's a very cool tool (can even draw dependency graphs based on the schema and foreign keys). While SQL Workbench has some support for MonetDB, one still needs to download MonetDB's JDBC driver and configure it.Īfter SQL Workbench has been started for the first time, it will load its default welcome screen and starts the wizard to select database driver. One of DbVisualizer’s strengths is visualizing the structure in the database, its database objects and most importantly, table data. DbVisualizer is a platform independent tool aimed to simplify database development and management for database administrators and developers. One can download it from the official website. SQL Workbench/J is a tool for working with SQL databases that supports Java clients.