Is there a way to modify sys_id's?

kevinlin · ‎04-04-2016

We have a custom table to manage our applications, however one of the applications have different sys_id's in our prod and dev instances. This likely occurred because we created the entry in prod, rather than copy it over. I was wondering if there was a way to change the sys_id?

Thanks!

Brian Dailey1 · ‎04-04-2016

Hi Kevin,

You could export the application in question from your prod environment as XML, and then import it into dev to replace the one that is out of sync (remove this one after).

To export the current application record from prod, just view the application's record and right-click the header, then choose "Export-->XML (This Record)".
To import this XML file into your dev environment:
1. You must first elevate your security_admin access by clicking the padlock icon next to your name at the top-left, and then selecting "security_admin"
2. Navigate to the Applications module
3. Right-click one of the list's column names and choose "Import XML"
4. Browse to your exported XML file from prod, and Upload.

Once you are done, I would inactivate the odd-application record (that's out of sync) and test. If everything checks out ok, you can go ahead and delete it. A clone from prod-->dev would also get you in-sync, but that is a bit extreme for this simple of a situation.

Give that a try.

Thanks,

-Brian

View solution in original post

kevinlin · ‎04-07-2016

Thanks for your response, Chris.

I'm going to try an export first, because I believe this is the only thing out of sync.