complete migration from oracle to sql server

One Star

complete migration from oracle to sql server

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
Community Manager

Re: complete migration from oracle to sql server

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
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: complete migration from oracle to sql server

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