I need to propagate around 100 Procedures with all their dependent Objects from a source database to the destination database.
Dependency levels may be recursive in nature also. I would also want dependent tables data to get propagated.
Export Import may not be feasible since I do not want unwanted objects from the source database . Also, the source database is around 150GB in size. Can anyone suggest some solution/tool which may help.
you've got to do this in several exports and imports, I just did this a couple of weeks ago moving a production database to integration, you first need to find out what data in what tables you need and you must work out that dependency