topic Re: complete migration from oracle to sql server in Talend Studio

complete migration from oracle to sql server

Anonymous — Sat, 16 Nov 2024 12:34:53 GMT

hi,
i am not an expert user and i don't found my solution.
i'm trying to migrate oracle db to sql server 2008 db and i wish to use talend but i don't know in which way i could make it.
may you post me some example and/or some image to explain me my doubts?
and if there is a way to migrate also package oracle to package for sql!!
thanks a lot

Re: complete migration from oracle to sql server

Anonymous — Thu, 10 Nov 2011 08:44:09 GMT

Dear user
In TOS, you have to create many subjobs for mapping table by table in one job, because each table has different table structure, you have to create different subjob with corresponding schema, for example:
tOracleInput_1--main--tMSSQLOutput_1 (migrate table1)
|
onsubjobok
|
tOracleInput_2--main--tMSSQLOutput_2 (migrate table2)
|
onsubjobok
|
...other subjobs for other tables...
In TIS, you only need to create one subjob for all tables due to the 'dynamic schema' feature, here I take an example to show you how to finish the database migration from Mysql to mssql server, please see my screenshots.
Best regards
Shong

Re: complete migration from oracle to sql server

Anonymous — Thu, 10 Nov 2011 11:13:18 GMT

I think I understand.... but is it possible convert/migrate package oracle in store preocedure sql by talend?