Need to only clone data from Prod to SubProd without affecting system configurations.

Shivani5
Tera Contributor

We need to clone the data for some of the tables from one instance to another. 

Which approach is most effective for achieving this scenario?

3 REPLIES 3

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @Shivani5 

 

You can add those table in preserve during clone. or you can get it via xml but clone is best way.

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

Viraj Hudlikar
Giga Sage

Hello @Shivani5 

 

Refer below links to clear if any grey spot in mind.

ServiceNow Cloning preparations and best practices... - ServiceNow Community

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB1214608

https://youtu.be/rHxuRQVh37M?si=eVIIpN5L6XZ9bv3V

 

If my response has helped you hit helpful button and if your concern is solved do mark my response as correct.

 

Thanks & Regards
Viraj Hudlikar.

It's extremely important for your sub-production ServiceNow instances to closely resemble your Production instance as best as possible. By keeping them in sync, you enable your development teams to work in environments that are near identical to what your end-users are experiencing every day. In ...

jcmings
Mega Sage

The easiest way to achieve this is through an XML export (filter from the list view down to the records you need, then click on the three dots next to the column header > Export > XML). Then on the target instance, click on those three dots again, and Import XML. Note: you can Import XML on any table you are viewing, and it will automatically upload to the correct table. (For example, if you were viewing sys_user, and imported XML for incident, it wouldn't mistakenly upload those incident records to sys_user.)

 

Alternatively, you could set up a clone profile if you'd like to achieve this on a somewhat regular basis. You'd have to specify the exact information to include and exclude.