OMEGA.MSSQL

Omega.MSSQL is a browser based client for Microsoft SQL Server. Omega.MSSQL allows you to access

your Microsoft SQL Server® databases using just your browser. That means your database users need

not install any and manage* special database access software to access their SQL Server databases.

Product Features
Pricing
Who should use?
Why you should use?

Product Features

Omega.MSSQL allows you to access and manage your Microsoft SQL Server® databases using just your browser. That means your database users need not install any special database access software to access the database.

Database Explorer
Designer
Database Search
Database Documentation
Reporting
SQL Query Builder

Database Explorer

Omega.MSSQL provides you in-depth information about various database objects contained in the database ranging from tables, columns, views, and users etc. all by using a very intuitive and easy to use browser based interface. Using just one application you can connect to SQL Server 2008, SQL Server 2005 and SQL Server 2000.
Demo Video You can find information about following database objects using Omega.MSSQL:

Database Object	SQL Server 2008	SQL Server 2005	SQL Server 2000
Tables (includes columns, foreign keys, indexes, triggers, check & default constraints)	Yes	Yes	Yes
Views (includes columns, indexes)	Yes	Yes	Yes
Stored Procedures (includes parameters)	Yes	Yes	Yes
Roles	Yes	Yes	Yes
Rules	Yes	Yes	Yes
User Defined Functions	Yes	Yes	Yes
User Defined Data Types	Yes	Yes	Yes
Users	Yes	Yes	Yes
Assemblies	Yes	Yes	N/A
Synonyms	Yes	Yes	N/A
Schemas	Yes	Yes	N/A
Database Triggers	Yes	Yes	N/A
User Defined Table Types	Yes	N/A	N/A
Plan Guides	Yes	N/A	N/A

Extended properties of all of these objects (if applicable) are also included.

Designer

Omega.MSSQL includes designers for most commonly used objects like tables, views etc. Using Omega.MSSQL you can design (CREATE/ALTER/DROP) these objects just by using the browser based interface of Omega.MSSQL. These features can be enabled or disabled by setting simple values in the configuration file so that administrator can control if the users of Omega.MSSQL are allowed to use these features. Table below explains the designer features available in Omega.MSSQL:

Table Designer: Using the table designer feature, you can create new tables, edit (alter) & drop existing tables. You can define new columns, define default constraints for the columns, define computed column specifications for the new columns etc.
Demo Video

View Designer: Using the view designer feature, you can create new views, edit (alter) & drop existing views.
Demo Video

Stored Procedure Designer: Using the stored procedure designer feature, you can create new stored procedures, edit (alter) & drop existing stored procedures.
Demo Video

User Designer: Using the user designer feature, you can create new users in your database, edit (alter) & drop existing users. When defining users, you can define the roles that user can have and the list of owned schemas. This functionality is available for SQL Server 2005 and above.

Role Designer: Using the role designer feature, you can create new roles in your database, edit (alter) & drop existing roles. When defining role, you can define the users that belong to this role. You can create both Database Roles & Application Roles. This functionality is available for SQL Server 2005 and above.

Rule Designer: Using the rule designer feature, you can create new rules in your database, edit (alter) & drop existing rules.

Default Designer: Using the default designer feature, you can create new defaults in your database, edit (alter) & drop existing defaults.

User Defined Function Designer: Using the user defined function designer feature, you can create new user defined functions in your database, edit (alter) & drop existing user defined functions. You can define scalar, inline, and table valued user defined functions using Omega.MSSQL.

User Defined Data Type Designer: Using the user defined data type designer feature, you can create new user defined data types in your database, edit (alter) & drop existing user defined data types.

User Defined Type (Assembly Type) Designer: Using the user defined type designer feature, you can create new user defined types in your database, drop existing user defined types. This functionality is available for SQL Server 2005 and above.

Schema Designer: Using the schema designer feature, you can create new schemas in your database, drop existing schemas. This functionality is available for SQL Server 2005 and above.

Synonym Designer: Using the synonym designer feature, you can create new synonyms in your database, drop existing synonyms. This functionality is available for SQL Server 2005 and above.

Database Trigger Designer: Using the database trigger designer feature, you can create new database triggers in your database, drop existing database triggers. This functionality is available for SQL Server 2005 and above.

User Defined Table Type Designer: SQL Server 2008 introduced User Defined Table Types. Omega.MSSQL has a table type designer feature. Using the user defined table type designer feature, you can create new user defined table types in your database, drop existing user defined table types. This functionality is available for SQL Server 2008.

Plan Guide Designer: SQL Server 2008 introduced Plan Guides. Omega.MSSQL has a plan guide designer feature. Using the plan guide designer feature, you can create new plan guides in your database, drop existing plan guides, enable or disable plan guides. This functionality is available for SQL Server 2008.

Database Search

Using any database query tool you can easily find out the information contained in the tables (i.e. data). However there is not an efficient way to search metadata. For example if you need to find what all tables contain a particular column, your only choice is to look manually into each and every table in the database to find the information you are looking for. Omega.MSSQL has an in-built metadata search engine. You specify what you are looking for, in what all objects (e.g. tables, views, etc.) you want to search for this information and Omega.MSSQL will list all the objects containing the information you are looking for.
Demo Video Table below describes the objects which can be searched using Omega.MSSQL. You have an option of doing:
- Basic [default] or Advanced searches.
- Partial (e.g. "Emp") [default] or Exact (e.g. "Employee") searches.
- Case Sensitive [default] or Case Insensitive searches.

Database Object	Searched In Basic Search	Searched In Advanced Search
Tables	Table, column names	Table, column, foreign keys, indexes, triggers, check & default constraints names
Views	View, column names	View, column, indexes, triggers names and view definition
Stored Procedures	Procedure, parameter names	Procedure, parameter names and procedure definition
Users	User names	User names
Roles	Role names	Role names
Rules	Rule names	Rule names and rule definition
Defaults	Default names	Default names and default definition
User defined functions	User defined function names	User defined function names and functions definition
User defined data types	User defined data type names	User defined data type names
Schemas¹	Schema names	Schema names
Synonyms¹	Synonym names	Synonym names
Database triggers¹	Database trigger names	Database trigger names & trigger definition
User defined table types²	User defined table type names	User defined table type names
Plan Guides²	Plan guide names	Plan guide names, query, scope batch, parameters and hints text
¹Applicable for SQL Server 2005 and up ²Applicable for SQL Server 2008

Databse Documentation

Omega.MSSQL lets you document your SQL Server databases. As a part of database documentation users can provide a meaningful explanation of various objects contained in the database. This feature is very useful for the development team and the business users of the database who will know exactly what kind of information is contained in which database object. For table columns and stored procedure parameters, Omega.MSSQL also allows you to specify what kind of values will be contained. Depending upon the data type, a user can specify that a column can contain all possible values, a set of selected values (e.g. 'A', 'B', or 'C') or a range of values (e.g. between 1 and 1000, less than 10000, greater than 50000 etc.)
Demo Video Documentation capability is supported for the following database objects:

Database Object	SQL Server 2008	SQL Server 2005	SQL Server 2000
Tables	Yes	Yes	Yes
- Columns	Yes	Yes	Yes
- Constraints	Yes	Yes	Yes
- Indexes	Yes	Yes	Yes
- Triggers	Yes	Yes	Yes
Views	Yes	Yes	Yes
- Columns	Yes	Yes	Yes
- Indexes	Yes	Yes	N/A
- Triggers	Yes	Yes	N/A
Stored Procedures	Yes	Yes	Yes
- Parameters	Yes	Yes	Yes
Roles	Yes	Yes	Yes
Rules	Yes	Yes	Yes
User Defined Functions	Yes	Yes	Yes
Parameters	Yes	Yes	Yes
User Defined Data Types	Yes	Yes	Yes
Users	Yes	Yes	Yes
Assemblies	Yes	Yes	N/A
Synonyms	Yes	Yes	N/A
Schemas	Yes	Yes	N/A
Database Triggers	Yes	Yes	N/A
User Defined Table Types	Yes	N/A	N/A
Plan Guides	Yes	N/A	N/A

Reporting

Omega.MSSQL has a built-in reporting engine using which you can generate reports about the database structure and associated documentation. Reports can be generated for all database objects or selected objects (e.g. Tables & Views only). Users can save the reports in XML & HTML format (other formats coming soon). Users have an option of saving the report on the web server for sharing and downloading it on their machines for later viewing purposes. For a sample report, click here. Demo Video Sample Report

SQL Query Builder

What good a database explorer would be if you cannot query the database to view the data. Well Omega.MSSQL has an in-built SQL Query builder using which you can create and execute SQL queries against your database. You have an option of designing the queries using a WYSIWYG query builder or writing on your own. The query engine has an in-built query validator which can be used to validate the queries for syntactical errors before they are executed. Demo Video

Pricing

Omega.MSSQL is licensed per SQL Server installation. Using Omega.MSSQL, You can connect to all the SQL Server databases installed on a SQL Server for which you have acquired a license to use Omega.MSSQL. Product pricing will depend on the number of licenses requested by you. Please note that a license is required to use Omega.MSSQL.

Currently we offer two kinds of licenses:

Trial License: A trial license as the name suggests is for you to try out Omega.MSSQL and is obviously free of cost. A trial license allows you to connect to any SQL Server database (provided you have login on that database server) and is valid for a period of 30 days from the date you requested it. You will need to provide a valid email address so that we can send you the trial license.

Individual License: An individual license as the name suggests lets you use Omega.MSSQL as an Individual. An individual license allows you to connect to up to 2 database servers of your choice along with the databases hosted on your local computer [normally accessed by specifying (local) or (local)\SQLExpress)] and is valid for a period of 90 days from the date you download it. Currently an individual license is offered absolutely free of cost. You will need to provide a valid email address so that we can send you the individual license.

Who Should Use Omega.MSSQL?

Web Hosting companies: Web hosting companies who offer Microsoft SQL Server to their customers can use Omega to provide their customers with a browser-based access to their respective databases from their portal for an overall integrated experience. Customers need not download/install/use 3rd party software for accessing their databases.

Organizations with a need to expose their databases: Often times, organizations need to provide a direct access to their databases outside of their network. Usually the databases reside within organization internal networks. Currently for this they will have to open up certain ports within their firewall (e.g. TCP port 1433) or resort to mechanisms like Virtual Private Networks (VPN) so that database access tools (like Enterprise Manager etc.) can connect to the database. Using Omega.MSSQL, they can easily do so by fronting their databases with Omega.MSSQL. Under a normal deployment scenario, they would host Omega.MSSQL in their DMZ network segment (along with their other web applications) and they will have to just open up ports used by SQL Server between DMZ and their internal network (which would already be open if they are hosting database-based applications using SQL Server).

New Employees/Business Users: Database documentation is one of the most ignored parts of the overall documentation process. Omega has the capability to document most of the database objects. Omega can be used to train new IT staff on the enterprise databases. Similarly Omega.MSSQL can be used to provide information about the objective of a particular database object (e.g. what a particular table does, or what kind of values a column can contain) from a business perspective to a business user.

Ad-Hoc Reporting Users: Omega has a built in query engine using which users can build and execute queries against a particular database. Skilled users can write their own complex SQL queries and at the same time a novice user can use an easy-to-use graphical user interface to design and execute queries.

Why You Should Use Omega.MSSQL?

There are a number of reasons you should use Omega.MSSQL:

Browser based: First and foremost, it is browser-based. What that means is that you or your database users need not install any special software to access database. Just use a web browser to find information about the database.

Built-in Search Engine: Omega.MSSQL has a built in search engine which allows your users to search for objects (not data) contained in the database. For example, you can search for a column name and Omega.MSSQL will bring the list of tables which contain this column.

Built-in Query Engine: Omega.MSSQL has a built in query engine which allows you or your users (at various skills level) to design and execute queries against your database.

Security: If you are a database or network administrator, you need not open up your database to the outside world. Just front your database with Omega.MSSQL, if somebody from outside of your organization needs to access your database. You can configure Omega.MSSQL to limit certain functionality (e.g. you do not want users to use query engine of Omega.MSSQL to execute queries against your database).

Document your database: Omega.MSSQL allows you to document your database objects and provide business/technical importance of these objects to your team members. Think of it as a great tool for your new hires (who often have to rely on current staff to get an understanding of the database) and business users (who have to struggle with the business understanding of a particular object)!!

Online Demonstration

Want to try Omega.MSSQL even before downloading!!! Click on the fully functional online demonstration links below. You will have access to our application connecting to one of our sample databases (and not just some Flash animation movie).

The demo version however has some limitations/built in features:

Any updates/deletes/structure changes done by you using the SQL Query editor will not be saved.
Database server name will be masked.
The demonstration application will automatically log you in. You do not have to provide the database login name and password.

This demonstration application connects to AdventureWorks database (SQL Server 2005). So what are you waiting for!! Click on the link below to get started with the demonstration and try the software.

Omega.MSSQL Demo - SQL Server 2005 (AdventureWorks Database)

Omega.MSSQL Features

Database Explorer
Designer
Database Search
Database Documentation
Reporting
SQL Query Builder