ramanareddy
17th September 2007, 15:00
Could any one advice by what % the data size will change when migrated from tbase to Oracle 10?

Also it would be greateful to talk to some one who still remembers their migration experiences from tbase to Oracle on Baan IV C4

Regards
Ramana

dave_23
20th September 2007, 00:13
Was a long time ago. i seem to remember it went down signifcantly.
Maybe 20%?

that was tbase -> oracle7

Dave

ramanareddy
24th September 2007, 22:49
Dave,

Did you mean, the data size went up by 20%?

The data size will go up because tbase stores data as a sequential file where as in Oracle or any other RDBMS, indexes and blank records also take up space.

Regards

dave_23
26th September 2007, 18:59
It went down because tbase uses hash columns for it's indexes (level 1)
assuming a level 2 oracle driver you're storing significantly less data, enough to overcome any gain you might get from it being in an rdbms

Dave