Sys_id mismatch in Dev and Prod instances.

[jobeasow]

I need to delete a variable from the Production instance, but however this variable was not present in the DEV. Because of this I created a similar variable and thought of deleting it. Later came to know that pushing the update set with the change I did will not delete the variable from production since both of them have different sys_id. Can any one suggest how to deal with this scenario?

[Mike Allen · Accepted solution]

I would suggest exporting the variable from PROD and importing it into DEV.   This way, it would keep the sys_id.   You can then delete it in an update set and that update set would apply to PROD correctly.

[jobeasow]

Can I just do a simple XML export/import for this?

[Mike Allen]

Yes.   It should just insert the variable in, and the sys_ids will match.

[Deepak Ingale1]

Hi Job,

Mike suggestion will work 100%.

Only thing to check, the variable you are trying to import, if has any reference field, make sure that reference field record exists in both DEV and PROD with same sys_id. Else sometime you will not get desired result.

You can verify that after importing the variable record in DEV system.