Content Comparison

All ServiceOptimizer processes require the database connection details to be supplied on the command line, in one of the following forms: 

[

...

   [

...

 <dbUser>/<dbPassword>[@<dbHost>]                              

...

   ] |

   [ORACLE:<dbHost>:<dbUser>:<dbPassword>                          

...

   ] |

   [MSSQL:<dbServer>[\<dbInstance>]:<dbName>:[<dbUser>]:[<dbPassword>]]

]

...

The first and second variants are Oracle only; the third is SQLServer MS SQL Server only.
If there is no password configured in the SP database then the dbPassword is also used to authenticate the database password supplied by an SP client (such as ServiceManager or the GanttServiceGANTT).
Default Oracle dbHost is environment specific (specified for example by LOCAL or TWO_TASK environment variables).
The SQLServer MS SQL Server dbInstance is only required if you are connecting to a named instance.
If SQLServer MS SQL Server dbUser is not specified, the connection to SQLServer MS SQL Server will be made as the trusted user (i.e. the OS operating system user). dbPassword is then not used to authenticate SP's own the ServiceScheduling connection to the database.