How to get Notes, SQL, Column metadata out of .TSM file?

I want to automate the collection of metadata from my Toad Data Point files. I was hoping to read the .tsm file as XML–but its encoded differently.

Doe’s anyone know the encoding of the .tsm file?

Or, Does anyone know how to export the information created during a Query Builder Session?

Is there some command line options that can act as interface to the file?

Thanks!

To get tsm file as xml you have to unwrap it – delete everything before opening node <SqlModelerElement and after the closing node

After that you should be able to open and parse it.

Hope it helps you.

Aleksey