topic Re: Migrate all tables from one database to other database in MSSQL using Talend data integration in Talend Studio

Migrate all tables from one database to other database in MSSQL using Talend data integration

Anonymous — Thu, 11 Oct 2018 14:08:23 GMT

Hi,

I am using Talend data integration open studio version 7.0.1.I want to migrate all tables from one database to other database in MSSQL.I tried with tMSSqlConnection -> tMSSqlTableList -> tMSSqlColumnList -> tMSSqlOutputBulkExec but it didn't work.I want to clear old data from table and import new data coming from source database But i am not able to clear table data as it is referenced by a foreign key constraint.Is there any component in Talend which we can use for data migration?

Re: Migrate all tables from one database to other database in MSSQL using Talend data integration

vapukov — Fri, 12 Oct 2018 02:48:06 GMT

it will not work as described!

why You try use Talend for not Talend Job? Talend (same as all ETL tools) created for transform 1 or few tables, but not for replication, not for mirorring

of course it could do this work, but with many restrictions

when You need transfer all tables from one database to another database of same type - nothing more than dump sql file, restore sql file not possible to create (as variant - backup -> transfer -> restore)