xSQL Schema Compare Command Line for Oracle Databases > Specifying Oracle connections |
The wizard source and target connection steps allow you to specify the settings to be used for the source and target connection. The command line uses the same connection settings as the user-interface of the schema compare. For more details on the Oracle connection settings, see the Adding Oracle Connection topic.
![]() |
Even though we refer to connections as the "source" or "target", the command line can switch them, so the source can become the target and vice versa. See the command line settings for details on settings the source connection and the target connection. |
Below is the a typical xml fragment, generated by the wizard, that contains the connection settings:
<LeftConnection>
<ConnectionName>Source Schema</ConnectionName>
<!-- ***** basic connection settings ***** -->
<Host>host-name-or-ip</Host>
<Service>service-name</Service>
<Username>HR</Username>
<Password>**********</Password>
</LeftConnection>
<RightConnection>
<ConnectionName>Target Schema</ConnectionName>
<!-- ***** basic connection settings ***** -->
<Host>host-name-or-ip</Host>
<Service>service-name</Service>
<Username>HR_TARGET</Username>
<Password>**********</Password>
</RightConnection>