SAS Financial Management Database

Reply
New Contributor
Posts: 3

SAS Financial Management Database

I'm trying to backup a SAS Financial Management database. It is in MySQL partly and partly in SAS Base. Theres no problem with SAS Base DB backup, but how can i get to FM database in MySQL - to SAS Suppliend FM LIB - I have tried to get to it with MySQLAdministrator but all i can see is sassdm and sasop databses(schemas). In sassdm schema i see tables like sas_audit, sas_config etc. but there are no tables like SAS_CURRENCY or SAS_DIMENSION_TYPE whitch i want to backup. Does anyone know where can i find tables from SAS Supplied LIB and how to bacup data from them???

Please HELP!

New Contributor
Posts: 3

Re: SAS Financial Management Database

OK...solved it...the databases to backup are: sharedservices, sassdm, sasop

From CMD you can do it by: mysqldump.exe -u sqladmin -p [databsetobackup] > backupfile.sql

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