Before SBO accepted attachments in Business Partners and Marketing docs, we created user fields to include attached files.
Now that we've moved to 9.0, we want to move all the data from the user fields to the right 'regular SBO' tables. Files do not need to be moved as they are in the same path as the 'regular' files and path is also stored in the DB.
There were documents before in OATC and ATC1.
It is just one file (or none) per Business Partner or Marketing document, so I guess we have to create records in OATC and then in ATC1, but not sure how to run an UPDATE query for this...
Any ideas, experience?