Guys,
I am looking to move data from one database(sybase) to another(Oracle 12c) using datastage 8.5 version. I have couple of below questions:
1) Does datastage 8.5 support Oracle 12c ?
2) What could be the best possible migration approach. I am looking to develop a RCP enabled job to migrate the data. Will it be fine ?
3) Data volume is huge and hence I am looking for some data migration stats like how much time it will take to load around 5 GB of data.
Regards.
Data Migration Statistics using datastage
Moderators: chulett, rschirm, roy
1) yes
2) RCP works well in this type of scenario, but you will have to check to ensure that your datatypes are compatible between the two databases (character set, date/time types, etc.)
3) 5Gb is a small amount of data. Even 5Tb can be a small amount, depending upon your hardware.
2) RCP works well in this type of scenario, but you will have to check to ensure that your datatypes are compatible between the two databases (character set, date/time types, etc.)
3) 5Gb is a small amount of data. Even 5Tb can be a small amount, depending upon your hardware.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>