SAS/MDDB Server Administrator's Guide

Transporting MDDBs Across Operating Environments

In some business computing environments, it is necessary for MDDBs that are created in one operating environment to be used on a different, incompatible operating environment. In this case, the possible solutions are to

copy the MDDB to the other operating environment
access the MDDB from the other operating environment over a network.

The latter option is addressed in Accessing MDDBs Remotely. This section discusses copying ("transporting") MDDBs from one operating environment to another.

The CPORT and CIMPORT procedures, which are used to transport SAS files between operating environments, do not support the transport of MDDBs. Instead, the following methods can be used:

the COPY procedure
the UPLOAD and DOWNLOAD procedures
the Cross Environment Data Access (CEDA) facility.

The first method requires either SAS/SHARE software or SAS/CONNECT software. The last two methods require SAS/CONNECT software.

Transporting MDDBs with the COPY Procedure

To use the COPY procedure to transport MDDBs, you must have SAS/SHARE or SAS/CONNECT software licensed.

Establish a connection between the local host and the SAS/SHARE server or remote host. See SAS/SHARE User's Guide or SAS/CONNECT User's Guide for details.
Use the LIBNAME statement to declare a library on the SHARE server or remote host:
- For SAS/SHARE sessions
```
libname rmtlib server=rmthost.share1;
```
  This example informs the local SAS session that the libref RMTLIB references the RMTLIB library on the SAS/SHARE server share1, which is located on a host called RMTHOST.
- For SAS/CONNECT sessions
```
signon rmtpc;
libname rmtlib remote 'd:\sasmddb' server=rmtpc;
```
  This example establishes a connection with the remote host RMTPC and informs the local SAS session that the libref RMTLIB references the SAS data library d:\sasmddb on the RMTPC host.
Use the COPY procedure to copy an MDDB between the local and remote hosts:
```
proc copy out=work in=rmtlib memtype=mddb;
```
This example copies all MDDBs from the RMTLIB library on the remote host to the temporary library on the local host. The COPY procedure can also be used to copy MDDBs from the local host to the remote host.

Transporting MDDBs with the UPLOAD and DOWNLOAD Procedures

To use the UPLOAD and DOWNLOAD procedures to transport MDDBs, you must have SAS/CONNECT software licensed.

Establish a connection to the remote host. (See the SAS/CONNECT User's Guide for details.)
Use the UPLOAD procedure to transport the MDDB to the remote host or the DOWNLOAD procedure to transport the MDDB from the remote host:
```
proc upload data=school.grades out=grades_copy;
```
This example copies the MDDB GRADES from the local SCHOOL library to the WORK library on the remote host as GRADES_COPY.

For complete details on the UPLOAD and DOWNLOAD procedures, see the SAS/CONNECT User's Guide.

Chapter Contents
Previous
Next
Top of Page