Before comparing Oracle schemas, you need to add Oracle connections to the workspace. The IDERA Data Compare Add Connection functionality can be accessed from the ribbon (the Home tab) or from the Add Oracle Connection action link at the top left section of the Workspace tab.
On the Add Connection window, you can specify:
In the Basic Settings tab, you can choose the connection type and specify settings required by the connection. There are four connection type you can choose from:
username/password@[//]host[:port][/service_name]
. Because username and password are already included in the easy-connect string, the credential specified at the top section of the Add Connection form is ignored when the easy-connect option is selected. (DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)(Host = <hostname>)(Port = <port>)))
(CONNECT_DATA = (SERVICE_NAME = <sid>))
)
In the Advanced Settings tab you can specify:
The Test Connection link allows you to verify whether the settings are correct and the connection to Oracle database can be established. You can add Oracle connection to the workspace by clicking OK.
By default, all Oracle connections use the advanced settings specified in the Application Settings.
| | | | | | | |