Currently I'm migrating files from SharePoint to a custom built WEBCON DMS application. Normally the Instance number is generated according to a rule which is perfect for new files. The customer wants to keep their document numbering.
For the existing files I would like to update the Instance number (Database: WFD_Signature) using a small SQL script. But is it safe and is it wise to do that? I'm aware the numbers need to be unique in the system, and I know they are unique in the old system. I will also do an extra check during migration.