How can we help you today?
Open/Save Scripts on Remote Filesystems
Roger Bjärevall
Scott,
Currently mounting file systems is required for DbVisualizer as you have already discovered.
I will open a new ticket for supporting sftp and other file system protocols.
Regards
Roger
Scott Saccone
Thanks!
Hello Roger,
I also would like to open SQL scripts in DBvis from a remote filesystem using sFTP.
Should I follow this guide and install their jdbc/sftp driver, or DBvis provides own solution?
thanks
Hi Dmitry,
Unfortunately, DbVisualizer does not currently have built-in support for accessing files over SFTP. I have registered your vote in favor of such a feature.
As for the CData driver, while it may allow you to access files over SFTP, they would most likely be presented in a manner similar to SQL tables rather than being opened in the SQL Commander. As such, to actually run any SQL scripts hosted on the SFTP server, you would most likely have to pull up the file contents and copy-paste it into an empty SQL Commander to run from there.
If you want easy access to run SFTP-hosted SQL scripts, some third-party tool to mount it as a proper file system on your machine may be the most convenient option.
(Disclaimer: DbVisualizer is not affiliated with CData, and only provides basic support for their drivers. Information provided here is inferred from the CData website and may be wrong.)
Cheers
- Tomas
Scott Saccone
If the remote files were in git repository, then accessing the files locally via a git client is another workaround in addition to SFTP. Although, I'd be wary of checking things out on both Windows and Linux.
Given competing products like VS Code + database plugins, it would probably be good idea to add features that allow working with remote scripts (running, editing, saving). I often use local Windows scripts that are outside my Linux git repositories, which is not ideal.
Having native [builtin or plugged-in] git client would be another very useful asset of Dbvis.
Scott Saccone
In dbVis I can run scripts using remote database servers, but I can't open them from or save them to remote filesystems (or can I?). My workstation is Windows but my development environment is Linux. I used to run the Linux version of dbVis using an X Window server for Windows, which was great. But I'm beginning to use development tools, like Visual Studio Code and dbVis, directly on Windows. VS Code can connect via SSH so no X server is required. For dbVis, I could mount Linux on Windows (samba, SSHFS, etc), but having builtin support for remote filesystems (via SSH, SFTP, etc) would be great.