HI Vijay, Similar ask has been posted in the past: https://salesforce.stackexchange.com/questions/273/copy-production-data-to-developer-sandbox
Try SFDX CLI to download and upsert: "sfdx force:data:soql:query -q "SELECT Name FROM Blog__c" -r csv -u prod > data.csv sfdx force:data:bulk:upsert -s Blog__c -f data.csv -i Name -u sandbox
The object must have field with unique values for all rows. Ideally with a unique constraint or marked as an external id, but not required. It also supports lookup fields as long as the lookup object has an external id field.
When selecting the data use SELECT Parent.My_External_Id__c, ... FROM ..."
There are other solutions in the post that might want to try.
Hope this helps you. Please mark this answer as best so that others facing the same issue will find this information useful. Thank you
HI Vijay, Similar ask has been posted in the past: https://salesforce.stackexchange.com/questions/273/copy-production-data-to-developer-sandbox
Try SFDX CLI to download and upsert: "sfdx force:data:soql:query -q "SELECT Name FROM Blog__c" -r csv -u prod > data.csv sfdx force:data:bulk:upsert -s Blog__c -f data.csv -i Name -u sandbox
The object must have field with unique values for all rows. Ideally with a unique constraint or marked as an external id, but not required. It also supports lookup fields as long as the lookup object has an external id field.
When selecting the data use SELECT Parent.My_External_Id__c, ... FROM ..."
There are other solutions in the post that might want to try.
Hope this helps you. Please mark this answer as best so that others facing the same issue will find this information useful. Thank you
Similar ask has been posted in the past: https://salesforce.stackexchange.com/questions/273/copy-production-data-to-developer-sandbox
Try SFDX CLI to download and upsert:
"sfdx force:data:soql:query -q "SELECT Name FROM Blog__c" -r csv -u prod > data.csv sfdx force:data:bulk:upsert -s Blog__c -f data.csv -i Name -u sandbox
The object must have field with unique values for all rows. Ideally with a unique constraint or marked as an external id, but not required.
It also supports lookup fields as long as the lookup object has an external id field.
When selecting the data use SELECT Parent.My_External_Id__c, ... FROM ..."
There are other solutions in the post that might want to try.
Hope this helps you. Please mark this answer as best so that others facing the same issue will find this information useful. Thank you
All Answers
Similar ask has been posted in the past: https://salesforce.stackexchange.com/questions/273/copy-production-data-to-developer-sandbox
Try SFDX CLI to download and upsert:
"sfdx force:data:soql:query -q "SELECT Name FROM Blog__c" -r csv -u prod > data.csv sfdx force:data:bulk:upsert -s Blog__c -f data.csv -i Name -u sandbox
The object must have field with unique values for all rows. Ideally with a unique constraint or marked as an external id, but not required.
It also supports lookup fields as long as the lookup object has an external id field.
When selecting the data use SELECT Parent.My_External_Id__c, ... FROM ..."
There are other solutions in the post that might want to try.
Hope this helps you. Please mark this answer as best so that others facing the same issue will find this information useful. Thank you
Thank you for the solution to my query.
Have a Great Day!