When migrating from a source system in one timezone to a target system in a different timezone, migration-center converts the DateTime values deppending on some factors.
Note that the following connectors do not convert the date values on scan or import: OpenText connectors and the Database scanner.
DateTime values are converted when an object is scanned from source or imported into target based on the Timezone set on the Jobserver machine (windows or linux).
(the SharePoint scanner is a special case and has a dedicated section in this article)
Suppose the following example:
The Source system is located in Portugal, West European Time zone WET (=UTC).
The migration-center's job server is located in Germany, Central European Time zone CET (=UTC+1).
The Target system is located in Finland, Eastern European Time zone EET (=UTC+2).
A Documentum scanner would convert the WET timezone into CET timezone and store the values in the MC database. (adds 1 hour)
A Documentum importer would convert the CET values from the database into EET values before saving them in the target system. (adds 1 hour)
|Source System Date||Date saved in MC database||Target System Date|
|12.06.2017 15:00:00 WET||12.06.2017 16:00:00 CET||12.06.2017 17:00:00 EET|
|11.06.2017 23:00:00 WET||12.06.2017 00:00:00 CET||12.06.2017 01:00:00 EET|
- Different job servers are used for scanning and importing and they are located in different time zones. If this is the case, please ensure that all job servers used in that particular migration have the same time zone setting.
- Either source or target system is OpenText or database. In this case, please set the job server's time zone to the time zone of the OpenText or database system.
- Source and target systems are OpenText or database, i.e. migration from database to OpenText or from OpenText to OpenText. Unfortunately, this case is currently not supported by migration-center. Please contact our product support to discuss possible solutions for this case.
The SharePoint scanner consists of two parts: a WSP part that is installed on the SharePoint server and a Java part that is in the migration-center Jobserver.
The WSP part will read date time values with the time zone settings in SharePoint's regional settings, for example West European Time in the example above. Unfortunately, the Java part of the SharePoint scanner always expects date time values in UTC. Therefore the time zone on the job server must be set to Coordinated Universal Time (UTC). This will ensure that the scanner saves the correct date time values in the migration-center database.