Question

Refresh of TEST environment - Export of Basic Data?

  • 13 January 2021
  • 3 replies
  • 32 views

Badge +1

Good evening,

I am relatively new to IFS and I’ve been informed that soon a refresh of the TEST environment will be done. Is there an easy way to export my data from my TEST environment before the refresh and import my data again? I’m referring to basic data such as work centers but also data related to routings, work schedules etc.

Any feedback is welcome to avoid my preparations from being lost.

Best regards

Bart


3 replies

Userlevel 1
Badge +7

Hi Bart,

There are several tables related to what you are asking about that need to be exported. For starters, I identified tables for the connectors and route addresses/rules.  Hopefully others can chime in as well. If you do not do these, you run the risk of sending/receiving messages in your production targets.

Export Connector related tables

FORE1APP.FNDCN_CONFIG_PARAM_AREA_TAB,

FORE1APP.FNDCN_CONFIG_PARAM_GROUP_TAB,

FORE1APP.FNDCN_CONFIG_PARAM_INST_TAB,

FORE1APP.FNDCN_CONFIG_PARAM_TAB,

FORE1APP.FNDCN_ROUTE_ADDRESS_TAB,

FORE1APP.FNDCN_ROUTE_CONDITION_TAB,

FORE1APP.FNDCN_ROUTE_ADDRESS_REF_TAB

Userlevel 5
Badge +15

Sorry to be the bearer of bad news but in a lot of cases it is purely open both the ‘new’ database and your ‘test’ database populate your current basic data and RMB > Copy then go to the ‘new’ database open the same window and RMB > Paste.

 

We had to do that, in some cases we had to create migration jobs to export and then import.

 

With regards the areas, it depends on what modules you have.

 

Sorry I couldn’t be more helpful.

Userlevel 1
Badge +7

Bart,

What is your database? Is it MS SQL or Oracle?  It would make a difference.

Reply