12

I need to create a SQL server database backup in DBeaver and restore it. Is that possible?

Using SQL Management Studio would not be a turnaround solution in this case, as we are not allowed to use it here.

Pedro Coelho
  • 1,411
  • 3
  • 18
  • 31
  • 1
    Seems very odd to not be able to use SSMS, which is the tool designed by Microsoft to access their own Database Engine. But yes, it's possible, the SQL you run doesn't change depending on the interface you're using. the `BACKUP` statement would be identical to one one you would run in SSMS, `sqlcmd`,VS Code, SQL Azure Studio, etc, etc, etc. – Thom A Apr 05 '19 at 15:02
  • 1
    [BACKUP (Transact-SQL) - SQL Server](https://learn.microsoft.com/en-us/sql/t-sql/statements/backup-transact-sql?view=sql-server-2017#sql-server) – Thom A Apr 05 '19 at 15:03
  • 3
    You aren't allowed to use SSMS? I'd be putting out a resume. – Jacob H Apr 05 '19 at 15:14

1 Answers1

6

According to DBeaver documentation:

DBeaver supports native database backup/restore functions for following databases:

PostgreSQL
MySQL

So it looks like currently DBeaver (as of version 7.3) does not support this featire for SQL Server.

DBeaver Backup/Resore documentation

manuna
  • 729
  • 14
  • 37