This is just a quick post for all those DNN developers out there who sometimes delve into the DNN database data.....I just released a tool called SQL Sets that allows you to easily capture, share, organize and navigate data in the context of a complex db scema such as DNNs.

I think the most useful feature for DNN developers is the Deep Fetch Query which allow you to quickly and easily retrieve data for a specific row (or rows) of data and ALL of its children with a few clicks.  So, for instance, you can query the Portals table for PortalID = n and bring back data related to that Portal for all 45-50 tables related via Foreign Keys. .

It has some other useful features for DNN devs as well, but this is one I use myself for another product I have that leverages DNN for a public facing portal. Let me know what you think!

Sincerely,

Mike Morris

SQL Sets

http://sqlsets.com