It would be very useful and time-saving if we were able to merge/combine two Perpare instances in the Portal.
We are in the process of re-structuring Prepare instances for a client, and two of their subidiary companies’ data need to be put in the same database, which means two instances need to be combined into one. Both have the same data area names, which have the same schema names. For now we're unfortunately stuck with cloning one instance and integrating the other by completely rebuilding it. This will take a lot of time in an already time-consuming rework of the client's data estate.
For this idea, the most basic version would allow us to merge instances with matching area's and schema's, where the objects within them could (hopefully) simply be put together.
Maybe a more advanced workflow could even be possible, allowing us to map and rename the areas and schemas while performing the merge, like this:
| Object | Source Instance | Source Area | Source Schema | Target Area | Target Schema |
|---|---|---|---|---|---|
| 1 | Prepare A | Staging | st | DSA | dsa |
| 2 | Prepare B | Staging | st | DSA | dsa |
| 3 | Prepare A | Report | rp | MDW | mdw |
| 4 | Prepare B | Report | rp | MDW | mdw |
