SAS Data Migration

vijayanand — Mon, 13 May 2019 10:56:25 GMT

Hi ,

We recently have migrated some SAS data sets from Unix server to Linux server. The data sets which were migrated already, are growing daily (some observations are being added,some are being updated and some are being deleted) on the source server (Unix).

How do we bring all these changes alone on to the target (Linux Server).

Some of the data sets are very hugs in size, so migrating the entire data set again from source to target is very time consuming and this has to happen daily , till the target server goes live.

Thanks,

Vijay.

Re: SAS Data Migration

Patrick — Mon, 13 May 2019 11:40:35 GMT

@vijayanand

There is no CDC for SAS tables. You would need to implement fully blown ETL delta processing which is nothing you can just do on-the-fly as an intermediary measure.

Best you can do is to compress/zip your data before transferring from source to target - but you will still need to transfer the whole file.

...or: Any chance to map the file system used by the old server also to the new server as an intermediary measure?

topic Re: SAS Data Migration in SAS Programming

SAS Data Migration

Re: SAS Data Migration