SQL Management Studio 2011 for Oracle 1.2.0.8

EMS SQL Management Studio 2011 for Oracle is a complete solution for Oracle database administration and development.

SQL Management Studio 2011 for Oracle 1.2.0.8

EMS SQL Management Studio 2011 for Oracle is a complete solution for Oracle database administration and development. With components that focus on all critical Oracle database management tasks, SQL Studio is a single workbench that provides you with must-have tools for administering Oracle databases, managing database schema and objects as well as for Oracle database design, migration, extraction, Oracle query building, data import, export and database comparison.

SQL Studio unites these database tools for Oracle in one powerful and easy-to-use environment that can work round the clock. With SQL Management Studio many database administration objectives, such as migration, data loading and synchronization, database backup and extraction can be automated, allowing Oracle database administrators and Oracle application developers to perform complex tasks on a regular basis with the minimum number of efforts and a high level of flexibility.

Whether you are a database or application developer, DBA or business analyst, SQL Studio for Oracle offers all essential Oracle tools to make you more productive than ever before!

FEATURES:

Basic features:
TE Support of Oracle versions from 8.2 to 10.2
TE Simple management of all Oracle objects (including create/edit/ drop operations)
TE Easy-to-work integrated environment uniting all SQL Studio capabilities

DB registration and connection:
TE Multiple home/database connections
TE Connection to Oracle Server through SSH
TE Registering selected databases to work with
TE Grouping/Ungrouping registered databases
TE Single repository for all DBs registered with EMS Software Development applications.

DB management:
TE Back Up any registered database
TE Restore previously backed up database
TE Powerful job manager to administer jobs
TE Grant manager displaying all database object grants in the form of a grid

Data manipulation:
TE View, edit, search, group, sort, filter any data stored in registered database
TE Export data in many formats (MS Excel, MS Word, HTML, PDF, TXT, CSV, DBF, XML, etc.)
TE Export data stored in different DBs in a single operation
TE Import data from many sources (MS Excel, DBF, TXT, CSV, XML, MS Access)
TE Import data from different sources to different DBs in a single operation
TE Convert database structure and data from OLE DB/ODBC data sources
TE Generate test data to several database tables at the same time
TE Console versions for all data manipulation utilities

Data Analysis:
TE DB comparison and synchronization ability
TE Data comparison and synchronization ability
TE Console versions for all data analysis utilities

Template management:
TE Create new templates for SQL Studio utilities
TE Edit existing templates for SQL Studio utilities
TE User friendly template manager. Fast access to the needed template.
TE Launch the utility for the selected template in one click

Scheduler:
TE Scheduled execution of data manipulation tasks (Import, Export, etc.)
TE Scheduled execution of any external applications
TE Creation and execution of complex tasks
TE Storage of logs for executed tasks
TE Flexible system of task execution results notifications (e-mail, net send, Application Log)

Log management:
TE Storage of logs for applications run by Scheduler
TE Ability to search, view, delete, export existing logs

Report designer:
TE New Create Report Wizard allows you to create simple reports in a few clicks
TE Managing reports the same way as if they were database objects: accessing reports directly through DB Explorer tree

Other tools:
TE Extracting metadata and data into text files or SQL script editor
TE Extracting metadata and data from different DBs in a single operation
TE Console version of Extract metadata tool
TE Powerful print metadata module for creating customizable metadata reports
TE HTML report generator to create a detailed HTML report about your database quickly
TE SQL Monitor
TE SQL Query
TE Saving favourite queries
TE Saving query history
TE Ability to create diagrams based on queries
Release notes: New Release
TE The Task Scheduler can now be launched as a Windows Service or a separate process.
TE If a custom task is launched manually, its execution process can be tracked in the special window.
TE Backup/restore services are now available in SQL Studio for PostgreSQL.
TE The SSH or HTTP connection type is now displayed within the host name field.
TE Toolbar settings used to be reset after the program shutdown. Fixed now.
TE The possibility to open PDF documentation from the main menu is implemented.
TE Other small improvements and bug-fixes.
[ SQL Management Studio 2011 for Oracle full changelog ]

   



Top Software

New Software

Top Search

Latest Reviews