topic Migrate Multiple Database in Multiple Servers in Talend Studio

Migrate Multiple Database in Multiple Servers

Anonymous — Fri, 29 Jun 2018 05:49:50 GMT

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.

Re: Migrate Multiple Database in Multiple Servers

Anonymous — Fri, 29 Jun 2018 09:24:12 GMT

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

Re: Migrate Multiple Database in Multiple Servers

Anonymous — Wed, 04 Jul 2018 21:14:49 GMT

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.