Source db change from oracle to sql server

[talendsai]

Hi, We have lot of jobs that reads from oracle, our source system decided to change their database from oracle to sql server. what would be the easiest way to convert all the jobs to read from sql server? do we need to rework on each and every job?? are there any utilities available for auto converting the jobs to use sql server instead of oracle??  Thanks & Regards, SaiSridhar Nekkanti

[iamabhishek]

I believe there is no easy way to just change the oracle database components to sql server components. They needs to be created again and configured again with the changed server/database details.

If the jobs are using Oledb components like tOledbInput or tOledbOutput then changing the connection URL would suffice provided the tablename, query & schema details are taken care of.

[manodwhb]

@talendsai,if you have used generic component like (tJDBCinput and tJDBCoutput )  and connection if your are using repository connection,you can just edit the connection and re-trive schemas.if you have used oracle components you need to re-design all the jobs.

[Anonymous]

Hi,

      Since your programs is currently using tOracle components, you will have to replace them with new components.      

      One another aspect you need to think is the type of queries the program is currently using while data extraction. If the program is using Oracle specific functions, then you will have to convert to a compatible function in MS SQL Server.

Warm Regards,

Nikhil Thampi