File migration validation

Final validation of migrated files

The verification results are applied to the internal database view migrated_files.

What the verification process do:
Verify the file existence on both source and destination.
Compare the timestamps (the column `[Modified]`). Verification results: `ExistIdentical, ExistOlder, ExistNewer, NotExist, Error` are applied to the columns: `[verify_source_result]` , `[verify_destination_result]`

How to set up the process of Final validation is as follows:
in a DataETL/For-Each Step select `Internal database` source and the database view `migrated_files`.
Set your filter/criteria for what `file copy actions` you want to verify.
Select the scope for the verification action you want to perform.
Run the Step

Column	Purpose
verify_destination_datetime	Timestamp for when the destination file existence was verified and the `[Modified]` columns compared with the session log data
verify_destination_result	Values: `ExistIdentical , ExistOlder , ExistNewer , NotExist , Error`
verify_destination_message	The value `Ok` or the error message returned form the destination FileShare or SharePoint site during validation.
verify_destination_library	The destination SharePoint Document Library URL. If the source is FileShare then this column is blank.
verify_metadata_datetime	Timestamp for when the destination metadata was verified with the information in the session log
verify_metadata_result	The values `Identical , Mismatch` or the validation mismatches i.e. the column names and values that are not identical
verify_metadata_message	The value `Ok` or the validation mismatches i.e. the column names and values that are not identical
verify_source_datetime	Timestamp for when the source file existence was verified and the `[Modified]` columns compared with the session log data
verify_source_result	Values: `ExistIdentical, ExistOlder, ExistNewer, NotExist, Error`
verify_source_message	The value `Ok` or the error message returned form the source FileShare or SharePoint site during validation.
verify_source_library	The source SharePoint Document Library URL. If the source is FileShare then this column is blank.
verify_job_id	The internal job_id in the session log.

validates the result of file migrations by verifying that both the source and destination files have tghe

2 sysrtem varible verification_count_identical, _mismatch

Verify files before select:

Last modified: 1 June 2023