What is the best way to import large files of data from another instance. The file size is 1.4 GB.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-05-2020 09:13 AM
Importing two years of data will take an extreme amount of time to do that. There has to be a better way.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-05-2020 09:35 AM
The exporting is fine it is the importing to the other instance that is causing the issue.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-05-2020 09:40 AM
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-05-2020 09:41 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-05-2020 10:14 AM
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