I'm testing a few different migration strategies for moving some existing on-premise files to Amazon S3. This sometimes involves revising data in LiveSlider_Slide.BackgroundImage, LiveSlider_SlideLayer, LiveHTML_Content.Content, to name a few. These revisions are easy enough script.
The issue that I'm currently working through is how to migrate files but keep their existing FileID. One of the reasons is that LiveContent_Element_ePicture.PictureURL uses FileID (and not path name) to reference items. I have yet to test simply changing Files.Folder values to point to the S3 folder containing the same items. Is there any guidance available on this?
FileIDs are managed by DNN core. I can't think of any automatic way to keep the FileIDs; you would have to run a manual script after migration to either update LiveContent table or the Files table.