topic Re: Comparing Metadata before and after upgrade. in Administration and Deployment

Comparing Metadata before and after upgrade.

japsas100 — Mon, 13 Apr 2020 16:29:57 GMT

Hi,

Is there any script/method to compare the metadata before and after migration of sas 9.3 to 9.4?

including libraries/stored process/ etc

Re: Comparing Metadata before and after upgrade.

SASKiwi — Mon, 13 Apr 2020 20:51:08 GMT

As far as I'm aware there isn't. Comparing metadata between major SAS releases would be like comparing chalk and cheese - very different!

If the purpose of comparing metadata is to prove that your new SAS 9.4 environment is set up correctly, only testing all migrated SAS applications will do that.

Re: Comparing Metadata before and after upgrade.

japsas100 — Mon, 13 Apr 2020 20:55:06 GMT

@SASKiwi

Thanks for the reply.

We have sas stored process stored in SMC in 'Folder'>'SAS'>xx>xx>xx

we need to validate all these programs present in the older version.

Re: Comparing Metadata before and after upgrade.

SASKiwi — Mon, 13 Apr 2020 21:29:10 GMT

How many stored processes have you got? How about using two SAS Management Console sessions, one 9.3 the 9.4 and then just going through the metadata folders, verifying all stored processes are present in 9.4?

Re: Comparing Metadata before and after upgrade.

japsas100 — Tue, 14 Apr 2020 13:18:05 GMT

Thanks,

I have completed the task by exporting the package which includes the stored process and then comparing it in an excel sheet.