How to restore data of a table?

General
1

Can Pega support to retrieve data from a specific table without affecting the current production environment?

Details

  • Source: Production

  • Table size: approximately 100GB

  • Production database size: approximately 1TB

  • Staging database capacity: approximately 200GB

Requirement
We do not want to restore the full production database to the current PROD environment.

Important

  • Current PROD data must not be impacted

  • Overwrite of the target table in STG is acceptable

  • Temporary downtime on STG during import is acceptable

Are there any recommended approach?

2

Is this on Pega Cloud? If yes, create a SR/CC ticket to get the recommendations from Pega Cloud team on the feasibility. Generally, Pega Cloud recommends to take a full database backup instead of specific tables for backups. I would recommend to check with Pega Cloud team through SR/CC ticket.

3

hi @LocD17570889 ,

Based on the question you want to export the table schema as well as its rows from one DB to database is possible.

You can below things.

  1. Create a new temp database in production and copy the 100 gb table into the temp db.
  2. export the temp db and put it in SIT.
  3. after moving to SIT you can use insert into or select into statements to copy entire records from temp db to sit db

this works in majority of the databases i have done this same couple of times in MSSQL.

happy to help further if needed