Migrate Multiple Database in Multiple Servers

[Anonymous]

Hello

There are a manner or component to Migrate Multiple Database on Multiple Servers to Consolidate the data in one Concentration Database on SQL Server  ?

If not There are a form to execute TRANSACT SQL code to call Stored Procedures to make this kind of automation.

Thanks In Advance.

[Anonymous]

Hello,

Please have a look at talend t<DB>Row component in order to execute the stated SQL query on your specified database.

Best regards

Sabrina

[Anonymous]

I continue with the doubt, specifically, is it possible to migrate more than a single table in a single step with the tmssql component or another? Im looking for something that let me copy all the tables of an Microsoft SQL Server DB to another, but not table for table, not one by one. 

Thanks In Advance.