Converting SPD Server 4.x 32-Bit Windows Tables to SPD Server 5.3 64-Bit Windows Tables

Tables that were created with SPD Server 4.x running in Windows 32-bit mode are not compatible with SPD Server 5.3 tables in 64-bit mode. SPD Server 5.3 for 64-bit Windows does not recognize SPD Server 4.x components. If you submit a PROC CONTENTS command to SPD Server 5.3 on a Windows 64-bit server, SPD Server 5.3 does not recognize SPD Server 4.x tables, views, or clusters, even if they exist in a valid SPD Server domain. There are two ways that you can convert SPD Server 4.x tables from a 32-bit Windows environment to SPD Server 5.3 tables for use in a 64-bit Windows environment:

Convert SPD Server 4.x Tables to SAS Tables and Then to SPD Server 5.3 Tables

Convert Directly from SPD Server 4.4x and 4.5x Tables to SPD Server 5.3 Tables

Using PROC COPY with SPD Server Cluster Tables

Convert SPD Server 4.x Tables to SAS Tables and Then to SPD Server 5.3 Tables

You can convert SPD Server 4.x tables into SAS 9.2 or SAS 9.3 tables by making a LIBNAME connection to your SPD Server 4.x server, and then making a LIBNAME connection to SAS. After both LIBNAME connections are established, you can use PROC COPY to copy the tables from your SPD Server domain to your SAS domain.

LIBNAME spd44 sasspds “<SPD-Server-4.x-domain-name>”
  host=localhost 
  serv=<SPD-Server-4.x-server-port>  
  user=<user-ID> ;
 
LIBNAME SAS “<path-to-SAS9.2-or-SAS9.3-directory>”;
PROC COPY in=spd44 out=sas;

After you copy your SPD Server 4.x tables into SAS 9.2 or SAS 9.3 tables and store them in a SAS location, you can install SAS 9.4 and SPD Server 5.3 on your Windows 64-bit platform. Next, you use the 64-bit Windows environment to create a SAS 9.4 LIBNAME connection to the directory location where you stored your copied SPD Server 4.x tables, and create a SAS 9.4 LIBNAME connection to your SPD Server 5.3 domain. Now you can use the SAS 9.4 PROC COPY command to restore the former SPD Server 4.x tables to your SPD Server 5.3 domain in SPD Server 5.3 format.

LIBNAME spd53 sasspds “<SPD-Server-5.3-domain-name>” 
  host=localhost 
  serv=<SPD-Server-5.3-server-port>  
  user=<user-ID> ;

LIBNAME SAS94 “<path-to-SAS9.4-directory>”;

PROC COPY in=SAS94 out=spd53;

SPD Server 5.3 will be able to recognize and use the copied tables in the new SAS 9.4 and SPD Server 5.3 domain space.

Convert Directly from SPD Server 4.4x and 4.5x Tables to SPD Server 5.3 Tables

To convert directly from SPD Server 4.4x and 4.5x tables to SPD Server 5.3 tables, use SAS 9.4 with the SPD Server 4.4x or 4.5x server and an SPD Server 5.3 server. You must be able to operate both versions of SPD Server in your computing environment in order to use this conversion approach.

First, you make two LIBNAME connections using SAS 9.4. You make the first LIBNAME connection to your SPD Server 4.4x or 4.5x server. Then you make the second LIBNAME connection to your SPD Server 5.3 server. After you establish a LIBNAME connection between the SPD Server 4.4x or 4.5x host and the SPD Server 5.3 host, you can use a PROC COPY statement to copy your server tables directly from your 4.4x or 4.5x host to your SPD Server 5.3 host.

LIBNAME spd44 sasspds “<SPD-Server-4.4x-domain-name>” 
  host=localhost 
  serv=<SPD-Server-4.4.x-server-port>  
  user=<user-ID> ;

LIBNAME spd53 sasspds “<SPD-Server-5.3-domain-name>”  
  host=localhost 
  serv=<SPD-Server-5.3-server-port>  
  user=<user-ID> ;

PROC COPY in=spd44 out=spd53;

Using PROC COPY with SPD Server Cluster Tables

If you use the PROC COPY command to move tables from one SPD Server domain to another SPD Server domain or SAS location, and if your source domain contains SPD Server cluster tables, the output file that is produced by the PROC COPY command will be either a SAS table or an SPD Server table. The output file will not be a clustered table.

To migrate formerly clustered tables from SPD Server 4.x to SPD Server 5.3, you must first undo the table cluster in the source (SPD Server 4.x) location. Then copy the component tables to the destination (SPD Server 5.3) location. You can use PROC COPY to copy the unclustered files from the source domain to the destination domain. After you successfully copy your tables to the destination domain, use SPD Server 5.3 CLUSTER TABLE commands to re-create the clustered table structures.

Last updated: February 3, 2017