topic Re: Moving Data Library Definition to Other Server in SAS Web Report Studio

Moving Data Library Definition to Other Server

databobjr — Thu, 20 Jan 2011 01:18:51 GMT

Hi,

I have a set of Libraries which were defined under the data library manager in management console. Now I need to move them to a different server, (same SAS version (9.2), just from development to production). How do I export theme and import them?

In olap cube, there is an export package and an import package functions. I don't seem to see one under management console.

Thanks,
Bill. Message was edited by: databobjr

Re: Moving Data Library Definition to Other Server

twocanbazza — Thu, 20 Jan 2011 03:00:22 GMT

In SMC, use the folder view rather than the plug-in view

To Export

Navigate to the metadata folder that the library(ies) are defined, select the libraries and RMB and select Export SAS Package.

To Import

Navigate to the metadata folder where you want to import,RMB and select Import SAS Package.

Barry

Re: Moving Data Library Definition to Other Server

TSBruce — Wed, 26 Jan 2011 15:47:30 GMT

Hi-

You can export and import the metadata for the cubes using the same process mentioned in the response above. However, this does not recreate the physical cube files. You will need to use the proc olap to create the physical cube files while making any adjustments for your production environment (library paths, work paths, etc.).

Re: Moving Data Library Definition to Other Server

AngelaHall — Wed, 26 Jan 2011 16:16:29 GMT

Also note that I have posted two different options on how to migrate OLAP cubes:

http://sas-bi.blogspot.com/2010/10/moving-olap-cubes-part-1-its-all.html
http://sas-bi.blogspot.com/2010/10/moving-olap-cubes-part-2-management-has.html

~ Angela