We need to change our Datastage environment Database Oracle9i to SQL server,
now our biggest challenge is How to change the Datastage jobs - All Oracle stages to SQL server compatible?
Till now we used ORAOCI9 stages.
Please let me know your suggesions and steps to change Oracle - SQL server.
any kind of inputs are very helpfull to me.
Thakns
CC
How to change Datastage Oracle stage to SQL server compatibl
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
If you had used the Dynamic Relational Database stage you could make the change in a few minutes. I suggest you switch to it rather than the SQL Server stage to avoid this issue as it lets you change the database type but still uses the native database connectivity. IBM migration services may have a utility that does this from the old PeopleSoft EPM upgrade days - I suggest you contact them and get a quote. They may try and get you to upgrade to version 8 or parallel but insist you want to stay on the current version and replace your Oracle 9 stages.
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn