export and import Activity log ?
Hello,
Our company has been acquired by another firm a while ago, but we have still been using RDM.
That same company also acquired another company which uses RDM.
Well, I want to merge both RDM databases together into 1 database which is already done.
I used the others company's database to start from and exported all sessions from our database/RDM instance, which I then imported
in the new database/RDM instance. So now I have 1 database with all sessions from both companies.
However, because of GDPR, I also want our Activity log imported in the new database.
As far as I can see, there's an option in the Activity Log to export the data to a CSV file.
But I don't see an option to import this CSV file anywhere. Am I missing something ?
EDIT : Never mind, I already got it. Used SQL's export and import tool to get the data from table "connection log" from "old" database to
import into the "new" (combined) database.
All Comments (2)
Hello,
Happy that it worked out. The BIG BIG issue with using tools provided in SSMS is that great care must be applied to include ALL objects, we often see customers with issues because they've lost database triggers, or with identity values for certain columns to be out of sync. For the ConnectionLog table, we have three triggers to maintain the ConnectionState table. If you only moved DATA exclusively, you should be fine...
I wish for your company to continue in this acquisition path, you will need more licenses ;)
Best Regards,
Maurice
Hi Maurice,
Yes, I only did a data export/import and nothing else.
I have tested it and it works well.
But good that you point this out for users who will want to do the same.
We extended our Enterprise license again with 1 year this week, so for now we are good to go ;-)
Unfortunately this company that acquired us, doesn't use RDM but it now gives me 1 year to convince them to start using it ;-) hahahaha
Kind regards,
Ron