Minimum data set for Hybris

[former_member1026091]

Hello,

we want to create a minimum data set for our test environment out of an already populated DB, it can be either from a production environment or another test environment.

We need something that has just few products, customers, etc.. so we can restore a test environment from fresh data.

What's the best way to accomplish this?

The DB is on RDS MySQL on AWS.

Thanks

[AlexGourdet]

Thank you for visiting SAP Community to get answers to your questions.

As you're looking to get most out of your community membership, please consider include a profile picture to increase user engagement & additional resources to your reference that can really benefit you:

• Profile https://developers.sap.com/tutorials/community-profile.html
• Tips for Questions: https://community.sap.com/resources/questions-and-answers
• Consider to take our Q&A tutorial at: https://developers.sap.com/tutorials/community-qa.html.

I hope you find this advice useful, and we're happy to have you as part of SAP Community!

All the best,

Alex

[adiputera]

You can use impex export. You can combine it with flexible search to fetch only some data

for example:

INSERT_UPDATE Product;code[unique=true];
"#% impex.exportItemsFlexibleSearch(""select {pk} from {product} where {coode} is not null"");"

After then you can re-import it in other environment