EMS logo

Products Navigation

SQL Manager for Oracle

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Manager for Oracle

Product FAQs

Table of contents

Q:
What is the difference between Full and Freeware versions of EMS SQL Manager for Oracle?
A:
These editions of SQL Manager for Oracle differ in their functionality. Being a light edition, SQL Manager Freeware has certain restrictions, for example, the maximum size of registered databases should not exceed 4 GB, and some others. You can view the list of all functional differences between full and freeware versions at our Features Matrix Page.
Q:
What is EMS SQL Manager for Oracle?
A:
EMS SQL Manager for Oracle is high performance database tool for Oracle administration and development. It has an easy-to-use graphical interface and allows you to create/edit all Oracle database objects in a simple and direct way, design Oracle databases visually, run SQL scripts, import and export Oracle database data and provides you with a number of other useful services that will make Oracle management as easy as it can be.
Q:
What do I need to start working with EMS SQL Manager for Oracle?
A:
First of all you must have an opportunity to connect to some local or remote Oracle server. Besides you need your computer to satisfy the system requirements of EMS SQL Manager for Oracle.
Q:
What is the difference between the Export/Import functions in EMS SQL Manager for Oracle tool and EMS Data Export/Import for Oracle utilities?
A:
EMS Data Export/Import for Oracle includes some additional features, which are not available in SQL Manager for Oracle such as:
  • export/import data from/to several tables at once;
  • export/import data from/to tables selected from different databases on one host;
  • command line utility to export/import data using the configuration file with all the export/import options.
Q:
What is the difference between the Query Builder module in EMS SQL Manager for Oracle tool and EMS SQL Query for Oracle utility?
A:
First of all, EMS SQL Query for Oracle works faster as it is a much lighter product. Besides it provides additional features for query building, e.g.:
  • keeping query history, which allows you to rollback to any edited query;
  • various interface improvements for more productive and easy work.
Q:
What is the difference between the Extract Metadata function in EMS SQL Manager for Oracle and EMS DB Extract for Oracle utility?
A:
EMS DB Extract for Oracle includes some additional features, which are not available in EMS SQL Manager for Oracle, such as:
  • extracting metadata from several databases on one host;
  • console application for executing extract in one-touch;
  • faster execution speed;
Q:
I can‘t modify DDL. Why?
A:
The DDL tab of all object editors is read-only. It displays object structure as SQL text and reflects the operations you perform over the object on other editor tabs. To modify this text, you can copy it to the clipboard and edit it using the SQL Script Editor.
Q:
I can't configure the connection to Oracle server via SSH. What parameters should I define in the Database Registration Info dialog?
A:
You need to input the following:
  • In the Connection section:
    • User name is an Oracle user name.
    • Password is password of the Oracle user.
  • In the SSH Tunneling section:
    • SSH host name is a host where SSH server is activated.
    • SSH port is a port where SSH server is activated.
    • SSH user name is a user on Linux machine. (It is a Linux user. It is not a user of Oracle server.)
    • SSH password is a Linux user password.

To connect to Oracle server that is installed on Windows machine, it is necessary to disable Oracle port redirection by entering the registry entry 'USE_SHARED_SOCKET = TRUE' in the Windows registry under the HKLM\Software\Oracle branch. Also, connection by SSH should be established by using local naming method (using tnsnames.ora).
Q:
When I create database objects, their names are always converted to upper case. How I can prevent it?
A:
You need to switch off the “Convert created objects’ names to upper case” option in Environment Options dialog.
Q:
How can I create a report?
A:
To create a report you can use the Create Report Wizard ("Create" → "Report") or Report Designer Tool ("Tools" → "Report Designer"). To create a simple report based on a query you need to choose "Master Data" on the second step of the wizard, double-click on it and specify the query for your report. After that you need to tune the remaining options on subsequent steps of the wizard and press Finish.
Q:
I need to perform some changes in database objects of my test database and then make the same changes on master database. Are there any tools for this purpose in EMS SQL Manager for Oracle?
A:
Database Registration Info dialog contains Log tab where you can enable logging metadata changes, which are performed on a database, and SQL statements, that are executed in SQL Editor.
Q:
I’m trying to export a table, but TEXT fields are not exported.
A:
Fields of types BLOB, CLOB, NCLOB, BFILE, LONG, LONG ROW and XML are not exported by default. You should select these fields manually on the Fields tab.
Q:
What is the difference between the “Extract Database” and “Export As SQL Script” functions?
A:
“Export As SQL Script” is intended to export table data that will be inserted into a database system other than Oracle Database (DB2, InterBase, SQL Server, MySQL, PostgreSQL). Use “Extract Database” to copy data to a table on Oracle Database.
Q:
How do I change the default directory where exported data will be saved?
A:
Follow the steps below to change the default directory:
  • Right-click the database alias in the DB Explorer and select the 'Database Registration Info...' context menu item (you can also find this item in the 'Database' main menu) to open the Database Registration Info dialog.
  • Proceed to the Directories section within the dialog.
  • Then set the default directory for the exported data.
Q:
How can I customize data formats in a grid?
A:
You can customize all display formats: integer, float, date, time and date/time in the Environment Options window in the Grid | Color & Formats section.
Q:
Is it possible somehow to restore my database queries/settings/registrations from the old or faulty HDD, where SQL Manager was installed?
A:
SQL Manager stores all your settings in the Windows registry. It means that the only way to transfer your database data is to get access to the Windows registry. You can do it by loading OS from your old HDD (if possible) or by opening the registry file with a special editor program. If you managed it, you can unload the 'HKEY_CURRENT_USER\Software\EMS\Oracle Manager' branch to the *.REG file, transfer this file to a new system and add information to the registry by double-clicking the file.