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

[Anonymous]

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?

[vapukov]

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)