HDBSETUP using -noprompt
Problem: Executing hdbsetup -cr option with -noprompt fails.
The undocumented -dvr option is required else the execution will fail.
Solution: I tested this scenario with R12.5 against a sql server database using the following params:
Since I already had an existing "harvest" dsn and "harvest" database instance, I used "harvest2"
to run the test to create a new harvest2 database instance.
Note that -dvr= was required, this is not documented in the Implementation Guide.
hdbsetup -cr -s -svr=MyHarvestSqlServer -conmethod=Sqlserver
-dvr="SQL Server Native Client 10.0" -dsn=harvest2 -dbn=harvest2
-ausr=sa -apwd=******** -husr=harvest -hpwd=******** -noprompt
Results were successful in the hdbsetup.log as follows:
---------------------------------------
CA Harvest Software Change Manager
Database Config Utility
---------------------------------------
6/3/2015 3:50:24 PM
[Create SCM Repository]
Checking if user harvest exists...
Connected to SQLSERVER as user [sa]
User exists
Creating Database: harvest2...
Connected to SQLSERVER as user [harvest]
Database harvest2 created
Loading database schema...
Load Model Database dump into [harvest2] owned by [harvest]...
Database schema loaded
SCM repository creation completed
6/3/2015 3:50:56 PM
--------------------------
Database config complete
--------------------------