topic SAS Management Console library in Administration and Deployment

SAS Management Console library

helannivas88 — Thu, 01 Aug 2019 15:09:54 GMT

Hi,

Currently I'm working on a migration project where our SAS libraries was initially pointing to Oracle database under data library Manager in SAS Management Console.

Now I have to edit the library to point to different database , but it doesn't allow me to change the Engine.

I have to delete the old libraries and create a new one pointing to new engine. I have lot of libraries to work on. Is there any easy option to edit the libraries and point to different databse.

Re: SAS Management Console library

AnandVyas — Fri, 02 Aug 2019 13:29:47 GMT

Hi @helannivas88,

While creating database Data libraries in SMC, Engine is by default and cannot be changed. For example, while creating a new library you select oracle as your database engine would be "oracle" and cannot be changed. Unless you want to just point it to a different schema/db under same database type.

Thanks!

Re: SAS Management Console library

LinusH — Mon, 05 Aug 2019 11:46:56 GMT

Wow.

Thanks to pointing it out @AnandVyas , didn't realize that it (didn't) work this way.

This is awkward if you want to migrate a whole library to a different database.

Crerating a new Library is easy, but you then need change the Library in each table that uses it as its Physical location.

One idea, you could export all tables for that Libray, and then re-import and map the Libary to your new one? Should at least be less manual work if you have let's say more than 10-20 tables to adjust.