SAS Scalable Performance Data Server 4.5, Administrator'S Manual, Page: 65 / 271

Chapter 5
SPD Server 3.x to SPD Server 4.5
Conversion Utility
Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 59
Before You Convert . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 59
Overview of the SPDSCONV Utility . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 60
Using SPDSCONV . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 61
SPDSCONV Utility Examples . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 62
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 62
Converting a Simple Table . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 62
Converting Tables and Recreating Indexes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 63
Introduction
SPD Server 4.5 uses improved architectures that enable features like the ability to support
data tables that contain over 2G observations. The new architectures provide functionality
that is needed in today's data marts, but the current generation of SPD Server tables use
metadata architectures that are not backwards compatible with SPD Server 3.x software.
SPD Server 4.x tables use architectures that utilize SAS 9 metadata. SPD Server 3.x tables
use architectures that utilize SAS 8 metadata. The two metadata architectures are not
compatible. However, SPD Server 4.5 provides a conversion utility SPDSCONV that
permits SPD Server 3.x customers to convert existing tables for use with SPD Server 4.x.
The SPDSCONV utility is designed to be run by the SPD Server Administrator.
Note: SPD Server Administrators should ensure that all images of the SPD Server 3.x data
sets to be converted are completely backed up before beginning the conversion process.
Before You Convert
The SPDSCONV utility changes the format of SPD Server 3.x tables to SPD Server 4.x
tables. The conversion is not reversible. Once you convert a table for use with SPD Server
4.x, the table cannot be read any longer by SPD Server 3.x. Before you start converting
SPD Server tables, you should do a full back up all of your existing SPD Server 3.x tables.
If you ever need to go back to your SPD Server 3.x tables, you can restore them.
If you need to temporarily use your tables with SPD Server 3.x and SPD Server 4.x, you
can use PROC COPY to make copies of the tables before you convert them. You can use
59