A plugin that allows creating backups and restoring them from the DataGrip context for Microsoft SQLServer databases.
The plugin built for my own personal use case which means that it will work for databases that are connected through an SSH tunnel.
It supports downloading backups from the remote server to the local machine without using xp_cmdshell command.
Features:
- Creating a backup and storing it on the server
- Creating a backup, storing it and download it right after
- Reading a backup into an existing database
- Reading a backup into a newly created database
Built for 2020.1 and higher because the internal database api has changed in that version.
0.6.1
- Fix compatibility with v201.7223.18.
- When the user can't list drives (EXEC master..xp_fixeddrives) a message is shown instead of a local file browser.
0.6
- Progress indication when downloading backup
- Allow closing connections when restoring
0.5.1
- Fix NPE when opening a file dialog
0.5
- Show error when restore action fails
- Progress for backup up and restoring is shown again
- Store the last selected path and (try to) use it when backing up and restoring later
- Fill in the backup filename when backing up and downloading
0.4
- The filepicker asked for overwriting the file when a file was being selected for restoring. That doesn't happen anymore.
0.3
- The filepicker for the backup action didn't always select the file, it sometimes picked the folder
- When overwriting an existing file in the backup action it didn't prompt to overwrite the file
- When a backup action fails a message is shown
- An internal API was used, it isn't anymore
0.2
- Downloading using jtds or ms driver
- No infinite wait anymore when reading data
- Refresh database after restore action
- Sometimes the context menu items stayed disabled
0.1
- Initial version. Seems to work fine locally :).