search

Daeer-Projects / DatabaseOperations

A library of operations that can be applied to an MS SQL Server database.
MIT License
5 stars 2 forks source link

Restore Operator #53

Open Daeer-Projects opened 3 years ago

Daeer-Projects commented 3 years ago

Is your feature request related to a problem? Please describe. For the next milestone I want to add the feature where the consumer of the library can use a new Operator to restore a database from a backup file.

Things to consider:

  1. The SQL script.
  2. Backup file location.
  3. Connection to an existing database.
  4. Restore as a brand new database with new name and different data/log locations -> maybe for a future milestone.

Describe the solution you'd like For the consuming application to create an instance of the RestoreOperator and call its restore method using a connection string and backup file name and location.

Describe alternatives you've considered The other alternative is for the user of the consuming application to use a tool like MSSQL Server Management studio to do the restore for them (manually).

Additional context Some investigative work is required first to find all of the pitfalls and "how" to do the restore.

aalgrou commented 4 months ago

Are you currently working on this, or would it be okay if I contribute to it?

Daeer-Projects commented 4 months ago

If you have the time to do it, by all means - go for it.