EMS SQL Management Studio for Oracle

EMS SQL Management Studio 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!

SQL Management Studio for Oracle components
• SQL Manager for Oracle - Simplify and automate your Oracle database development process, design, explore and maintain existing Oracle databases, build compound Oracle SQL query statements, manage Oracle database user rights and manipulate data in different ways.
• Data Generator for Oracle - Generate test data for Oracle database for testing purposes in a simple and direct way. Wide range of data generation parameters, user-friendly wizard interface and useful console utility to automate Oracle test data generation.
• Data Pump for Oracle - Migrate from most popular databases (MS SQL Server, MySQL, PostgreSQL, DB2, InterBase/Firebird, etс.) to Oracle. Convert database schema and import table data to Oracle database from any ADO-compatible source.
• Data Import for Oracle - Import data to Oracle database tables from MS Access, MS Excel, CSV, XML and other popular formats via user-friendly wizard interface.
• DB Extract for Oracle - Create Oracle database backups in the form of SQL scripts, script and save your Oracle database structure and table data as a whole or partially.
• SQL Query for Oracle - Analyze and retrieve your data, build your Oracle queries visually, work with Oracle query plans, build charts based on retrieved data quickly and more.
• Data Comparer for Oracle - Compare and synchronize the contents of your Oracle databases. Automate your data migrations from development to production database. Customize the Oracle comparison and synchronization process to suit your needs.
• DB Comparer for Oracle - Compare and synchronize the structure of Oracle databases. Move changes on your development database to production with ease.
• Data Export for Oracle - Export Oracle database data to any of 20 most popular data formats, including MS Access, MS Excel, MS Word, PDF, HTML, ODF and more.

SQL Studio Additional Features
• Handy launch of utilities and services
• Storing all templates in a single repository
• Common data source list for all services and utilities
• Creating complicated tasks and scheduled tasks execution
• Ability to run external applications from scheduler
• Storing all task execution logs in one database
• Creating customized notifications with a variety of delivery options
• Ability to set visual interface style uniquely for all SQL Studio apps
• Fast access to EMS Technical Support Service

	SQL Manager for Oracle EMS SQL Manager for Oracle is a powerful graphical database tool for Oracle Database development and administration.		Data Generator for Oracle Generate test data for Oracle database for testing purposes in a simple and direct way.
	Data Pump for Oracle Migrate from most popular databases (MS SQL Server, MySQL, PostgreSQL, DB2, InterBase/Firebird, etс.) to Oracle.		Data Import for Oracle Import data to Oracle database tables from MS Access, MS Excel, CSV, XML and other popular formats via user-friendly wizard interface.
	DB Extract for Oracle Create Oracle database backups in the form of SQL scripts, script and save your Oracle database structure and table data as a whole or partially.		SQL Query for Oracle Analyze and retrieve your data, build your Oracle queries visually, work with Oracle query plans, build charts based on retrieved data quickly and more.
	Data Comparer for Oracle Compare and synchronize the contents of your Oracle databases.		DB Comparer for Oracle Compare and synchronize the structure of Oracle databases.
	Data Export for Oracle Export Oracle database data to any of 20 most popular data formats, including MS Access, MS Excel, MS Word, PDF, HTML, ODF and more.