How can clone table from prod to dev

[Martina9]

I have to clone two custom tables from prod to dev, these have too  many record and I'm not able to export xml

Can we suggest an other way to procede?

Thanks

[H_9]

You can use the clone application.

You can specify which tables to be excluded from the clone and which tables to be included.

Please follow the steps from the following link:

https://docs.servicenow.com/bundle/tokyo-platform-administration/page/administer/managing-data/task/... 

Please mark the answer correct if it helps.

[Martina9]

I want clone only the record inside the table and not alse the related rules, can I use Clone application?

[H_9 · Accepted solution]

yes, still you can use the clone application.

But you will have to be very careful with the tables selected for cloning, as you dont want unwanted data to be copied from Prod to Dev.

I would suggest you to take help from HI support for selecting the proper data while cloning, by raising a HI ticket as this seems critical.

[Baala T]

Hi,

The simplest option is to clone entire instance, you will get up to date data for all the tables.

The other approach is to extract data in XML format in smaller size, like date / week wise data manually or thru automated script.

Regards,
Bala T