Table of Contents

Search

  1. Preface
  2. Introduction to Test Data Management
  3. Test Data Manager
  4. Projects
  5. Policies
  6. Data Discovery
  7. Data Subset
  8. Data Masking
  9. Data Masking Techniques and Parameters
  10. Data Generation
  11. Data Generation Techniques and Parameters
  12. Working with Test Data Warehouse
  13. Plans and Workflows
  14. Monitor
  15. Reports
  16. ilmcmd
  17. tdwcmd
  18. tdwquery
  19. Data Type Reference
  20. Data Type Reference for Test Data Warehouse
  21. Glossary

Restoring Deleted Data After a Failed Reset

Restoring Deleted Data After a Failed Reset

If you need to restore data that was deleted during a failed reset operation, you can restore the data from the backup created during the reset. Run a separate plan to restore the data from the backup. Ensure that you have the backup prefix used during the failed reset operation.
Perform the following high-level steps to restore data from the backup schema:
  1. Create a group that contains all the tables that were backed up during the reset operation.
    The backed up tables include all transactional tables.
  2. Open a project and create a plan.
  3. Add the group as a subset component to the plan.
  4. Add the connection that contains the backup schema as the source connection.
  5. Add the database where you want to restore the data as the target connection.
  6. In the target settings in the plan, disable the constraints and indexes.
    Select the following values for the
    Update Strategy
    properties:
    • Treat Source Row As
      : Update.
    • Update As
      : Update else Insert.
  7. In the
    Advanced Settings
    , enter the backup prefix in the
    Reset Recovery Prefix
    field.
  8. Run the plan.