What is the best way to import large files of data from another instance. The file size is 1.4 GB.

pagdenl
Giga Expert

‎05-05-2020 08:55 AM

What is the best way to import large files of data from another instance. The file size is 1.4 GB.  Currently when we download the file to the instance it is erroring out for the size.  

0 Helpfuls
  • 2,475 Views
10 REPLIES 10

Ashutosh Munot1
Kilo Patron
Kilo Patron

‎05-05-2020 09:00 AM

HI,


Are you importing using which protocol?

Thanks,

Ashutosh

0 Helpfuls

pagdenl
Giga Expert
In response to Ashutosh Munot1

‎05-05-2020 09:10 AM

We are exporting from PROD using xml files

0 Helpfuls

Ashutosh Munot1
Kilo Patron
Kilo Patron
In response to pagdenl

‎05-05-2020 09:29 AM

Hi,

find_real_file.png

This is the limit. Dont change this. Instead use Pagination meaning export in chunk.


THanks,
Ashutosh

 

 

Preview file
11 KB
0 Helpfuls

Ct111
Giga Sage

‎05-05-2020 09:06 AM

I would suggest break data into chunks of let's say there is a file with 1000k records

then break it into 10 chunks of 100k ....

 

in the similar fashion just see if you can load some small sample data first , because it will take time anyhow.

0 Helpfuls