BookmarkSubscribeRSS Feed
helannivas88
Obsidian | Level 7

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.

2 REPLIES 2
Anand_V
Ammonite | Level 13
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!
LinusH
Tourmaline | Level 20

Wow. 

Thanks to pointing it out @Anand_V , 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.

Data never sleeps

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

CLI in SAS Viya

Learn how to install the SAS Viya CLI and a few commands you may find useful in this video by SAS’ Darrell Barton.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 481 views
  • 0 likes
  • 3 in conversation