Is there a way to modify sys_id's?

[kevinlin]

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 · Accepted solution]

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).

1. 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)".
2. 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

[kevinlin]

Thank you, Brian.

I believe this is the best option for me.

[Chris M3]

The best bet is to do a clone when you have the chance, sync the two environments back up.   If the record is referenced in places, all of those references would break by changing the sys_id.

[JusCuz]

What Chris said above....do a clone, this will make everything identical between the two instances. I suggest having a plan on regularly scheduling clones depending on how much work you do in your DEV environment as well.