It would be helpful if there was a way to export the Mart database using the application into a format that could be imported into another database. This would allow more control by the application team and less involvement of the database teams. The backup formats are not under the control of the application, and vary based on dba choices.
App driven saves have become a common means of doing backups with various applications, where the format is easy to restore as the app has created it. The DBMS backup then becomes an additional layer of recovery and is used only in emergency situations.
The web portal provides an import/export function that is another example.
Please sign in to leave a comment.