Architecting, installing and maintaining your SAS environment

SAS Financial Management SDM MySQL to PostGre migration methodology ?

Reply
Regular Learner
Posts: 0

SAS Financial Management SDM MySQL to PostGre migration methodology ?

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.

 

 

 

 

SAS Employee
Posts: 101

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

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. 

Ask a Question
Discussion stats
  • 1 reply
  • 196 views
  • 0 likes
  • 2 in conversation