Episode #125 of the Stack Overflow podcast is here. We talk Tilde Club and mechanical keyboards. Listen now

New answers tagged

0

The way I would do it is to use the tool that I wrote to do things like that: execsql.py, available from PyPI. With a tool like that, designed to run scripts from the command line, you can automate the process with a shell script or batch file, and launch it with the task scheduler.


0

Redgate unit testing tool is pretty good, More information can be found here It has a bunch of pre-defined tests and also templates to create your own.


0

You can try one of the DBMS independent JDBC based tools. As they are based on Java they run on any platform that supports Java including Linux. And to my knowledge all of them support exporting data to Excel file. All of them are free, DBeaver and DbVisualizer have a commercial version as well. DBeaver (Free and commercial version) DbVisualizer (Free ...


0

If you're open to using a scripting client instead of a GUI client, then you might look into execsql.py. It allows you to connect to multiple databases (one on startup, others with the CONNECT metacommand). You can then copy a table or view from one database to another with the COPY metacommand and write queries to combine the data as needed. Disclaimer: ...


Top 50 recent answers are included