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.
Unfortunately, activation email could not send to your email. Please try again.

Sync tables in two different sql servers.

Thread ID:

Created:

Updated:

Platform:

Replies:

129958 Apr 11,2017 02:40 PM Apr 13,2017 09:11 AM Data Integration Platform 2
loading
Tags: Data Integration
Birendra Tuladhar
Asked On April 11, 2017 02:40 PM

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 04:59 AM

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. 
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.  

Regards,  
Karthikeyan S   


Karthikeyan SankaraVadivel [Syncfusion]
Replied On April 13, 2017 09:11 AM

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. 

Regards, 
Karthikeyan S  


CONFIRMATION

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.

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.

;