1. Make a backup from Prod,
2. Move it to Test,
3. Shrink the data set in there by deleting items, etc. then make another backup and bring that to Dev
4. Finally use the backup from Prod to feed Test again?!
Thanks a lot for the Idea Stefan.
I have a question on point 3. How to delete all the items/articles? Do you mean with a deletion script directly in the database?
Please elaborate is there any documentation or knowledge base to know the database and the tables can be safely truncated to delete the items/articles and reduce the size of the server instance.
1 of 1 people found this helpful
well to be candid I admit that this is more a quick and dirty idea based on what you were trying to achieve rather than a defined process :-)
For data deletion in step 3 I see two options:
1. Delete by using the GUI
2. Delete by using the Service API
Wouldn't recommend deleting directly on DB level since this will bypass all business logic and may lead to inconsistency.
Thanks a lot Stefan for the suggestion. though as we want to have a repeatable solution, we are now trying export import in PIM. The idea would be create a empty PIM database with setup.cmd and then import the metadata through PIM client. To have the metadata we can schedule weekly/monthly export from Prod.