Data Migration from One schema to Another Schema using TOAD-
Hi Guys, today I'll explain how to migrate data from one schema to another schema using toad.
I have three table T_HFM_ENTITY_CONTACTS/T_MAIN_ISSUE_CATEGORY_CONTACTS/
T_SUB_ISSUE_CATEGORY_CONTACTS and corresponding data in RGL14 schema I have crated same table in RGL6 schema and moving same data in RGL6 schema.
below are the steps-
Step1- Open RGL14 Schema go to Tables tab, select table -->right click-->Copy data to another schema
Step2- select Destination Connection and Destination Schema -->choose Commit After Each table
Step3- click on green play symbol to run.
Step4- now data has been moved, can see the success message.
Now your data has been moved to another schema, open schema and see the data.
Cheers Guys :)
2 comments:
Data migration technique which you have shared within this post and also with the practical snapshots, could be very much helpful to know deeper. Thank you very much. Web designing company in Coimbatore | Coimbatore website designing company
Thank You very much Vcom.
Post a Comment