topic SAS Financial Management SDM MySQL to PostGre migration methodology ? in Administration and Deployment

SAS Financial Management SDM MySQL to PostGre migration methodology ?

Sylvain — Tue, 17 May 2016 16:06:41 GMT

Hi SAS Users,

While migrating a SAS FM 5.3 to at least SAS FM 5.4, the SAS SDM must be migrated from MySQL to PostGre.

I haven't found a script to do these action.

Is there a simple way to migrate the SAS SDM to PostGre ( without using SMU )

Thanks.

Re: SAS Financial Management SDM MySQL to PostGre migration methodology ?

dpage — Tue, 17 May 2016 20:51:04 GMT

Unfortunately, no. There are data type conversions as well as special handling for BLOBs that must be done - so it's not as straightforward as the previous alter scripts between MySQL based versions.