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 

Yes in this case Sys id will be different. I am not 100%  sure, for 1st time do xml inport / export and then do data source in this case data only updated.

@AshishKM any thoughts. 

[Robbie]

Hi @Srinivas Chinn1,

In support of what @Dr Atul G- LNG has advised, if you're exporting records from Production via XML, you can simply import these records via the same process and via the same XML file - Data sources and transform maps etc are not required.

Note - ServiceNow will only create new sys_id's for these records if the sys_id is already used. Please note however, if the sys_id is already used and it's associated to the same record - eg a CI record - then the said CI record will be updated to match the import thus syncing up with the imported file (And in your case Production)

Just to clarify, to both import and export XML files, simply navigate to the table list view and filter the records accordingly - example (Active records only) and at one of the column headers right-click, and select 'Export > XML' or 'Import XML'.

To help others (or for me to help you more directly), please mark this response correct by clicking on Accept as Solution and/or Kudos.

Thanks, Robbie

[Srinivas Chinn1]

Hello as per above issue,
I'm trying to importing the data with data source by XML path.
Any suggestions is much helpful

[Dr Atul G- LNG]

Okay, then I think no issue in sys id. As I said earlier as well @Srinivas Chinn1  take 2-3 record max in XML from Prod, create a data source in Dev and then see is both sys id same or not. As far as I know both should be same.

[Srinivas Chinn1]

Hi AG,
i have created a Data Source and i have checked that the sys_id's is different.
Import set table we are getting the sys_id of the record but while transforming the data to target then it is inserting the record. so it creating a new record with a new sys_id in Dev instance.
Please suggest me how can we enforce the same sys_id in staging table to target table.