SQL Enterprise Manager makes
short work of a lot of tasks in SQL Server, but it is woefully
inadequate for quickly viewing, changing, or manually adding
data in tables.
OmniView fills that gap by providing powerful data manipulation
capabilities in a simple user interface. DBAs, developers,
tech support, QA staff...all will benefit from the ease
of use of OmniView.
OmniView is a general-purpose data viewing/editing utility.
We built OmniView in recognition of the need for easy, powerful
access to raw data in database servers. OmniView is very
useful for anyone involved in database development or maintenance.
Useful for Expert Users...
Database administrators and developers will find data access
through OmniView quicker, easier, and more convenient than
that which is provided natively with SQL Server Enterprise
Manager and Query Analyzer. But users outside traditional
development roles will find even greater value with OmniView...
...Invaluable for Nonexpert Users
OmniView was specifically designed to address the needs
of technical users who need access to raw data but who aren't
necessarily expert database developers or administrators.
We have found that technical support staff, quality assurance
teams, project managers, trainers, and others often need
to directly examine and manipulate data outside the constraints
of end-user applications which operate on that data.
This same group of people is often not as productive with
the more developer-centric tools of Enterprise Manager or
Query Analyzer. They need to rapidly and easily get in and
out of data and then get on with their job.
Smart Editing Streamlines Tasks and Reduces Mistakes
OmniView is more than just a simple data browsing/editing
tool. OmniView uses its knowledge of the server-defined
characteristics of the data to streamline tasks, reduce
data entry mistakes, and add convenience.
Some of the benefits of OmniView...
Users can setup private views of particular rows and columns,
much like a SQL view but without having to setup a physical
view in the database. Recall the view later with a simple
mouse click.
Define groups of related or frequently used tables so you
can easily access the tables you use most without having
to scroll through the entire list of tables in the database.
Filter rows without knowing SQL syntax! Use a point-and-click
interface to select column names and pre-defined operations.
Filtering using actual SQL expressions is also available.
Add new records which are substantially similar to existing
records using the "copy row" feature...saves you
from manually rekeying similar data.
Export data to Excel, XML, HTML, or text formats.
Print formatted reports of selected data