Let me preface by saying that I have read this page by Microsoft: http://support.microsoft.com/kb/841057/en-us
I have not understood it completely which is why I am here, We are currently in a tough migration Phase and due to the nature of the migration we are using some metadata is being lost. So when files are uploaded from one server to another using a webclient method and a service account it is obvious that some data will either go missing (due to a multitude of reasons) or simply be wrong.
One of these cases is "Last Modified/Edited by" for certain items. Assume I had an item called "Yearly_Review123.docx" and the last person to touch or modify that file was called "John Snow". After the upload to the 2010 server that data will become missing, i could open the SQL Management Studio, lookup the file by its uniqueid or other properties and simply edit the "Last Edited/Modified by" to say John Snow or link to that Username.
Question: Would this violate Sharepoints/Microsofts continued support policy or would this be okay? I have been told by many times by people far more senior than me that as long as you don't manipulate the DB Schema you are allowed to edit files. But reading that article and especially the:
Adding, changing, or deleting any data in any table of any of the databases for the products that are listed in the "Applies to" section
Adding, changing, or deleting any columns in any table of any of the databases for the products that are listed in the "Applies to" section
part is kind of saying not to touch anything. I mean essentially it also says that doing read-only activities such as querying the database is prohibited.
So essentially my question is this:
1) If i modify the "last edited/modified by" value in the database then Microsoft is allowed to cancel their support to this product correct?
2) Is there an alternative and or recommended way to make these changes?