Just wrote this, figured I'd share. Bill, I absolutely love Cleartrace, the 3 operations DBAs believe it's a must-have for any DBA. Absolutely stuns me that more people don't know about it. We recently started running daily traces for certain events, and wanted a way to automatically import them so that we could read them with Cleartrace.

Hope this is useful, and please feel free to critique.Looking forward to a 2012 version of the cmdline version!

*UPDATE*no code change, just wanted to see if anyone was using this, if it was handy, or not. Also useful: if you run cleartrace against an open file, it will import the file but can't move it. So you could run this while your traces were open. Once the trace rolled, it would reimport it (overwriting what it currently had in the table for that file), and then move it. For us that means we can run this during the day too, and have useful information at any time.

*UPDATE2* 2013/09/19 I forgot to sub my staging table for the prod table, so missing records in Automated_Server_List could cause some to not work. This will probably be the last update; it works really well, this is just a bugfix, but obviously we're moving to Extended Events. (Bill - Any hope for an XE-compatible version? Obviously we can just query the XE XML, but I'll miss the UI capabilities).