dSql can manage and query multiple databases in the same time, transfer the data between databases, deliver result files, automate tasks and easy monitor disk usage or replication status over database clusters.
Download dSql dSql Documentation
Connect and execute queries on multiple databases simultaneously.
Databases can be from different type (PostgreSql, MySql, SqlServer, Redshift, etc. ).
You may use this when you have the same table distributed over multiple databases.
For monitoring reasons (like disk usage, CPU load) you may also connect and execute one query over multiple databases.
Read More
dSql can transfer data between different databases. You can transfer data from table to table, from
a query to table or from multiple databases to one database. The transfer is fast thanks to using multiple threads.
Read More
SQL scripts may be sometime not enough. You may want to place more logic in your script.
Therefore you can create more complex scripts that combine the power of SQL and Python or Groovy language.
Scripts can be copied directly in the command line or saved to a file and then executed.
Read More
dSql supports Python or Groovy Scripts. This scripts can accept parameters.
You can register any of the scripts as dSql native commands.
Like this you can have database specific command line commands for 'disk usage', 'replication status', 'traffic overview', etc.
Read More
dSql can execute Groovy or Python scripts which can query or modify the data in the database.
This scripts can be executed regularly on a scheduled base, similar with cronscript.
The scripts can upload result files to ftp servers or send them via email.
If the script fails an email will be sent to the DbAdmins, informing about the error.
Read More
Database administrators runs periodically reports which delivers data to end-users, like sales people, managers, developers.
This scripts can be set to run on a schedule.
It may happen that one of the scripts crashes, as for example the database is down or a table is missing.
In this case dSql can be instructed to send an email to database administrators and inform about the script crash.
Read More
dSql can execute queries on one or multiple databases. It can also execute Python or Groovy scripts which
saves result data to file. The files can be delivered to end-users via ftp or as email attachment.
Read More
You can write Python or Groovy scripts which does monitor different database aspects, like disk usage,
locking, CPU usage, number of connections, etc.
This scripts can be register as native dSql commands.
Then you can connect to multiple databases (connect to a group) and let this scrips run on all databases.
This will reduce the administrative effort to manage a cluster of databases.
Read More
Postgres users are used to save passwords in a dedicated .pgpass file.
dSql can make use of the .pgpass convention and read the passwords from the .pgpass file.
Read More
Database admin usually creates a standby database replica for each production database.
We had clients managing over 40+ production databases, each with a standby replica.
dSql allows to easy add suffixes to database connections, and for example
prod1 to have a prod1.sby connection where the host naming is changed using a given rule.
Read More
64 bits installer with build-in openJDK 12. No requirements.
Alternative ZIP Package (not for SqlServer databases).
64 bits installer with build-in openJDK 12. No requirements.
Ubuntu users can download the installer and execute chmod +x dsql.sh and ./dsql.sh in terminal.
Installer for all Linux/Unix systems with Java Installer for all Linux/Unix systems WITHOUT Java
Debian Package WITHOUT Java
RPM Package with Java
GZIP Package WITHOUT Java.
64 bits installer with build-in openJDK 12. No requirements.
For advanced users we provide a
Zip Package with Java.
Windows
Linux
Mac