Move the SQL database

Follow the steps in this section to back up the existing database on your existing SQL Server computer and then restore it to the new SQL Server. Specific instructions for backing up and restoring databases are not provided here; refer to the Microsoft SQL Server documentation for instructions for your software version.

1. Create a backup of the current SQL database.

   The default name for the SQL database is pigeoportal; however, it is possible that the database was renamed. Ensure that you back up the correct database.

2. Make note of the security permissions for the database. You can find the permissions by right-clicking the SQL database and then selecting Properties. The security permissions can then be found under Permissions. Note the user or service account that has access to the database and also the database role membership.

   You can verify that the account you obtained in this step is the same as that used by PI Integrator for Esri ArcGIS. Open Windows Services and note the Log On As account for the PI Integrator for Esri ArcGIS service.

   Note that the Application Server Identity might change depending on whether you move both the Application Server and the associated SQL database, or move just the SQL Server alone.

3. Restore the SQL database to the SQL Server on the new server hardware.

4. On the new SQL Server, create a login for the PI Integrator for Esri ArcGIS Windows service account from step 2.

5. Grant the database owner privilege to the login from step 4.

6. If PI Integrator for Esri ArcGIS is not being moved to a new computer, modify the OSIsoft.PIGeoServices.SelfHost.exe.config file to reflect the change to the new SQL Server. To do this:

   1. On the PI Integrator for Esri ArcGIS node, open the OSIsoft.PIGeoServices.SelfHost.exe.config file found in %ProgramFiles%/OSIsoft/Integrators/Esri ArcGIS.

   2. In the configuration section of the XML file, update the connection string to reflect the new SQL Server name.