Export the Data in Production and Import into Dev automatically

[Srinivas Chinn1]

Hi all,

I'm trying the import the data from the production by using data source XML path.
the data is inserting into the Dev instance but with different sys_id. Means same record in the production is having different sys_id and in Dev is having different sys_id. 
i want to maintain the same sys_id's across the instances. i have tried below method but it inserting with new sys_id's in instances.

Create an XML data source to another instance.

Any help or suggestions is much helpful. 

[Dr Atul G- LNG]

Hi @Srinivas Chinn1 

IS that exists in Dev already? and created manually or alrady brought from prod?

If brought from prod, then no issue in Sys id but not then it will create data with new sys id, also if it is user data then you will get error on UserID, as 2 user cant have same user id. 

[Srinivas Chinn1]

Hi AG,
The data is won't be available in Dev why because I'm importing the newly created data in production to Dev instance.

[Dr Atul G- LNG]

Hi @Srinivas Chinn1 

then no issue with sys id. it will be same in dev n prod.

try with 2-3 records to bring in dev n test.

[Srinivas Chinn1]

Hi AG,
By using the data source I'm importing the data from the Production to Dev. 
in this case it is creating the data with the new sys_id's on the instance