How to copy a record from one table to another table

Carol543 · ‎11-03-2022

I want to copy all the records in table A to table B.
Is there a way to copy in a script without using record export / import?

Gunjan Kiratkar · ‎11-03-2022

Hi @Carol543 ,

You can write a background script

var gr = new GlideRecord('tableA');
gr.query();

gr.setLimit(1); // test for 1 record after that use 100 or 500 as limit so that browser will not hang
while (gr.next()){
var rec = new GlideRecord("tableB");

rec.initialize();

rec.field = gr.field; // map the field name like this

rec.insert(); // insert to b table
}

Regards,

Gunjan Kiratkar

Please Mark My Response as Correct/Helpful based on Impact

Regards,
Gunjan Kiratkar
2X ServiceNow MVP
Community Rising Star 2022
Youtube : ServiceNow Guy

View solution in original post

Carol543 · ‎11-03-2022

As of now It is one time use only and may be needed to use in future as well as per requirement.

Mike_R · ‎11-03-2022

I would just create in flow designer similar to this structure. No code required, just drag and drop.

Mike
* My Collection of ServiceNow Stuff *

JulietD · ‎02-10-2025

Hi,

How to use fix scripts to move data from parent tables to child tables?

Eg: from server table to windows and linux tables?

Thanks

rakeshtalla13 · ‎07-12-2023

But in this case, do we have to add all fields at "Create Record" Field values

How to copy a record from one table to another table

Please Mark My Response as Correct/Helpful based on Impact

Regards,Gunjan Kiratkar2X ServiceNow MVP Community Rising Star 2022Youtube : ServiceNow Guy

Regards,
Gunjan Kiratkar
2X ServiceNow MVP
Community Rising Star 2022
Youtube : ServiceNow Guy