We are moving from Oracle to a SQL based Laserfiche server. If we export all the volumes from the Oracle server to the SQL server, what are the things I should be aware of?
I know I need to re-create access/security.
What about the entry IDs? If they change, then are there any tips for creating a cross-reference list of old IDs and new IDs? How can I recreate the audit history if its needed after moving to the new server?
Do we need to create a new Workflow server and database? Or can we hook up the existing server to the new SQL server without an issue?
What's the fastest way to export the volumes? We have 1 app server and 1 database/image server. I'd like to export the volumes back to the image server without the files being transferred around the network between the 2 servers and copy directly to the image server to speed it up.
If you can answer any of these questions, I appreciate what you are willing to provide. Thanks!