I have 10 database which holds 15 tables,
One table has application Name and will be linked across 15 tables through Foreign Key or with application name itself.
There are multiple applications present in one database.
Now I want copy only few application's along with all it's relevant data from each of the database and like to club it all together in one database.
How to do it?