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?
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
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.
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
Can you answer this : https://community.talend.com/s/question/0D53p00008QaLNpCAN/sybase-mssql-and-oracle-to-postgresql-migration-using-talend-open-studio
