SAS Data Migration

[vijayanand]

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.

[Patrick]

@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?