To create SQL Server export databases:
Run: C:\sqlplus HSF/password@HSFOraDBSrvName.
RunSQL>scriptname.sql where scriptname is the name of your script.
From%EPM_ORACLE_HOME%\products\hsf\cfg, install these scripts:
Step1_create_HSF_database — Creates the Strategic Finance SQL Server database (hsfsvr)
Step1alt_remove_objects— Removes objects
Step2_security — Configures log in information and permissions. By default, this is hsfdbuser and password.
Step3_tables_grants — Contains the base Strategic Finance database schema including tables, and indexes
Step4_procs_funcs — Contains stored procedures and functions