Migrate Multiple Database in Multiple Servers

Four Stars

Migrate Multiple Database in Multiple Servers

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.

 

Moderator

Re: Migrate Multiple Database in Multiple Servers

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

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Four Stars

Re: Migrate Multiple Database in Multiple Servers

 

 
 
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.