Search SMAT in a database

This topic has 3 replies, 3 voices, and was last updated 4 years, 9 months ago by Ken Smith.

Creator

Topic
January 6, 2020 at 4:34 am #114578

Ken Smith
Participant

Is it possible to open the SMAT databases in a sql database, e.g., SQL Server or SQLLite? I need to search across two sets of message logs. Or is is possible to export them to a format that can be imported into a SQL database?
Creator

Topic

Viewing 2 reply threads

Author

Replies
- January 6, 2020 at 9:12 am #114581
  
  James Nelson
  Participant
  
  You can use sqlite, but be aware that if your SMAT databases are encrypted, you will need to issue a ‘PRAGMA KEY = <password>’ command when you open the file, then you can issue sqlite commands as usual.
- January 7, 2020 at 2:37 am #114598
  
  Charlie Bursell
  Participant
  
  For example code take a look at the hcismatdb script I uploaded a while back
- January 7, 2020 at 3:54 am #114599
  
  Ken Smith
  Participant
  
  Thanks for your replies, I’ll take a look at both options.
Author

Replies

Viewing 2 reply threads

You must be logged in to reply to this topic.