topic Metadata Migration in Administration and Deployment

Metadata Migration

Key123 — Wed, 31 Jul 2024 19:57:30 GMT

Hello,

Is there any option to bulk update the command lines for all deployed metadata jobs ? we have a change in file paths as below and all our metadata deployed jobs have the command line referencing to old one, I dont have an option to update it dynamically during the metadata migration.

OLD : /opt/sas/sasconfig_node/Lev1/../../..

New : /opt/sas/config/Lev1/../../..

All .sas files migration has been taken care on unix level.

Re: Metadata Migration

SASKiwi — Wed, 31 Jul 2024 20:07:50 GMT

Where do you specify this command line? It would be helpful if you posted a screenshot of where it is defined.

Re: Metadata Migration

Key123 — Wed, 31 Jul 2024 20:26:47 GMT

@SASKiwi : Added screenshots below and more details on the issue I am encountering with metadata migration. Looking for suggestions on how to ecomplish this.

Metadata migration : Individual metadata Deployed job - Command changed as expected to the new target environment.

however, I have the same job in a flow, (flow and deployed jobs are migrated together)- But the Command is not changing for deployed job within the flow. Do I need to migrate them in any order to get them in sync?.

Re: Metadata Migration

SASKiwi — Thu, 01 Aug 2024 02:06:12 GMT

Is this a one-off migration to a new SAS installation or is it a BAU migration from one SAS environment to another that will be repeated? I'm not familiar with this type of scheduling setup. Our setup doesn't have a command line on each job, just one that is configured on the scheduling server itself.

I can't think of any easy way to automate this. It is possible to update SAS metadata with SAS code, but it requires a lot of complicated logic to traverse the metadata schema. If this is just a one-off migration, then it might be easier just to manually update each job.