Importing Time Zone Information

On rare occasions, you might need to update the APM database with the latest time zone data, for example, to capture changes when countries opt out of daylight saving time. APM provides a utility that downloads the latest data from Nodatime.org.

Note: The new information affects only future date calculations. No existing APM data is altered.

To use the Time Zone Import Utility, you need:

•	Access to the server machine running APM and the installation folder

•	Internet connection

•	Valid connection string or data source name for the database

•	User name and password for the database

The utility supports APM SQL Server, Oracle, and SQL Azure databases.

To Run the Time Zone Import Utility

1.	Navigate to the bin folder, normally found here:

<InstallDirectory>\Bentley\AssetWise Performance Management\bin

2.	In the bin folder, locate the utility:

Bentley.APM.Upgrade.TimeZone.exe

3.	Double-click the .exe file to open the utility:

4.	Either enter a value in the Connection String field or select a data source in the DSN list.

5.	Enter the user name and password for the database.

6.	Click Connect. When the utility successfully accesses the APM database, “Not Connected” is replaced by “Connected”, database information is added to the dialog, and the Upgrade button is enabled. For example:

7.	Click Upgrade. A progress bar shows the upgrade process.

8.	When the upgrade has completed, close the dialog.