Archiving of data from CRMoD to internal database
Hi All,
We want to archive some old data from our CRMoD. We think about do export of necessary objects and their records and import to database, because keeping them only in exported csv files is useless, especially when each object is in separate file. We want to achieve something similar to Siebel database which we had for our CRM system, so schema with account, contact, activity ... tables.
The best option option will be to get database schema creation script of our instance. Then, we will import data from csv files to this schema which will allow us to export necessary data when user will need this for audit purposes.