Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • This step installs the Target Enablement Pack from the path given during the migration startup script, this path is stored and retrieved from the parameter: 'red10EPLocation'.
  • (warning) Caution: if the path to the EP is a network path then the user running the scheduler service may not have access to it, this can fail the job. To resolve this you can run this script manually from RED or copy the EP to a local directory the Scheduler service can access, adjust the parameter 'red10EPLocation' to match, then restart the job from the failed step in the Azkaban Dashboard by rerunning the failed execution.

...

  • This script is driven by the two parameters 'red10DefaultLinuxActionScriptName' and 'red10DefaultWindowsActionScriptName'.
  • This script runs a set a queries to determine candidate objects for a generic action script and then uses the parameters above to assign a default generic action scrip to those objects. 
  • The Migration Tooling provides two sample generic action processing scripts which are copied across to the Destination metadata and then used in these assignments.
  • The sample sample generic action processing scripts are 'wsl_mt_py_action_script' for python and 'wsl_mt_ps_action_script'.*
  • If you have your own generic action processing script in the target to assign you can set in in these parameters.
  • To disable this script process and have all object's action scripts regenerated later, you can remove the script names from these parameters.

...

  • Associates objects with the default storage templates of the target connection they are associated with.
  • This script will not overwrite existing storage template associations for an object, it only adds missing templates.
  • Included in Job '4_Set_Storage_Templates'
  • (lightbulb) If you find you were missing some default templates on one of your Destination repository Target connections, you can rerun this script to have them applied to the associated objects.
  • If you have a remote PostgreSQL server you will need to adjust this script to force a client side copy, adding the leading backslash fixes this: Image Added

c2_generate_windows_action_scripts and c3_generate_linux_action_scripts

...

  • Sets the load template for each Load table which has no existing load script or load template associated.
  • These defaults are taken from the Load table's associated Source connection's default load script template.
  • (warning) It is important to go through your source connections and make sure they have suitable load script templates assigned prior to running this script. If you have SSIS or DBLink loads these will require specific templates set.
  • If you have a remote PostgreSQL server you will need to adjust this script to force a client side copy, adding the leading backslash fixes this: Image Added

c5_generate_load_scripts

Similar to the c2 and c3 scripts, this script runs RedCli commands in batches and progress can be viewed in the cmd window or scheduler audit trail. Some failures can be expected for the first few runs until all the configurations have been resolved.

...