1 Reply Latest reply on Aug 17, 2010 10:19 PM by 778553

    Cross platform migration

      Suppose i have to migrate a peoplesoft database from sqlserver to Oracle, what is the best possible approach?

      1.Should i just do an export * in datamover and import the datfile to oracle shell database?
      2.Should i first import tools table alone using MVPRD script and then rest of the records? Does this process has any advantages in terms of accuracy and cutover time?
      3.Does any one has a better idea?

      When the db migration is done, how do we take a list of the impacted sql objects for retrofitting?

      Please put forth your ideas on this?