I need to migrate a large number of metadata bound libraries

Steve_Huggins — Mon, 18 Nov 2024 11:53:55 GMT

Have a very large number of metadata bound libraries to migrate to a new SAS environment, the physical tables are stored on a shared file system and will be remaining in place. I propose to achieve this as follows.

1) Migrate all Secured Libraries via metadata export and import - this will remove all password and encryption keys. Luckily all of the libraries use the same ones.

2) Use a script to update the PW and key values in metadata from the new environment. The will use the Authlib procedure as documented here : SAS Help Center: Resetting Credentials on Imported SecuredLibrary Objects.

I have two issues with this, the first is collecting the required information, I will need physical location of each library have have managed to get the metadata folder and library cant pick up the physical path.

The second issue I have and the one that is really concerning is with Proc Authlib. I have tried a quick test to prove the approach which went as follows:

Create a new secure library (no encryption)
Add a few tables and test access
Export the the metadata and then import back - test proves that the PW info has been remove from metadata
Use the Authlib procedure with modify to restore the PW in metadata

This what happens:

Any advice on either of these issues would be gratefully received.

Re: I need to migrate a large number of metadata bound libraries

carl_sommer — Tue, 19 Nov 2024 20:21:41 GMT

FYI - Steve has opened a tech support case on this; when it's resolved I'll update this thread with relevant information.

Carl Sommer - SAS Technical Support

topic Re: I need to migrate a large number of metadata bound libraries in Administration and Deployment

I need to migrate a large number of metadata bound libraries

Re: I need to migrate a large number of metadata bound libraries