WFM DB scripts for Oracle DB

[KG]

Hi All,

We have just downloaded and ran exe file of Database Utility for WFM.

Once DBU is installed, we can see Scripts in DBU folder for Oracle.

But in the script we are finding the sql commands to insert into the existing DB but for creating new DB, no data is found like DB  schema and Create DB sql commands etc.

Please guide how or where to download the scripts for creating the DB for Oracle in WFM.


Thanks in Advance.

Regards,
KB

[Kubig]

BRU tool will do the database schema based on your configuration (of course, the DB user has to be created before running BRU).

[KG]

Thanks Kubig!

And Im posting the same reply here.

We have downloaded the DBU and installed.

DBA is asking for the scripts for the new DB.

But we are finding only INSERT commands in the Scripts for Oracle.

where do we find the scripts for creating the schema?

[Kubig]

The scripts should be located under install folder of BRU, folder "scripts".

[KG]

Hi, Im finding the Scripts in DBU folder.

But under Backups, finding only [b]BRUtil.wfm file[/b]

[b]C:\Program Files (x86)\GCTI\WFM85\Database Utility\Scripts

C:\Program Files (x86)\GCTI\WFM85\Database Utility\Backups
[/b]

In script folder, there are multiple .sql files including for Oracle.

In that sql file, Im not finding the commands to create the DB schema for a new Database.

[Kubig]

As I said, the schema itself has to be created by your DBA, it will not be created by the app automatically.

[KG]

But the DBA is asking for the Scripts.

And if we give the Scripts that is present in Intallation Package under DBU, it contains insert commands and create table commands.

But not the commands for creating the schema.

[Kubig]

There is no scripts to create schema at all. Just tell your DBA to create standard DB schema with appropriate user (required permissions you can find in documentation) and then use the provided scripts.

[KG]

Thank You Kubig.