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.

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach

Watch

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch