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

pagdenl
Giga Expert

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.  

10 REPLIES 10

pagdenl
Giga Expert

Importing two years of data will take an extreme amount of time  to do that.  There has to be a better way.

pagdenl
Giga Expert

The exporting is fine it is the importing to the other instance that is causing the issue.

Hi,

 

Importing will take more time depending upon the size. That is why we recommend that import data in background and using transform maps for integrations.

Thanks,

Ashutosh

HI,

The limit is defined as well:

find_real_file.png

 

 

Thanks,
Ashutosh

pagdenl
Giga Expert

The sc_req_item table is linked with other records.  We have to make sure the sys_id's match in PROD and our TEMP instance.  The transform map allowed us to pick sys_id on the import, but the export is not showing sys_id.  Therefore you can't link them