Creating and Updating a Microsoft Server SQL or Oracle Workgroup Database

The purpose of this post is to provide users who plan to use or currently use Microsoft SQL Server or Oracle databases for InfoNet and/or InfoWorks ICM with the resources they need to initially create and/or update their database to a new version.

It must first be mentioned that Innovyze does not recommend using Microsoft SQL Server or Oracle rather than the Standard Workgroup Database for InfoWorks ICM and/or InfoNet. Utilizing SQL or Oracle is a matter of customer preference. The Standard Database is designed to provide the best performance with the minimal configuration for the supported Innovyze Workgroup products. If it is preferred to utilize a Microsoft SQL Server or Oracle Workgroup Database, there is a great deal of information provided in the Workgroup Data Server Administration document:

http://innovyze.com/updates/documents/WorkgroupDataServerAdministrationNov2017.pdf

To access the most recent Workgroup Data Server Administration document, you may find it at www.innovyze.com/updates in the same location where the Workgroup Client (InfoNet and ICM) is downloaded.

In order to utilize SQL or Oracle databases, there will need to be a DBA (Database Administrator) in place who is experienced in managing these servers and applying scripts as these are operations that are not guided or performed by Innovyze Support.

Details for initially setting up communication between the Workgroup Data Server and a Microsoft SQL Server or Oracle Database are outlined in the Workgroup Data Server Administration document. Also required for the initial setup is a “create script” that the DBA will need to create the Database.

If the Oracle or Microsoft SQL Server database is already in use and the software is being updated to a newer version, then the DBA will need to apply one or more “update scripts.”

The aforementioned scripts can be found at www.innovyze.com/updates when InfoWorks ICM or InfoNet is selected from the list of products and you are logged in with your company’s login credentials:

Note that an update script must be applied for each major release. For example, if the database is being updated from Workgroup Client version 7.5 to 9.0, an update script would be applied to update v7.5 to v8.0, then v8.0 to v8.5, then v8.5 to v9.0. If you require several update scripts, then after clicking on the Scripts link shown above, click on ‘Previous Downloads’ to access all update scripts:

If the required update scripts cannot be located at the website mentioned above or if you need to obtain your company’s login credentials, please email support@innovyze.com with your request.

Share this post!
    This entry was posted in InfoNet, InfoWorks ICM and tagged , , , , , . Bookmark the permalink.