The side effect of having FME database on a separate server is that it must be rebuilt at every upgrade. The provided drop/createUser/DB/Schema is not bad but the process of the FME database rebuild could make life easier with a couple of improvements (which are possible in all SQL Server/Postgresql/Oracle):
- In addition to dropDB/dropUser an emptyDB which drops all the database objects in the createDB/Schema script but not the database itself would save the user management and would require less privileges.
- Using variables in the createDB script eg. create the db or not, starting value of job_id, etc
