Multiple Table to Multiple Destination
Hi, I have few question about my requirement please share your valuable comments Requirement Details: I am having Database Like(PRLNT3) in database having 20 tables(user,function,secuirty..etc),we need to select multiple tables and We wanted to transfer different databases(PRNLNT8T1,PRNLNT8T2,PRNLNT8T3 ...ect) same structure every time i wanted to check the existing transfered data.If existing data is there no need to transfer. please share some better structure we really appreciate this help ThanksRanganathan.Palanisamy
October 14th, 2012 4:17pm

You can loop through the user tables in your source database by querying the information schema and create a list of tables. Use a for each container to loop throuhg this list. For each table name build a a dynamic query to query the destination database and check if data exists for that table effectively building a list of tables to be transferred to the destination table. The write your own sql transfer object script which take this dynamic list of table and transfer them to the destination database. Check this as reference for writing your transfer sql object script. http://btsbee.wordpress.com/
Free Windows Admin Tool Kit Click here and download it now
October 14th, 2012 9:14pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics