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?