OmniView

OmniView is much more than just another visual query tool. It is an adept data manipulation application that makes working with SQL Server or MSDE database content both effortless and swift, catering to users with a wide range of skill levels. With OmniView, DBAs and developers can conveniently access and change data much more rapidly than with the native tools provided with SQL Server. However, less technically-proficient users can even benefit from OmniView. Project managers, technical support staff, QA teams, trainers, and sometimes customers can use OmniView to increase their productivity and reduce the workload of DBA support.

OmniView offers features like quick and easy access to table data using a familiar spreadsheet-like grid. You can efficiently add, edit, or delete data in-place without knowing any SQL. Moreover, filter data with point-and-click selection of fields, operators, and values, or use the complete SQL syntax; it's your choice. You can save time while changing text or binary data with full-featured editors specifically suited for BLOB data.

OmniView allows you to organize database tables into groups that you define. You can bundle frequently used or related tables together for easy and quick access. You can also create private views of data that you specify. You can select the rows and columns you want to see, in the format you want to see them. Furthermore, you can recall the view at any time with a simple mouse click.

OmniView saves time while adding new rows that are substantially similar to existing rows using the "copy row" feature. This feature can save users from manually rekeying similar data. Additionally, you can export table data or query results to Excel, XML, HTML, or text files. Finally, OmniView allows you to print formatted reports of selected data, further enhancing its efficacy as a data manipulation application.