How to change Datastage Oracle stage to SQL server compatibl

chanduch9 · Post by **chanduch9** » Tue Apr 28, 2009 11:55 am

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

vmcburney · Post by **vmcburney** » Tue Apr 28, 2009 8:22 pm

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.