Installing the SDB Merge Tool - Intergraph Smart Reference Data Standard Database - Version 12.4 - Installation & Upgrade - Hexagon

This section describes hosting the ‘SDB Merge Tool’ web application in a web server using IIS (Internet Information Services) Manager.

Configure IIS Settings for Windows Server 2019

To configure the IIS setting for Windows Server 2019, follow the steps below:

1. Open the Windows 2019 Server Manager as administrator.

2. Select Local Server.

3. Select Add Roles and Features from the Tasks list to launch the Add Roles and Features Wizard.

4. Click Installation Type and select Role-based or feature-based installation.

5. Click Next.

6. Click Next on the Server Selection window.

7. Select Web Server (IIS) from the Roles list.

8. Click Add Features on Add Roles and Features wizard and click Next.

9. Select HTTP Activation under the node .NET Framework 4.7 Features > WCF Services in the Select Features window.

10. Click Add Features on Add Roles and Features wizard and click Next.

11. Select Restart the destination server automatically and click Yes to restart if required by the system.

12. Click Install to complete the IIS installation.

13. Once the features are installed, click Close.

For more information for configuring IIS, see Configure IIS Settings for Windows Server 2019.

Install Oracle Client

Install the Oracle client version V982658-01.

1. Open the Client folder and double-click setup.exe.

2. Select Administrator and click Next.

3. In the Select Product Languages window, select English, and click Next.

4. In the Oracle Home User Selection window, select Use Windows Built-in Account, and click Next.

5. Click Next.

   If you want to change the Oracle base or software location, click Browse and select another directory.

6. In the Summary window, click Install.

7. When the installation is finished, click Close.

8. Change the registry setting NLS_LANG for the Oracle Client home to AMERICAN_AMERICA.AL32UTF8 (where AL32UTF8 is the character set of the database).

Register 19c Oracle.DataAccess.dll and Oracle.DataAccess.EntityFramework.DLL

After you install Oracle client, you must manually register Oracle.DataAccess.dll and Oracle.DataAccess.EntityFramework.DLL to Global Assembly Cache (GAC).

1. Click Start > All Programs > Accessories.

2. Open Command Prompt as Run as administrator.

3. Type the command to access the ODP.NET folder which is in the Oracle installation location.

   Example: >CD <Oracle installation folder>\product\19.0.0\client_1\ODP.NET\bin\4

   

4. Type the command, oraprovcfg /action:gac /providerpath: <Oracle installation folder>\product\19.0.0\client_1\ODP.NET\bin\4\Oracle.DataAccess.dll

   

   Repeat the same for Oracle.DataAccess.EntityFramework.DLL

5. Type the command, oraprovcfg /action:gac /providerpath<Oracle installation folder>\product\19.0.0\client_1\ODP.NET\bin\4\EF6\Oracle.DataAccess.EntityFramework.dll

   

Installation Steps

1. Open the command prompt with administrator privileges.

2. By default, application pool for web applications will be set to DefaultAppPool. Users must create a new application pool for SDBMerge during first time installation.

   Use the command below to create a new application pool.

   %systemroot%\system32\inetsrv\APPCMD add apppool /name:SDBMerge

3. Run the command below for replacing SDBInstallDirectory with your installation directory:

   %systemroot%\system32\inetsrv\APPCMD add app /site.name:"Default Web Site" /path:"/SDBMerge" /physicalPath:"<SDBInstallDirectory>\SDBMerge" /applicationPool:SDBMerge

   To delete the SDBMerge application from IIS, run the command below.

   %systemroot%\system32\inetsrv\APPCMD delete app "Default Web Site/SDBMerge"

4. Provide Read/Write Permissions for "IIS_IUSRS" on the "Exports" folder under "<SDBInstallDirectory>\SDBMerge".

5. Provide Read/Write Permissions for "IIS_IUSRS" on the "Logs" folder under "<SDBInstallDirectory>\SDBMerge".

6. Merge Tool is a web-based tool. it can be accessed using the web URL after hosting successfully.

   Default URL: http://<servername>/SDBMerge/Index.html. servername specifies the computer on which web application is hosted.

SDB Migration Steps

Upgrading SDB 12.2/ SDB 12.3 database to SDB 12.4

Standard Database for Intergraph Smart Reference Data 12.3 upgrade is certified and supported for the following paths:

• SDB 12.2 to SDB 12.3 with SRD 10.2 SP 9

• SDB 12.3 to SDB 12.4 with SRD 10.2 SP 9

The upgrade process from SDB 12.2 / SDB 12.3 version to SDB 12.4 is described in SDB Migration Process.