Data Migration

[geet]

Hi All,

I have migrated data from sharepoint to my SNOW DEV instance through import sets and now i want to import same data to my TEST as well as PROD instance.

As per my knowledge, i think that once data is there in my DEV instance i can just export an XML and import it to my TEST as well as PROD.

But somebody has put me into dilemma by saying:

I haven't used the import excel to table feature till now. But I will not suggest loading xml, as for that, the sys_id's for all the reference field values has to be same in all instances.

It's better to go for an excel import — either using import set or importing to table.

Kindly share your responses upon uploading data from DEV to TEST and then to PROD through XML and Excel.

Which is the best practice? to load it through import export or through import set only.

Regards,

Shikha Khanna

[Atul Kumar2]

Hi Shikha,

I am very much agreeing on the first statement since you should not use xml.

You may use import set or directly you can import to the table.

Note: Can you not clone the system if you are too worried about this situation. Caution - look before you go for cloning.

Hope this helps.

Regards,

Atul Kumar

[Jaspal Singh]

Hi Shikha,

XML loading should be preferred when we have all sub-production instances recently cloned from PRD as then sys_ids would be same in all instances.

If it has been a while when your sub-production instances are cloned importing data via excel would be a better approach. Importing xml would also work but some records may have discrepancy because of sys_id different in different instances.

Also, importing data via excel is easy & would not take much of effort for set up. Refer wiki link http://wiki.servicenow.com/index.php?title=Data_Sources#gsc.tab=0 for better understanding for creation of datasource & related transform map.

Thanks,

Jaspal Singh

Hit Like or Correct on the impact of response.