Best strategy to wipe clean production database on PaaS
Question

Hi there, we are planning to do performance test on production PaaS environment and obviously would like to clean up the data after the testing is done. As we understand the truncate option is no longer available on PaaS, is there a recommended approach to make the database clean again apart from issuing delete from table X? One disadvantage of delete from is it will leave the auto increment values as it is and won't restart.

Hi, any advice?

Is there a specific reason why the primary keys are so important to preserve? 

Without knowing your reason why, then I can suggest the following

  1. DBA Route. There are quite a few options available to you at DBA level such as taking backups/restoring etc or even crudely using checkindent (t-sql) to reseed the col. identity value. But these should only be undertaken by people that know what they are doing at database level.
  2. Low-code Route. Create a standalone app (with its own entities) that you use specifically for performance testing. That way you can continue to use it for testing in production without polluting an entity with test data.

=

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.