Need to move 4 lakh + records in a table from one instance to another

Maradani Revat1
Tera Contributor

4 weeks ago

Hi,

 

We have requirement to move all the attachments and attachment content records from one instance to another instance as a part of transformation. The count of the records is very huge, and we are automating to migrate via integration. The only challenge is as they are very huge records, and it affects the performance as well. So wanted to know the best solution or suggestions in moving huge data at a time.

 

0 Helpfuls
  • 179 Views
1 REPLY 1

Dr Atul G- LNG
Tera Patron
Tera Patron

4 weeks ago

Hi @Maradani Revat1 Yes, it can impact performance. Attachments are always a triple size. What I would suggest is migrating the record in bits and pieces, rather than all at once. You could also set a limit for migration and schedule it for off-hours to avoid any issues.

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************
0 Helpfuls