SQL Scout for MS SQL Server 2005 is a new application from Midnight Pineapple, that revolutionizes data access by placing complex data retrieval at the fingertips of the business user. The user is offered a graphic representation of data at table level, linked with data from related tables. The user can specify complex search criteria with ease and tailor the view of the data in a number of ways. The user can save his work and continue at a later stage without a connection to the database.
March 11, 2009
Version: SQL Scout for MS SQL Server 2005 1.0
Very easy to install, configure and run. Excellent tool for viewing and sampling test and production data. Was very surprised at how quickly it pulls back multiple rowsets from complex relational schemas and documents them graphically.
Not really a con, but you will need to install version 3.5 of the .Net framework (available free of the Microsoft website) on your client machine before running the tool. Definitely worth it for the end result!