The other fields depend on the databases you want to work with. DB_ONE_TABLE as the Local Table Name and TEST_LINK as the Remote Table Name. Enter all information for the table in the DB_ONE database, e.g.Select it and choose Create Linked Table from the right-click menu. Connect to the H2 database and navigate to the Linked Tables node.~/mydb to create it in your home folder). select H2 Embedded as the driver and enter a file name for the database (e.g. Create an H2 Embedded connection using the Connection Wizard, i.e.For instance if both DB_ONE and DB_TWO are MySQL databases, add the MySQL driver JAR file. Add the JAR files for the database(s) you want to work with to the Driver jar Files list.Open Tools->Driver Manager and select the H2 Embedded driver.Here's an example involving two databases, here called DB_ONE and DB_TWO, each with a table like this: CREATE TABLE test_link (įollow these steps to set up an H2 database with the Linked Tables: So to combine columns from a table in one database with columns from a table in another database, you create Linked Tables for each table in the H2 database and then run a SELECT statement joining the Linked Tables. A Linked Table is a table in another database of any kind that you can connect to through JDBC. H2 supports something called Linked Table. See the documentation for your database for details.ģ) The last alternative is to use an H2 database as an intermediary query engine. Once Presto or Trino is up and running, DbVisualizer 13 supports these to run the queries.Ģ) Some databases, offer concepts like "database links" to allow cross database queries which can then be run in DbVisualizer. ![]() Check the respective product documentation how to setup these. Continue reading for the options.ġ) There are dedicated query engines like Presto and Trino that are specifically designed to support cross database queries. DbVisualizer does not in itself support cross database queries.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |