search

dragnilar / Databvase

A (sorta) lightweight query tool for MS Sql Server that makes usage of DevExpress to provide a rich user interface
3 stars 1 forks source link

Add Ability To Create Database Backups Via GUI and/or Wizard #24

Open dragnilar opened 6 years ago

dragnilar commented 6 years ago

SMO provides the ability to create database backups, so it shouldn't be (too difficult) to possibly add the ability to create a backup wizard/gui in Databvase.

dragnilar commented 6 years ago

99776eaa - Added start on this, however the window to customize the backup options needs to be added. Right now it just defaults to C:\Temp\Test.bak, which is obviously just a test...

dragnilar commented 6 years ago

823a783 - With this and the previous 4-6 commits, backups are now able to be performed via a backup wizard similar to the one in SSMS. This includes a server file explorer that uses a DX tree list view.

The server file explorer is mostly using MVVM, but it should probably be refactored a little more so that it's similar to the object explorer. Also its directly calling file paths from the database; this needs to be moved to another layer.

This still has some features that need to be implemented and also its mostly using code behind to ensure that its doable. It will need to be refactored using the MVVM pattern and also the unimplemented features will need to be fleshed out.

dragnilar commented 6 years ago

f45008e - Refactored the backup wizard/window so its using the MVVM pattern. Still need to implement the unimplemented features.

Encryption will not be implemented this go-around. A separate enhancement item will be added for it since its currently not certain as to what level of complexity encryption adds to the backup procedure.

Backup sets currently are not displayed, the wizard uses a simplified approach that just lets you select a file path and database backup name.