OmniView

A tool which lets you directly edit or query data with no knowledge of SQL
Download

OmniView Ranking & Summary

Advertisement

  • Rating:
  • License:
  • Commercial
  • Price:
  • $59
  • Publisher Name:
  • Krell Software, Inc.
  • Operating Systems:
  • Win95,Win98,WinME,WinNT 4.x,Windows2000,WinXP,Windows2003
  • File Size:
  • 5.91 MB

OmniView Tags


OmniView Description

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, quality assurance teams, technical support staff, trainers�and sometimes even customers.OmniView is a software that allows you to edit or query data. 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. OmniView allows you to examine data from any table or view just like a spreadsheet. You can add, change or delete data just as easily as you would within a spreadsheet, without writing any SQL queries whatsoever. In addition, you can create queries against data using a simple point-and-click interface that does not require any SQL knowledge. Build expressions by selecting fields, operators, and values from dropdown lists. OmniView transforms this behind-the-scenes into the appropriate SQL and performs the query for you. Power users or SQL-savvy individuals can still write SQL expressions directly if they desire. Entire SQL scripts can be created from scratch using OmniView's advanced SQL editor. The editor includes auto-completion features that provide dropdown lists for database tables, SQL functions, and global variables. Write SQL quicker and more accurately. Any data returned by the query can be manipulated with the same powerful spreadsheet features described above. OmniView Professional goes a step further and adds features for advanced users. Pro allows you to work with stored procedures using a parameter editor and provides the same spreadsheet features for results returned by the stored procedure. Pro also lets you view and edit system table data. Main features: 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.


OmniView Related Software