We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Sync tables in two different sql servers.

Thread ID:





129958 Apr 11,2017 06:40 PM UTC Apr 13,2017 01:11 PM UTC Data Integration Platform 2
Tags: Data Integration
Birendra Tuladhar
Asked On April 11, 2017 06:40 PM UTC

I mimic merge statement in my SSIS package to sync tables in databases in two separate SQL Servers. Below is the screen shot. Can I achieve this with data integration?

Karthikeyan SankaraVadivel [Syncfusion]
Replied On April 13, 2017 08:59 AM UTC

Hi Birendra,  

Thank you for contacting Syncfusion Support. 

We have deleted the previous response as they were not appropriate to the reported query. We regret the inconvenience caused.  

Please find the below response.  
Overview of Data integration Platform  
The Syncfusion Data Integration Platform provides an intuitive visual interface for integrating and transforming data from various sources into analytics-ready data. The transformed data can then be easily used for data warehousing, creating reports and dashboards, or for business intelligence analysis purposes.   
Sync tables in databases in two separate SQL Servers. 
Yes, We able to Synchronize the tables from different data source with our Data integration Platform by the following workflow. 
·         We can synchronize the records among the tables. This requires a column(last modified) which hold the timestamp of an action performed on that record. 
  • We can route New record or Updated record  using  conditional split processors based on last modified column.

Please let us know if you have further clarifications.  

Karthikeyan S   

Karthikeyan SankaraVadivel [Syncfusion]
Replied On April 13, 2017 01:11 PM UTC

Hi Birendra,   

We have created the sample data flow which Synchronize the Source table(SQLSERVER 1) with the Destination table(SQLSERVER 2) .  

Please find the sample Data flow template and workflow document for your reference.  

Please let us know if you have further assistance. 

Karthikeyan S  


This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

or the page will be automatically redirected to sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon