dSql can manage and query multiple databases at the same time, transfer the data between databases, deliver result files, automate tasks, and easily 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 types (PostgreSQL, MySql, SqlServer, Redshift, etc. ).
You may use this when you have the same table distributed over multiple databases.
For monitoring reasons (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 a table, or from multiple databases to one database. The transfer is fast thanks to using multiple threads.
Read More
SQL scripts maybe sometimes 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. These 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 that can query or modify the data in the database.
These scripts can be executed regularly on a scheduled base, similar to cronscript.
The scripts can upload result files to FTP servers or send them via email.
If the script will fail an email will be sent to the DbAdmins, informing about the error.
Read More
Database administrators run periodically reports which deliver data to end-users, like salespeople, managers, developers.
These scripts can be set to run on a schedule.
It may happen that one of the scripts crashes, 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 that
save result data to file. The files can be delivered to end-users via FTP or as an email attachment.
Read More
You can write Python or Groovy scripts which do monitor different database aspects, like disk usage,
locking, CPU usage, number of connections, etc.
These scripts can be registered as native dSql commands.
Then you can connect to multiple databases (connect to a group) and let these scrips run on all databases.
This will reduce the administrative effort to manage a cluster of databases.
Read More
Postgres users are used to saving 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 us to easily 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-bit installer with build-in OpenJDK 12. No requirements.
Alternative ZIP Package (not for SqlServer databases).
64-bit 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-bit installer with build-in OpenJDK 12. No requirements.
For advanced users we provide a
Zip Package with Java.
Windows
Linux
Mac