Not just another visual query tool, OmniView is an advanced data manipulation application which lets users with a wide range of skill levels work with SQL Server or MSDE database content quickly and easily. DBAs and developers can examine and change data more rapidly and conveniently with OmniView than with the native tools provided with SQL Server. But less technically-skilled users can benefit from OmniView as well: project managers, QA teams, technical support staff, trainers?and sometimes even customers. Often these users are not as proficient with the more developer-centric SQL Server tools, but OmniView increases their productivity and reduces DBA support workload.
* Quick and easy access to table data using a familiar spreadsheet-like grid.
* Add, edit, or delete data in-place, without knowing any SQL.
* Filter data with point-and-click selection of fields, operators, and values. Or use complete SQL syntax. It's your choice.
* Save time changing text or binary data with full-featured editors specially suited for BLOB data.
* Organize database tables into groups that you define; keep frequently used or related tables bundled together for quick and easy access.
* Create private views of data to your specifications...the rows and columns you want to see, in the format you want to see them...and recall the view at any time with a simple mouse click.
* Save time adding new rows which are substantially similar to existing rows using the "copy row" feature...saving you from manually rekeying similar data.
* Export table data or query results to Excel, XML, HTML, or text files.
* Print formatted reports of selected data.
See also: spreadsheet, database tools, data query, data editor, data edit, mssql, sql 2005, sql 2000, msde, sql server, sql access