BookmarkSubscribeRSS Feed
Sylvain
Returning User | Level 2

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.

 

 

 

 

1 REPLY 1
dpage
SAS Employee

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. 

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

Get Started with SAS Information Catalog in SAS Viya

SAS technical trainer Erin Winters shows you how to explore assets, create new data discovery agents, schedule data discovery agents, and much more.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 884 views
  • 0 likes
  • 2 in conversation