Which is the best practice to move newly created subcategories in sys_choice table

[Srinivasu2]

Hi Community,

Which is the best practice to move newly created subcategories in sys_choice table.

1) Export newly created subcategories from dev and import to test

2) through update sets

I have written record producer script based on user select these subcategories, it will auto assign to respective group in incident.

because these highlighted subcategories are not moved to test via update set at 1st time

Please advise

Thanks & Regards,

Srinivasu

[Vishal Birajdar]

Hi @Srinivasu2 ,

Either way is good.

1.Will recommend to go with update set (retrieve xml or update source)

2.Exporting XML and importing is manual step.

[Harish KM]

The preferred way is Update Sets, How ever you can do xml import as well. XML will check the sysid of your choice record if present it will update the choice list else it will create a new choice record.

Also when you do xml import always take back up of your data in test instance because if some thing fails we can reimport the old data, for update sets we have rollback option which is easier to do roll back, hence preferred way is update set.

[Srinivasu2]

Hi @Harish KM,

But Around 77 subcategories, 75 subcategories are already moved to test at 1st time via update set, 2 are not moved to test,

Can i go with recapture the those 2 again in dev and moved to test via update set

Could you please confirm?

Thanks & Regards,

Srinivasu 

[Harish KM]

in that case, you have 2 options,

1. re capture those 2 choice list in your update set and move the update set to test instance.

2. export only those 2 records which is missing in test instance as XML data to your test instance

either ways are same . just option 2 is manual work.