topic Re: Schema migration from oracle to MSSQL Server in Talend Studio

Schema migration from oracle to MSSQL Server

Anonymous — Wed, 07 Sep 2016 08:08:27 GMT

Hi Team,
Is it possible to Migrate entire schema (Tables,Packages, Procedures,Functions, Synonyms ,Materialized views ...... etc) from Oracle database to MSSQL Server ? Can this schema migration be done using Talend open studio ? or any other product of Talend?

Thanks,
TalendBSO

Re: Schema migration from oracle to MSSQL Server

Anonymous — Wed, 07 Sep 2016 08:46:14 GMT

Hi,
Do you want to migrate your DB.
So far, you can migrate tables from one DB to another by using talend tool.
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 Talend subscription product, you only need to create one subjob for all tables due to the 'dynamic schema' feature.
Best regards
Sabrina

Re: Schema migration from oracle to MSSQL Server

Anonymous — Wed, 28 Sep 2016 05:47:01 GMT

Hi Sabrina,
Thanks for your updates.
1) How about other DB Objects apart from Tables ( Packages, Procedures,Functions, Synonyms ,Materialized views ...... etc)
which are present in the schema can this also be migrated using Talend tool ?
[font=Verdana, Helvetica, Arial, sans-serif] 2) Is there any feasibility with single job can we migrate entire schema rather migrating each and every object one by one?[/font]
Thanks.

Re: Schema migration from oracle to MSSQL Server

Anonymous — Wed, 28 Sep 2016 08:33:33 GMT

Hi talend_bso1,
So far, you can only migrate tables from one DB to another by using talend tool.
With dynamic schema feature, you can migrate tables from one DB to another through a single job.
The dynamic schema feature will be available in talend subscription version.
Best regards
Sabrina

Re: Schema migration from oracle to MSSQL Server

devx — Fri, 29 Jan 2021 11:48:39 GMT

Hi Sabrina,

What is the situation today ?

Can you answer this : https://community.talend.com/s/question/0D53p00008QaLNpCAN/sybase-mssql-and-oracle-to-postgresql-migration-using-talend-open-studio

Re: Schema migration from oracle to MSSQL Server

Anonymous — Mon, 01 Feb 2021 09:09:36 GMT

Hello,

There is a response in this topic: https://community.talend.com/s/question/0D53p00008QaLNpCAN/sybase-mssql-and-oracle-to-postgresql-migration-using-talend-open-studio

Could you please have a look at it?

Best regards

Sabrina