This should be easy - just never have done before. Let's say our Source DB/Schema is called "NPR". Our target DB/Schema which already exists is called "UAT19".
We need to copy/subset new data from NPR into UAT19. More than likely due to new releases, the schema has changed in NPR, so we want to get them in UAT19. Since we're going to be deleting all the data in UAT19 first, the easiest solution I think would be to drop all the tables in UAT19, and create them all again based on all characteristics of NPR.
What would be the best process/steps to do?
Release : 4.9.1
Component : Subset
It is subset: