Benefits of using BroadSQL
3 Reasons why using BroadSQL instead of a graphical SQL client will save your day
Graphical SQL tools are outstanding for designing databases or for executing a few queries here and there. But when it comes to working daily with data that involve multiple servers from different vendors nothing beats the speed of a command line client.
- Want to execute the same query on the integration, validation and production servers ?
BroadSQL knows about your environments : test & integration, quality acceptance, or production platform. You can switch from one environment to the other. Then , simply use the command / to execute the last query.
- Want to automate the extraction and data loading of big chunk of data?
Simply use the command DUMP to extract a whole table into an XLSX file. You can also use the command EXPORT to extract any SQL results to one of the following formats: MS Access, Excel or Text file.
The command FAST UPLOAD let you import data from a text file to a table.
- Want to automate data management through scripts?
Like vendors' command line clients, BroadSQL can execute a list of commands in a script file. But thanks to its versatility, BroadSQL is able to connect to different database types in the same script.
BroadSQL makes you perform these tasks quickly.
And if you want to re-use your business Java classes in BroadSL, you can write your own commands and use them in the client or in scripts.
BroadSQL is designed with the following goals:
- to automate data management tasks, especially the repetitive ones
- to reduce the time spent in switching from one environment to the other
- to facilitate export and import of data
BroadSQL stores all your connection details into an encrypted configuration file. You only need to remember a single password.
You can extend BroadSQL by writing custom commands that implements your business logic or by integrating BroadSQL in third party programs.
- Use a single client for your various database types : Oracle, MySQL, PostgreSQL, H2, HSQL, Derby/JavaDB, and other JDBC compliant databases
- Store your connection settings in a secure AES-256 encrypted vault file
- Export query results to native Microsoft Excel or Microsoft Access file format
- Extend BroadSQL by writing your own commands or by integrating BroadSQL in your Java programs
- Automate cross-platforms activities through scripts that mix SQL and BroadSQL commands
- More features and benefits