Free ems sql manager lite software for windows

A software application that enables you to simplify and automate your database development process EMS SQL Manager 2007 for DB2 is a high performance tool for DB2 Database Server administration and development. SQL Manager 2007 for DB2 works with DB2 versions 8.1 and 8.2 and supports all DB2 objects and data types.
EMS SQL Manager Lite for DB2 provides a wide range of powerful utilities for experienced users such as Visual Query Builder, Visual Database Designer and powerful BLOB editor to satisfy all their needs. SQL Manager 2007 for DB2 has a state-of-the-art graphical user interface with a well-described wizard system, so clear in use that even a newbie will not be confused with it.
Main features:
New state-of-the-art graphical user interface
- Office 11 and Windows XP visual schemes support
- Well-described Wizard System
- User-friendly Database Explorer for easy management of all DB2 objects
- Windows Toolbar to switch between windows easily, like in Windows Task Bar
- Navigation bars and hot keys in most of the windows
- Ability to save all program settings
- Customizable toolbars for all program windows
- Fully customizable program interface
- Powerful visual options module
- Localizable program interface
Easy management of all DB2 objects (including create / edit / drop operations)
- Managing database schemas
- Managing tables and all their subobjects: fields, primary, unique and foreign keys, indexes, triggers, and check constraints
- Managing views and all their subobjects: fields and triggers
- Managing materialized query tables
- Managing procedures, functions, sequences and packages
- Managing user-defined types and structure types
- Managing nicknames and aliases
- Managing users, groups and user mappings
- Managing tablespaces, buffer pools and partition groups
- Managing event monitors
- Managing servers and wrappers
- Duplicating database objects
- Viewing dependencies between database objects
Rapid database management and navigation
- Multiple database connections
- Registering selected databases to work with
- Projects to work with the selected database objects only
- Multiple user-defined tabs for any tree object to access it in one-click
- Working with multiple selected objects at a time
- Grouping / Ungrouping registered databases by node name
Advanced data manipulation tools
- Unicode support
- Plenty of useful tools such as data grouping, fast search and filtering
- Ability to continue working with SQL Manager while data are being fetched from the DB2 server
- A fetching process taking too long to execute can be aborted
Effective security management
- Grant manager displaying all database object grants in the form of a grid
- Easy management of database users, groups and user mappings
Excellent visual and text tools for query building
- Multiple SQL Editors of the Visual Studio 2005 kind with Code Folding, UNICODE support, code completion, syntax highlight and other useful features
- Large script execution (SQL script editor) with UNICODE support
- Ability to continue working with SQL Manager while a query is being executed in SQL Editor or Query Builder
- A query taking too long to execute in SQL Editor or Query Builder can be aborted
Easy-to-use wizards for running DB2 services
- Back up and restore database
- Rollforward database
- Stop, start and restart database
- Quiesce and unquiesce database
- Reorganize database tables and indexes
- Run database statistics
- Background mode execution makes it possible to continue working with SQL Manager while any of DB2 services is being performed
Most of DB2 server versions support
- Support of 8.1 and 8.2 DB2 server versions
- Support of most DB2 server platforms (LUW, z/OS, etc.)
Other useful tools to make your work with DB2 server as easy as it can be
- Extracting metadata into text files or SQL Script Editor
- SQL Monitor
- Dependency tree tool allows to view dependencies between database objects
...and other useful features
- Keyboard templates
- External Tools editor
- To-do list
System requirements:
- 300-megahertz (MHz) or higher Pentium II-compatible processor; 600-MHz or faster processor recommended
- 64 MB of RAM or more; 128 MB or more recommended
- 50MB of available HD space for program installation
- Super VGA (800x600) or higher-resolution video adapter and monitor; Super VGA (1024x768) or higher-resolution recommended
- Microsoft Mouse or compatible pointing device
- Possibility to connect to any local or remote DB2 server

EMS MS SQL Manager Lite is a light and easy-to-use freeware graphical tool for MS SQL/MSDE administration.
It has minimal required set of instruments for those users who are new to MS SQL server and need only its basic functionality.
EMS MS SQL Manager Lite is an SQL editor for database objects and an SQL manager.
It makes creating and editing MS SQL Server database objects easy and fast, and allows you to run SQL scripts, manage users and their privileges, simply edit SQL queries.
Main features:
- Powerful and easy-to-use graphical user interface;
- Rapid database management and navigation;
- Easy management of all Microsoft SQL objects;
- Advanced data manipulation tools;
- Powerful security management;
- Excellent visual and text tools for query building.
Enhancements:
- Latest SQL Server versions support;
- Significantly improved user interface;
- Improved Database Explorer;
- New powerful data management tools.

EMS SQL Manager Lite for SQL Server is a light and easy-to-use freeware graphical tool for MS SQL/MSDE administration. It has minimal required set of instruments for those users who are new to MS SQL server and need only its basic functionality. It makes creating and editing MS SQL Server database objects easy and fast, and allows you to run SQL scripts, manage users and their privileges, simply edit SQL queries and more.
Key Features:
- Microsoft SQL 2005 Support;
- Powerful and easy-to-use graphical user interface;
- Rapid database management and navigation;
- Easy management of all Microsoft SQL objects;
- Advanced data manipulation tools;
- Powerful security management;
- Excellent tools for query building.

EMS SQL Manager Lite for MySQL is an excellent freeware graphical tool for MySQL Server administration. MySQL Manager works with any MySQL versions from 3.23 to 5 and supports all of the latest MySQL features including views, stored procedures and functions, InnoDB foreign keys and so on. It has minimal required set of instruments for those users who are new to MySQL server and need only its basic functionality. MySQL Manager has a new state-of-the-art graphical user interface with well-described wizard system, so clear in use that even a newbie will not be confused with it.
Key Features:
- Full support of MySQL versions from 3.23 to 5;
- New state-of-the-art graphical user interface;
- Rapid database management and navigation;
- Simple management of all MySQL objects;
- Advanced data manipulation tools;
- Access to MySQL Server through HTTP protocol;
- Connecting via local port forwarding through the SSH tunnel;
- Powerful security management;
- Excellent tools for query building.

EMS SQL Manager 2007 Lite for Oracle 2.2 is an updated tool for Oracle Database Server administration and development. It offers plenty of powerful tools for experienced users such as Visual Database Designer, Visual Query Builder, and powerful Blob editor to satisfy all their needs.

EMS SQL Manager 2007 Lite for Oracle has a state-of-the-art graphical user interface with a well-described wizard system, so clear in use that even a newbie will not be confused with it.

Major Features:

1. Latest Oracle Database version support
   • Support of the latest server versions from 8.1.7 to 11g
   • Support of compressed tables, OLAP tables, read-only/read-write tables, virtual columns
   • Support of invisible indexes
   • Support of compound triggers, triggers with FOLLOWS clause
   • Powerful and easy management of object permissions, including column-level permissions
   • Support of Unicode data
2. Rapid database management and navigation
   • Multiple database connections
   • Schema restriction to see only required schemas
   • Projects to work with the selected database objects only
   • Multiple user-defined tabs for any tree node to access it in one-click
   • Working with multiple selected objects at a time
   • Grouping/Ungrouping registered databases
3. Powerful tools to make your work with Oracle Database as easy as it can be
   
   • Database Information to get all information on database instance and NLS parameters
   • Extracting metadata into text files or SQL Script Editor
   • Client Checker to check the validity of Oracle client and provide common information on client settings
4. Simple management of all Oracle Database objects (including create/edit/drop operations)
   • Managing tables and all their subobjects: fields, primary, unique and foreign keys, indices, triggers, and check constraints
   • Managing views and all their subobjects: fields, triggers, primary, unique and foreign keys
   • Managing procedures, functions, sequences, packages and package bodies
   • Managing users, roles, profiles, consumer groups and resource plans
   • Managing database and schema triggers, clusters, synonyms, database links, materialized views and materialized view logs
   • Managing object and array types, object type bodies, libraries
   • Managing java sources, resources and classes
   • Managing index types, operators, dimensions
   • Managing contexts, directories, table spaces, rollback segments, redo log groups
   • Duplicating database objects
   • Viewing dependencies between database objects
5. Effective security management
   • Grant manager displaying all database object grants in the form of a grid
   • Ability to set permissions for table columns
   • Easy management of database users, roles and profiles
   • Viewing and changing object permissions in object editors
6. Advanced data manipulation tools
   
   • Plenty of useful tools such as data grouping, summarizing, fast searching and filtering
7. Excellent visual and text tools for query building
   • Large script executing (SQL script editor)
   • Favorite Queries (Save and use your frequently used queries easily)
8. New state-of-the-art graphical user interface
   • Office 11 and Windows XP visual schemes support
   • Well-described Wizard System
   • Improved database explorer for easy management of all Oracle objects
   • MDI and floating-window styles implementation
   • Windows Toolbar to switch between windows easily, like in Windows Task Bar
   • Navigation bars with hot actions in most of the windows
   • Ability to save all program settings
   • Customizable toolbars for all program windows
   • Fully customizable program interface
   • Powerful Visual Options module
   • Localizable program interface
9. And other useful features
   • Keyboard templates
   • To-do list
   • External tool manager

Requirements:

• 300-megahertz (MHz) or higher Pentium II-compatible processor; 600-MHz or faster processor recommended
• Microsoft Windows NT4 with SP4 or later, Microsoft Windows 2000, Microsoft Windows 2000 Server, Microsoft Windows XP, Microsoft Windows 2003 Server, Microsoft Windows Vista
• 64 MB RAM (128 MB or above is recommended)
• 50MB of available HD space for program installation
• Super VGA (800x600) or higher-resolution video adapter and monitor; Super VGA (1024x768) or higher-resolution recommended
• Microsoft Mouse or compatible pointing device
• Oracle Client 8.1.7 or higher
• Local or remote Oracle Database Server 8.1.7 or higher
• Supported Oracle server versions: from 8.1.7 up to 11.1.0