content format

DtSQL allows you to manage and query multiple distinct database connections simultaneously through a single, unified client interface. Because DtSQL handles database engine connections via standardized JDBC/ODBC drivers, running queries across multiple separate databases requires managing active connections side-by-side or leveraging the underlying SQL engine’s cross-database capabilities. How to Connect Multiple Databases in DtSQL

DtSQL allows you to maintain an organized tree view of various server connections in its object browser.

Open Connection Manager: Click the connection icon or go to Tools -> Connection Manager in the top menu.

Add First Database: Select your database type (e.g., MySQL, PostgreSQL, or Oracle). Input the hostname, port, database name, and login credentials. Save the profile.

Add Subsequent Databases: Repeat the process to create separate profiles for your remaining databases.

Establish Active Connections: Double-click each database profile in the Object Browser sidebar. Active databases will light up, allowing you to browse their schemas, tables, and columns concurrently. Methods for Querying Multiple Databases

Depending on whether your target databases reside on the same database instance or completely different servers, choose one of the following strategies:

Method 1: Cross-Database Queries on the Same Server instance

If your databases reside on the exact same server instance, you can query tables from multiple databases inside a single DtSQL editor tab using fully qualified three-part naming. Syntax Pattern: DatabaseName.SchemaName.TableName Example Query:

SELECT c.customer_id, o.order_date FROM SalesDatabase.dbo.Customers c INNER JOIN InventoryDatabase.dbo.Orders o ON c.customer_id = o.customer_id; Use code with caution.

Method 2: Combining Data from Different Servers (Using UNION)

If you need to aggregate identical table structures from completely separate servers, open a query tab on each connection, then combine the final datasets with a UNION or UNION ALL statement. Example Query:

– Run this pattern if you pull matching reporting fields across instances SELECT ‘US_Branch’ AS Region, employee_id, revenue FROM US_Database.dbo.Sales UNION ALL SELECT ‘EU_Branch’ AS Region, employee_id, revenue FROM EU_Database.dbo.Sales; Use code with caution. Method 3: Linked Servers or Foreign Data Wrappers

DtSQL passes your code directly to the host database engine. If you must join tables sitting on physically different servers, you can configure a bridge on your primary database engine: SQL query on multiple databases – Stack Overflow