I HAVE TWO SET OF TABLES
String BKP_TableList[] = {"BKP_PLAYER_BOTS", "BKP_PLAYER_LOG", "BKP_PLAYER_LOGIC"
", "BKP_PLAYER_LOGIC_CALL", "BKP_PLAYER_MC_EVENTS", "BKP_PLAYER_MC_LINKS"
", "BKP_PLAYER_MC_NEWS" , "BKP_PLAYER_MUSIC", "BKP_PLAYER_NOTIFY_QUEUE"
", "BKP_PLAYER_OBJECTS" , "BKP_PLAYER_RECORDS_TO_PROCESS", "BKP_PLAYER_RECORD_OF_LOGIC_EV"
", "BKP_PLAYER_SEARCH" , "BKP_PLAYER_SOUND", "BKP_PLAYER_UMS_QUEUE"
", "BKP_PLAYER_VIDEO" , "BKP_PLAYER_WEBSITE"};
String MJST_TableList[] = {"MJST_PLAYER_BOTS", "MJST_PLAYER_LOG", "MJST_PLAYER_LOGIC"
", "MJST_PLAYER_LOGIC_CALL", "MJST_PLAYER_MC_EVENTS", "MJST_PLAYER_MC_LINKS"
", "MJST_PLAYER_MC_NEWS" , "MJST_PLAYER_MUSIC", "MJST_PLAYER_NOTIFY_QUEUE"
", "MJST_PLAYER_OBJECTS" , "MJST_PLAYER_RECORDS_TO_PROCESS", "MJST_PLAYER_RECORD_OF_LOGIC_EV"
", "MJST_PLAYER_SEARCH" , "MJST_PLAYER_SOUND", "MJST_PLAYER_UMS_QUEUE"
", "MJST_PLAYER_VIDEO" , "MJST_PLAYER_WEBSITE"};
I would like to copy from BKP_PLAYER_BOTS to MJST_PLAYER_BOTS, BKP_PLAYER_LOG to MJST_PLAYER_LOG and so on and so forth.
There is only one additonal column in the BKP_PLAYER_* i.e PLAYER_LEVEL, rest the structure is similar in both
the tables.
Is StoredProcedure suggested here for peformance reason since this involves copying of mass data from one set of
tables to another