Import a configuration

Important: The Historian Database Export/Import Utility offers considerable flexibility for modifying the contents of the Runtime database. However, after an import is complete, there is no rollback or "undo" capability. It is highly recommended that you make a backup of the Runtime database before performing an import.

To import configuration information

Note: If importing a database file from Historian SP2023 R2 or earlier with saved content or dashboards, an error will occur. Update the Historian from which the file is being exported to SP2023 R2 P01 or later.

1. From the Windows Start menu, expand AVEVA Historian, and then click Configuration Export and Import. The Historian Database Export/Import Utility Wizard displays.

   

2. Select Import from a text file to Historian.

3. Click Next. The Connect dialog displays.

   

4. In the Server name box, type the node name of the computer hosting AVEVA Historian for which you want to import configuration information.

5. Provide a login for the Historian.

   • Select Use Windows authentication to use your Windows logon account to connect to the AVEVA Historian.

   • Select Use SQL Server authentication to use a SQL Server login. Enter a valid SQL Server username and password.

     Important: SQL Server authentication is provided for backward compatibility only. For improved security, we recommend that you use Windows authentication.

6. In the File name box, type the path for the text file to import, or click the ellipsis button to browse to the location.

7. Click Next. The Confirm dialog box appears.

   

8. Click Next to start the import.

   Notes: If you are importing a text file that includes one or more delete mode indicators, the utility prompts you to verify each entity to delete, unless you select to turn off subsequent delete warnings. If you import a text file that includes IDAS configuration information, existing remote IDAS connections may fail. See Troubleshoot IDAS connections for more information.

9. The Status dialog box displays, showing the results of the import. The number of objects imported is reported.

   

10. Click Finish to exit the wizard.