AnsweredAssumed Answered

Pdm_userload or Pdm_restore

Question asked by paulofreire75 on May 10, 2018
Latest reply on May 10, 2018 by Chi_Chen

I´m moving my sdm data from an oracle database to an sql server database.

For this intent I will use pdm utilities to load data in the sql database after pointing the installation to a fresh mdb in sql server.

What is the best aproach:

  • Use pdm_extract ALL and after load the data in system with pdm_userlaod;
  • Use pdm_backup and after load the data in system with pdm_restore.

Now I´m doing a test load in an test environment (using real production pdm_extract all data) and load is running for 2 hours now and not finished yet.

Outcomes