Is it possible to keep TMG Reporter data storage in database of SQL Server?
Thanks for getting in touch.
TMG Reporter's data store is a flat file structure that is optimized for our reporting processes. It is not possible to back the data store onto SQL Server. We did investigate this architecture, but it introduced too many unacceptable performance overheads.
I assume you would like to run your own SQL queries on the data? Is there any specific query you would like to perform that TMG Reporter cannot provide?
Forefront TMG can log to a remote SQL Server that you can then query directly. You can also monitor the SQL database with TMG Reporter. Would this suit your purpose?
For information on remote SQL logging, see http://www.fastvue.co/tmgreporter/blog/forefront-tmg-enterprise-logging-with-remote-sql-server
For information on monitoring the SQL Database with TMG Reporter:
I hope this helps. Let me know how you go.