The following is checklist for the creation process of a Workgroup Database in Oracle.
- Download the appropriate database and role creation scripts (Ora_create.sql and Ora_roles.sql) from the Autodesk website (or from the InfoWorks Workgroup Server installation directory for versions prior to 8.0). Make sure that you have the correct scripts for your application. Either:
- ICM/ICMLive/InfoNet
- WS Pro/IWLive Pro/DemandWatch Pro
- Open the Ora_Create.sql script in a text editor.
- Find the line near the end of the script, which starts: INSERT INTO global …
- Replace the default database identifier “SQL_INNOVYZEWG00” to a unique value. This will normally be the last argument in the INSERT statement.
- Open the Ora_Roles.sql script in a text editor.
- Replace the string “CHANGETHIS” with the name of the database Table Owner (as specified in the master.ini file).
- Replace the string “INNOVYZEUSER” with the name of the database User (as specified in the master.ini file).
The following steps are usually carried out using Oracle SQLPlus.
- Log in to Oracle as the Table Owner for the database.
- Run the Ora_create.sql script.
- Run the Ora_Roles.sql script.
- Ensure that the database transactions are completed.
- Check that all instructions ran without errors and that the global table has a single row (select * from global).
On the machine running the InfoWorks Workgroup Server:
- Create an empty folder in the Data Store directory, using a database name suitable for end users. Ensure that the folder name ends with “.sndb”, so that it is identified as a database folder to the InfoWorks Workgroup Server.
- Create the master.ini file within this folder (see earlier in this document for how to do this).
- Clients should now be able to connect to this database in the usual manner.