on 2023 Jan 19 8:21 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
12 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.