Merging the Audit Events from Two SQLite Databases
Audit events from two SQLite databases can be merged using DB Browser by attaching the second database, adjusting IDs to avoid conflicts, and combining entries into a single unified dataset.
Description:
The attached document explains how to merge the audit events from two Audit Manager SQLite database using the DB Browser for SQLite program.
Supporting SQL files attached below.
Environment:
Audit Manager
Security Suite
Attachment(s):
| File | Last Modified |
|---|---|
| Add NewID Field to Db2.sql | December 12, 2024 |
| Update NewID field with new iD numbers.sql | December 12, 2024 |
| Merge AuditEvent Tables.sql | December 12, 2024 |
| Find Highest ID Number.sql | December 12, 2024 |
| Merging Audit Events from two SQLite databases.pdf | December 12, 2024 |