EMS SQL Manager Lite for DB2 free download, EMS SQL Manager Lite for DB2 download on software download

EMS SQL Manager for DB2 is a high performance tool for DB2 database server administration and development. This application can support numerous DB2 objects as well as all DB2 data types. 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. SQL Manager 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: 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 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 packages Managing global variables Managing event monitors Managing servers and wrappers Duplicating database objects Viewing dependencies between database objects 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 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 Grant manager displaying all database object grants in the form of a grid Easy management of database users, groups and user mappings Support of LBAC (Label Based Access Control) Possibility to work with private contexts, security policies, audit policies and roles 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 Back up and restore database Rollforward 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 Support of DB2 server versions from 8.1 to 9.5 Support of most DB2 server platforms (LUW, z/OS, etc.) Extracting metadata into text files or SQL Script Editor SQL Monitor Dependency tree tool allows to view dependencies between database objects Keyboard templates External Tools editor To-do list

EMS SQL Manager Lite for DB2 Related Software